basebackup + WAL archive lets you do just exactly this. you can
restore to any transaction between when that basebackup was taken, and
the latest entry in the WAL archive, its referred in the documentation
as PITR, Point in Time Recovery.
Yes John I do know about using WAL archive. IMO that will not be as fast as
restoring
using the incremental backup. Eg:
It is common to take a full backup on weekends and incremental on
weeknights. If we have to restore
upto Thu afternoon, which one do you think will be faster :-
1 - Restore from basebackup.
2 - Restore from wed night backup
3 - Apply WAL logs after wed night backup until the time we want to restore.
vs
1 - Restore from basebackup
2 - Apply WAL logs from weekend until the time we want to restore.
If first choice is lot faster in Oracle,DB2, I have reasons to believe that
the same should be true for PG also. But as someone explained, the PG
technology can not support this.
Anyhow it was an academical question.
--
View this message in context: http://www.postgresql-archive.org/Incremental-Level-1-backup-in-PG-tp5951072p5951147.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.