Re: Prevent restored WAL files from being archived again Re: Unnecessary WAL archiving after failover - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Prevent restored WAL files from being archived again Re: Unnecessary WAL archiving after failover
Date
Msg-id CAHGQGwFThu2+_1E7vatysn25RqJbBBt7+EF7oQ=naNYGOc9HSA@mail.gmail.com
Whole thread Raw
In response to Re: Prevent restored WAL files from being archived again Re: Unnecessary WAL archiving after failover  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Out of office
Re: Prevent restored WAL files from being archived again Re: Unnecessary WAL archiving after failover
Re: Prevent restored WAL files from being archived again Re: Unnecessary WAL archiving after failover
List pgsql-hackers
On Thu, Aug 9, 2012 at 8:08 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On 29 July 2012 16:01, Fujii Masao <masao.fujii@gmail.com> wrote:
>
>> Attached patch changes the startup process so that it creates .done file
>> whenever WAL file is successfully restored, whether archive mode is
>> enabled or not. The restored WAL files will not be archived again because
>> of .done file.
>
> The proposed patch works, for archiving only, but I don't like the
> code. It's a partial refactoring of existing code.
>
> I prefer to go for a full re-factoring version for HEAD, and a zero
> refactoring version for 9.2 since we're deep into beta.

Sounds reasonable.

> I've committed the simplified version for 9.2, as well as adding
> support for streaming which you seem to have missed out.

If the streaming case really must be covered, the fix should be backported to
9.1 and 9.0? Because there is the same "problem" in those versions.

But I'm not sure if this fix is right thing to do. I didn't add any code to the
streaming case because the current behavior exists since 9.0 and AFAIR
we've not received the complaints about the behavior. So ISTM changing
that behavior is debatable and looks like 9.3 item rather than 9.2.

Regards,

-- 
Fujii Masao



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: bug of pg_trgm?
Next
From: armin.schoeffmann@aegaeon.de
Date:
Subject: Out of office