#31 Restore incremental backup

[Anonymous]

Originally created by: difftus...@gmail.com

What steps will reproduce the problem?

.)I have PG 9.0 Server running on Port=5432.data directory is data1/

I have taken a Full backup successfully.

.)I created a new folder ,say data2 , set the PGDATA path=data2 and restored successfully ..

.)I stopped data2 cluster, started data1 cluster and created some objects

.)now i performed incremental backup while setting   PGDATA path to data1

.) now i performed restored o/p , i again set PGDATA path to data2
restored operation completed successfully  but when i again start my data2 cluster , no table r present which i created later (before taking incremental)

What is the expected output? What do you see instead?

am i  missing something ?  or better documentation ?
What version of the product are you using? On what operating system?

RHLE-5.5
PG 9.2

Please provide any additional information below.

[Anonymous]

Originally posted by: saas...@gmail.com

I think the question can be rephrased as : "how to restore a set of incremental backups to bring the target database up-to-date?"

I think incremental backup means backup of xlog files, after the time when a full back was taken as the first step. So, I guess one would need to extract the incremental backup archive and start recovery inorder to bring the target database up-to-date.
This would be the same procedure for PITR as well, except that we need to mention the recovery-target-time or recovery-target-xid or recovery-target-timeline in case of PITR.