On Aug 3, 2006, at 3:01 PM, Tom Lane wrote:
Jim Nasby <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
