Re: Fix PID file location?

FOlks,

> The problem seems to be that pg_ctl expects the PID file to be in $PGDATA,
> but the file actually gets written by the postmaster to the actual data
> directory. You can work around this by setting "external_pid_file", but
> this then prevents you from using external_pid_file for another purpose.

More about this: due to the PID file not being in the right place, pg_ctl stop
never reports success:

waiting for postmaster to shut
down............................................................... failed
pg_ctl: postmaster does not shut down

This appears to be because the duplicate PID in the conf directory is not
removed on shutdown.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco