Re: Prevent restored WAL files from being archived again Re: Unnecessary WAL archiving after failover

Simon Riggs <simon@2ndquadrant.com>

From: Simon Riggs <simon@2ndQuadrant.com>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: Noah Misch <noah@leadboat.com>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-08-11T07:33:17Z
Lists: pgsql-hackers
On 10 August 2012 18:19, Fujii Masao <masao.fujii@gmail.com> wrote:

>> 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.

True

> 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.

If its a bug with archiving, then why is it not a bug with streaming?

What if you are using archiving and streaming, what then? There isn't
any way of telling the difference between them.

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services