| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | richard(at)scholarpack(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Backups |
| Date: | 2012-03-15 14:25:15 |
| Message-ID: | CAOR=d=0DZuUfkSWrMovQanYhoaPVkRnXEP4-Tg2UsDgCF+h1BQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Mar 15, 2012 at 6:15 AM, Richard Harley <richard(at)scholarpack(dot)com> wrote:
> Hello all
>
> Very simple question - does pg_dump/dumpall hit the server in terms of
> database performance? We currently do nightly backups and I want to move to
> hourly backups but not at the expense of hogging all the resources for 5
> mins.
>
> Pg_dumpall is currently producing a 1GB file - that's the combined size of
> around 30 databases and it takes around 5 mins to run.
I'd suggest you look at using PITR backups.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-03-15 14:27:09 | Re: yum repository packages 9.0 and 9.1 libpq conflict |
| Previous Message | Ivan | 2012-03-15 14:22:25 | undo update |