Re: PITR timeline question

On Aug 3, 2006, at 3:01 PM, Tom Lane wrote:
> Jim Nasby <jnasby@pervasive.com> 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@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461