Re: Archiver behavior at shutdown

On Thu, 2007-12-27 at 17:29 -0500, Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > What does postmaster do then? Sleep until archiver is done, or exit
> > immediately and hope that the archiver goes away as soon as it finishes?
>
> I think it can just exit immediately, particularly if we invent the
> variant signal for "archive what you can and then quit".
>
> > If the former, then we open the possibility that postmaster lives far
> > too long before system shutdown decides to SIGKILL it. If the latter,
> > then a subsequent postmaster start could initiate a second archiver
> > process which would cause issues with whatever the first archiver is
> > doing.
>
> That's a problem that the archiver itself should fix (perhaps it needs
> its own lockfile).

http://archives.postgresql.org/pgsql-hackers/2006-05/msg00920.php

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com