Re: Documentation on PITR still scarce

From: Joachim Wieland <joe(at)mcknight(dot)de>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Documentation on PITR still scarce
Date: 2004-11-06 15:03:27
Message-ID: 20041106150327.GA24022@mcknight.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-11-06 15:21:29 pg buildfarm status update
Previous Message Peter Eisentraut 2004-11-06 13:35:23 Concern about new PL/Perl