On Thu, Mar 15, 2012 at 6:15 AM, Richard Harley <richard@scholarpack.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.