Is this mechanism documented anywhere (besides source code)? It looks like PG will only clean it up if there's no other process running at all on the pid listed in the postmaster.pid file, even if any process running on that pid isn't a PG process or there's no server running on the data directory (as per `pg_ctl status`).
On Aug 20 2012, at 1:31 PM, Tom Lane wrote: > Sebastien Boisvert <sebastienboisv...@yahoo.com> writes: >> I vaguely remember reading in the release notes (around the time 9.x was >> released) something about it automatically clearing out the postmaster.pid >> file if it was found to be stale/invalid when starting the the database >> server, however I cannot find any reference to this anymore. > > It's always done that. > > We occasionally see startup scripts that "helpfully" remove the .pid > file. They are, without exception, wrong and dangerous. The postmaster > is much more likely to get this right by itself. > > regards, tom lane > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
