From: | Vivek Khera <khera(at)kcilink(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Backup? |
Date: | 2003-09-04 20:47:52 |
Message-ID: | x74qzsi8lj.fsf@yertle.int.kciLink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>>>> "BTJ" == Bjørn T Johansen <Bj> writes:
BTJ> Should one use pg_dumpall to backup the database or is it more
yes, or pg_dump specific databases.
BTJ> practical to just copy the data directory?
this would do you no good, since the files are not necessarily in a
consistent state when you copy many of them. ie, the copy is
non-atomic, and there is no guarantee that all data is flushed to
disk.
i don't even do a file system dump of my PG data partition because of
this.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2003-09-04 21:46:31 | Re: Activate Index |
Previous Message | Sean Chittenden | 2003-09-04 20:44:37 | Re: searching archives should be a weeeee bit faster ... |