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

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Prevent restored WAL files from being archived again Re: Unnecessary WAL archiving after failover
Дата
Msg-id CAHGQGwFThu2+_1E7vatysn25RqJbBBt7+EF7oQ=naNYGOc9HSA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Prevent restored WAL files from being archived again Re: Unnecessary WAL archiving after failover  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы 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
Список 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 по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: bug of pg_trgm?
Следующее
От: armin.schoeffmann@aegaeon.de
Дата:
Сообщение: Out of office