Re: Clean shutdown and warm standby

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