Richard Harley wrote: > 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.
pg_dump will be a performance hit, because it consumes disk I/O capacity. You could measure how the system is affected by your current backup. On the other hand, instead of doing an hourly pg_dump, it might be preferable to do a filesystem backup and PITR. That way you have to do a backup only once a day (or week, depends how much traffic you have and how fast you have to restore) and can still recover to an arbitrary point in time. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
