Postgres 8.2 port can not be re-started via launchctl

[decibel (Jim Nasby)]

decibel@platter.1[23:31]~:5%sudo launchctl stop org.macports.postgresql82-server
decibel@platter.1[23:31]~:6%ps auxww | grep postgresql
decibel  23392   0.0 -0.0    27328    424  p6  R+   11:31PM   0:00.00 grep postgresql
decibel@platter.1[23:31]~:7%

(note that it takes serveral tries to actually get the daemondo process to stay dead)

decibel@platter.1[23:32]~:10%sudo launchctl start org.macports.postgresql82-server
decibel@platter.1[23:34]~:11%ps auxww | grep postgresql
root     23393   0.0 -0.0    27904    748  ??  Ss   11:31PM   0:00.02 /opt/local/bin/daemondo --label=postgresql82-server --start-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql82-server/postgresql82-server.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql82-server/postgresql82-server.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql82-server/postgresql82-server.wrapper restart ; --pid=none
decibel  23451   0.0 -0.0    27368    444  p6  S+   11:34PM   0:00.00 grep postgresql
decibel@platter.1[23:34]~:12%psql
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
decibel@platter.1[23:34]~:13%

Now the daemondo process is running, but it hasn't started postgres for some reason. Sending a SIGHUP doesn't help. Killing daemondo just results in another one being re-spawned, presumably by launchctl.

[decibel (Jim Nasby)]

launchctl load doesn't help either...

decibel@platter.1[23:39]/opt/local/etc/LaunchDaemons:33%sudo launchctl load -w org.macports.postgresql82-server/org.macports.postgresql82-server.plist org.macports.postgresql82-server: Already loaded decibel@platter.1[23:39]/opt/local/etc/LaunchDaemons:34%

[decibel (Jim Nasby)]

Ok, turns out this is a PEBKAC error... :)

For people looking at this, make sure you check the postgresql log file for problems. (Might be worth adding that advice to the pages describing launchctl and daemondo).

[(none)]

Milestone Port Bugs deleted