Re: Clean shutdown and warm standby

On Thu, 2009-05-28 at 16:52 +0300, Heikki Linnakangas wrote:

> > If the archiver is working, but has fallen behind at the point of
> > shutdown, does the archiver operate for long enough to ensure we are
> > archived up to the point of the log switch prior to checkpoint?
> 
> Yes, it archives all pending WAL segments before exiting.

I don't think it does, please look again. 

> Ok, we're good then I guess.

No, because as I said, if archive_command has been returning non-zero
then the archive will be incomplete.

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