Re: BUG #4137: Postgres drives pg_standby %r param to delete WAL file before processing

On Fri, 2008-05-02 at 22:01 +0100, Simon Riggs wrote:
> On Fri, 2008-05-02 at 18:11 +0000, Wojciech Strzalka wrote:

> > Keep archive history : 0000000100000001000000DB and later
> ...................................................^^
> > running restore : OK
>
> Looks like the first message gives and incorrect archive cut-off point.

I confess that I don't fully understand your description of the sequence
of activities you performed. But I do see that a file has been removed
that is *after* the one requested, which should never happen. So this is
a valid bug.

Not managed to recreate this yet, but I'm posting my suggested fix now.
This is a general fix, so will fix any problem with those symptoms.

Please test this and report back. You can do this in two ways:
1. recompile pg_standby only and retry. I enclose a fully patched copy
of pg_standby.c to assist you, in case that helps
2. apply complete patch to postgres source tree and retry

I will attempt to recreate the problem and test this patch also using
method (2)

[Not yet ready to be applied to core, until we get test results.]

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com