Renato Oliveira wrote: > Dear all, > > I have been thinking about PostgreSQL backup for some time now. > > I can't implement PITR right now on our live systems, for commercial > reasons. I think you need to rethink this one... > 4 - Backup instead of time use transactionID Do a full backup, mark > what was the last transactionID to the minute of backup finish and > then onwards to backups only for the updated transactionIDs. For > example: Full backup finishes at 13:00, the last transactionID at > 13:00 would be 00013, then from 13:01 onwards backup the updates, so > on. This is conceptually PITR. -- Jesper -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
