Hao Wang wrote:
> My purpose is not to do backup for my database.
I understood that. It was just a side comment.
> I just want to copy the whole db3 database to another
> machine and restore it. That database could be very large so I think
directly copy is more efficient
> than pg_dump. So I'd like to do some test to see if this way works.
If it doesn't work, I will
> consider to use pg_dump.
Any attempt to make a file system copy of a live system without
doing PITR will very likely cause data corruption.
You'll have to use pg_dump.
Yours,
Laurenz Albe