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	May 13, 2010 16:33:32
Msg-id	FA20D4C4FEBFD148B1C0CB09913825FC04588D7B6D@XCH-SW-06V.sw.nos.boeing.com Whole thread Raw
Responses	Re: pg_dumpall for Postgres Database Daily Backup? Re: pg_dumpall for Postgres Database Daily Backup? Re: pg_dumpall for Postgres Database Daily Backup?
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:

From: S G
Date: 13 May 2010, 16:31:40
Subject: Re: SQL code runs slower as a stored function

From: Christopher Browne
Date: 13 May 2010, 16:41:03
Subject: UUID + RPM + 64 bit

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

Previous

Next