Skip site navigation (1) Skip section navigation (2)

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

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Wojciech Strzalka <wstrzalka(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4137: Postgres drives pg_standby %r param todelete WAL file before processing
Date: 2008-05-03 11:29:16
Message-ID: 1209814156.4264.256.camel@ebony.site (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Attachment: standby_restartbug.v1.patch
Description: text/x-patch (3.4 KB)
Attachment: pg_standby.c
Description: text/x-csrc (17.2 KB)

In response to

Responses

pgsql-bugs by date

Next:From: Mathias SeilerDate: 2008-05-03 21:27:16
Subject: BUG #4141: Aliases in rules vanished, but they work
Previous:From: Simon RiggsDate: 2008-05-02 21:01:42
Subject: Re: BUG #4137: Postgres drives pg_standby %r param todelete WAL file before processing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group