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
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
This is conceptually PITR.
In response to
pgsql-admin by date
|Next:||From: Kevin Grittner||Date: 2010-01-20 11:48:23|
|Subject: Re: PostgreSQL backup idea|
|Previous:||From: Renato Oliveira||Date: 2010-01-20 09:24:57|
|Subject: PostgreSQL backup idea|