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