Search Postgresql Archives

Re: Backups

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux