pg_dumpall for Postgres Database Daily Backup?

From: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: pg_dumpall for Postgres Database Daily Backup?
Date: 2010-05-13 16:15:26
Message-ID: FA20D4C4FEBFD148B1C0CB09913825FC04588D7B6D@XCH-SW-06V.sw.nos.boeing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma 2010-05-13 16:30:35 Re: [KB] Information required - Thanks
Previous Message Peter Eisentraut 2010-05-13 16:10:21 Re: Documentation availability as a single page of text