Postgres Pro
Downloads
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
Msg-id FA20D4C4FEBFD148B1C0CB09913825FC04588D7B4E@XCH-SW-06V.sw.nos.boeing.com
Whole thread Raw
Responses Re: pg_dumpall for Postgres Database Daily Backup  (Vick Khera <vivek@khera.org>)
Re: pg_dumpall for Postgres Database Daily Backup  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: pg_dumpall for Postgres Database Daily Backup  (Adrian von Bidder <avbidder@fortytwo.ch>)
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:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Documentation availability as a single page of text
Next
From: Richard Broersma
Date:
Subject: Re: [KB] Information required - Thanks