Re: [HACKERS] Point in Time Recovery - Mailing list pgsql-admin

From Tom Lane
Subject Re: [HACKERS] Point in Time Recovery
Date
Msg-id 14500.1090548084@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Point in Time Recovery  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-admin
Simon Riggs <simon@2ndquadrant.com> writes:
> On Thu, 2004-07-22 at 21:19, Tom Lane wrote:
>> Yeah, I think you are right: presence of recovery.conf should force a
>> WAL scan even if pg_control claims it's shut down.  Fix committed.

> This *should* be possible but I haven't tested it.

I did.

It's really not risky.  The fact that the code doesn't look beyond the
checkpoint record when things seem to be kosher is just a speed
optimization (and probably a rather pointless one...)  We have got to be
able to detect the end of WAL in any case, so we'd just find there are
no more records and stop.

            regards, tom lane

pgsql-admin by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: [HACKERS] Point in Time Recovery
Next
From: "Mario Soto"
Date:
Subject: pg_autovacuum problem