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.pidfile, 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 <sebastienboisvert@yahoo.com> writes:
>> I vaguely remember reading in the release notes (around the time 9.x was released) something about it automatically
clearingout the postmaster.pid file if it was found to be stale/invalid when starting the the database server, however
Icannot 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