| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Wang, Hao *EXTERN*" <Hao(dot)Wang(at)emc(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: File system level copy |
| Date: | 2012-11-15 09:53:40 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C208AF0CBE@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vishalakshi Navaneethakrishnan | 2012-11-15 11:11:38 | Postgres Index |
| Previous Message | hari.fuchs | 2012-11-15 09:17:54 | Re: Finding first free time from reservations table |