Hi, On Fri, Nov 05, 2004 at 10:26:55PM +0000, Simon Riggs wrote: > That is exactly the situation Timelines are designed to avoid. This > should not have happened. What leads you to think it has? My guess is > that it has not. If it has, its a bug.
Hmm. I did the following: - I recovered to one PIT. - I verified that everything was fine. - If I shut down postmaster now and try to recover to another PIT, everything will work fine. (by re-restoring the original backup as you pointed out) However if I: - Shut down postmaster and restart it in normal mode (without a new recovery.conf) and then do some database operations, it seems to overwrite a file from my archive: [...recovery...] LOG: archive recovery complete LOG: database system is ready LOG: archived transaction log file "00000002.history" Now we are at timeline 2 I guess. [...normal startup...] LOG: checkpoint record is at 0/22701F8 LOG: redo record is at 0/22701F8; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 2595; next OID: 231915 LOG: database system is ready [...I do some database action...] LOG: archived transaction log file "000000010000000000000001" LOG: archived transaction log file "000000020000000000000002" If I stop postmaster again, wipe out my data/ dir and re-restore the original backup, I can't do any PITRs any more... If I re-install my archive as well, it works again. > > My question is: When I've restored up to the time t_0, how can I go on > > to restore up to another point in time, later than t_0 but before the > > end of my log files. > You need to re-restore the original backup. Ah. Ok. I had the impression that the timelines save me from re-restoring the original files and that I could start off directly from there. Ok, that's why it didn't work out that well ;-) Thanks, Joachim ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings