| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(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-13 17:00:43 |
| Message-ID: | 1273770043.8624.2984.camel@jd-desktop.unknown.charter.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2010-05-13 17:01:43 | Re: Question about Beta for Windows 64 bits |
| Previous Message | Stephen Frost | 2010-05-13 16:58:48 | Re: SQL code runs slower as a stored function |