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

From Simon Riggs
Subject Re: Clean shutdown and warm standby
Date
Msg-id 1243515975.24860.531.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: Clean shutdown and warm standby  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Clean shutdown and warm standby  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On Thu, 2009-05-28 at 14:04 +0300, Heikki Linnakangas wrote:

> I've committed a patch to do the RequstXLogSwitch() before shutdown 
> checkpoint as discussed. It seems safe to me. (sorry for the delay, and 
> thanks for the reminder)

Not sure if that is a fix that will work in all cases. 

There is a potential timing problem with when the archiver is shutdown:
that may now be fixed in 8.4, see what you think.

Also if archiving is currently stalled, then files will not be
transferred, even if you switch xlogs. So this is at best a partial fix
to the problem and the need for a manual check of file contents
remains. 

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Aidan Van Dyk
Date:
Subject: Re: PostgreSQL Developer meeting minutes up
Next
From: Heikki Linnakangas
Date:
Subject: Re: Clean shutdown and warm standby