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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match