Re: Clean shutdown and warm standby - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Clean shutdown and warm standby
Date
Msg-id 49F59A49.2020409@enterprisedb.com
Whole thread Raw
In response to Re: Clean shutdown and warm standby  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: Clean shutdown and warm standby  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
Fujii Masao wrote:
> On Fri, Apr 24, 2009 at 3:20 PM, Heikki Linnakangas
> <heikki.linnakangas@enterprisedb.com> wrote:
>> It's not safe to write WAL after the checkpoint, as RequestXLogSwitch()
>> does. After restart, the system will start inserting WAL from the checkpoint
>> redo point, which is just before the XLOG_SWITCH record, and will overwrite
>> it.
> 
> Since, in this case, the WAL file including XLOG_SWITCH exists
> in archive, I don't think that it's unsafe, i.e. XLOG_SWITCH would
> be treated as the last applied record and not be overwritten. WAL
> records would start to be inserted from the subsequent file (with
> new timeline).

It will be overwritten in a normal non-archive-recovery startup.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Clean shutdown and warm standby
Next
From: Fujii Masao
Date:
Subject: Re: Clean shutdown and warm standby