Skip site navigation (1) Skip section navigation (2)

Re: Clean shutdown and warm standby

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Clean shutdown and warm standby
Date: 2009-05-28 13:19:33
Message-ID: (view raw or whole thread)
Lists: pgsql-hackers
Simon Riggs wrote:
> 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.

Can you elaborate?

> 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. 

Yep. Maybe we should print the filename of the last WAL segment to the 
log at shutdown, so that you can easily check that you have everything 
in the archive.

   Heikki Linnakangas

In response to


pgsql-hackers by date

Next:From: Simon RiggsDate: 2009-05-28 13:29:27
Subject: Re: Clean shutdown and warm standby
Previous:From: Simon RiggsDate: 2009-05-28 13:06:15
Subject: Re: Clean shutdown and warm standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group