On Thu, 2010-05-13 at 09:15 -0700, Wang, Mary Y wrote: > 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.
It entirely depends on your needs. I generally use pg_dump -Fc over a loop to each database. The plain text version of the dump is particularly difficult to work with for partial restores. Joshua D. Drake > > Thanks in advance. > Mary > > > > > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
