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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
