Re: pg_dumpall for Postgres Database Daily Backup? - Mailing list pgsql-general

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
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. 

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