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 15:50:31
Message-ID: FA20D4C4FEBFD148B1C0CB09913825FC04588D7B4E@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 S G 2010-05-13 15:59:37 SQL code runs slower as a stored function
Previous Message Christopher Browne 2010-05-13 15:32:39 UUID + RPM + 64 bit