On Aug 3, 2006, at 3:01 PM, Tom Lane wrote:
Jim Nasby <jnasby@xxxxxxxxxxxxx> writes:
If you're using multiple timelines with PITR, do you have to re-copy
all the data files into the cluster every time you start a new
timeline? Or can you copy the data files out of the backup once, and
then perform multiple recoveries, each to different timelines?
The only way to "roll time backwards" is to replace the data directory
with a backup, so if I understand your question correctly, the answer
is no.
Well, specifically I was thinking of...
Roll PITR forward and start database
Do a bunch of stuff
Got more WAL files... start database back in recovery and roll
forward to end of new WAL files (throwing away everything that was
done previously).
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
