On 06/30/10 12:37 AM, RP Khare wrote:
Is there any way to schedule PGSQL databases backups? I want to take hourly dumps of my production database.
if those are your backup requirements, you should take a look at PITR, Point In Time Recovery, where you take just an occasional full database dump, then archive WAL logs which record the changes to the database, minute by minute.
these logs can be used to play back the database transactions to any specific Point In Time.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
