Horton

pg_dumpall for Postgres Database Daily Backup

Wang, Mary Y <mary.y.wang@boeing.com>

View thread View on postgr.es
From: "Wang, Mary Y" <mary.y.wang@boeing.com>
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2010-05-13T15:50:31Z
Lists: pgsql-general 
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 only found the documentation for 8.3.10), and it looks like pg_dumpall > outfile is the best choice.  I'd like to ask the community to reconfirm.

Thanks in advance.
Mary