| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_dumpall for Postgres Database Daily Backup |
| Date: | 2010-05-14 00:16:18 |
| Message-ID: | AANLkTin4XNKbr9-IEe5CnDdlF1I4g55WXKm4MXoJjlkC@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, May 13, 2010 at 9:50 AM, Wang, Mary Y <mary(dot)y(dot)wang(at)boeing(dot)com> 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.
That will work. So will pg_dumpall | gzip > filename.gz if you want
compression.
What's more important is that you first prove your backups are working
by restoring them elsewhere, then check every month or so to make sure
they're still happening.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2010-05-14 00:21:30 | Re: Clustering, parallelised operating system, super-computing |
| Previous Message | David Fetter | 2010-05-14 00:14:36 | Re: Pulling data from a constraint def |