Re: Documentation on PITR still scarce - Mailing list pgsql-hackers

From Joachim Wieland
Subject Re: Documentation on PITR still scarce
Date
Msg-id 20041106150327.GA24022@mcknight.de
Whole thread Raw
In response to Re: Documentation on PITR still scarce  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Documentation on PITR still scarce
List pgsql-hackers
Hi,

On Sat, Nov 06, 2004 at 11:13:34AM +0000, Simon Riggs wrote:
> The timeline code only comes into effect when you request an archive
> recovery. If you do not, it has no way of knowing it "should have".

Ok. However these details should be added to the docs as well.
At least a short warning should show up in 22.3.3 7.


> Once you have brought up a database in timeline N+1, you can't use it as
> the base to recover to a point in timeline N because the data file
> contents cannot be trusted to be identical to the way they were in
> timeline N.

You mean "in timeline N ... to a point in timeline N+1", don't you?


> Re-restoring the backup sounds like a thing that
> needs-optimization, but it is required for transactional correctness.
> [There is some slight area of improvement, but I don't wish to explain
> this because it might lure people into error by mentioning it...the code
> currently requires re-restoring]

Ok.


Thanks for all your explanations,
Joachim





pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Concern about new PL/Perl
Next
From: Andrew Dunstan
Date:
Subject: pg buildfarm status update