Postgres Pro
Downloads
Home   >   mailing lists

pg_dumpall for Postgres Database Daily Backup? - Mailing list pgsql-general

From Wang, Mary Y
Subject pg_dumpall for Postgres Database Daily Backup?
Date
Msg-id FA20D4C4FEBFD148B1C0CB09913825FC04588D7B6D@XCH-SW-06V.sw.nos.boeing.com
Whole thread Raw
Responses Re: pg_dumpall for Postgres Database Daily Backup?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: pg_dumpall for Postgres Database Daily Backup?  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Re: pg_dumpall for Postgres Database Daily Backup?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view 
Hi,

I'm running on Postgres 8.3.8.  My system admin is ready to set up a cron job for a daily database backup.
By reading the documentation over here: http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-ALL (I
onlyfound the documentation for 8.3.10), and it looks like pg_dumpall > outfile is the best choice.  I'd like to ask
thecommunity to reconfirm. 

Thanks in advance.
Mary

pgsql-general by date:

Previous
From: S G
Date:
Subject: Re: SQL code runs slower as a stored function
Next
From: Christopher Browne
Date:
Subject: UUID + RPM + 64 bit