Re: The last WAL segment of the old timeline is not archived for a while after archive recovery

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: The last WAL segment of the old timeline is not archived for a while after archive recovery
Date: 2009-04-23 04:09:30
Message-ID: 3f0b79eb0904222109y69350c3fw6d4d3a6538c49d7a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Thu, Apr 23, 2009 at 4:51 AM, Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
> Fujii Masao wrote:
>>
>> In archive recovery, the last applied WAL segment may not have
>> .ready file in spite of not having been archived yet. Then, this
>> segment is not archived until a future checkpoint creates .ready
>> file. It's a little dangerous that there is the WAL segment which
>> is not archived for a while.
>>
>> Attached patch fixes this problem. Is this worth committing?
>
> Yeah, I think it is. Applied.

Thanks a lot!

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zdenek Kotala 2009-04-23 06:27:54 citex regression fails with de.UTF8 locale
Previous Message Tom Lane 2009-04-23 03:04:41 Re: Prepared transactions vs novice DBAs, again