postgres launch daemon not working

[Scott Frankel]

Hi all,

I've been unable to get launchctl to start the PostgreSQL server, even though the daemon appears to be loading.

First I installed postgresql84 @8.4.10_0, but it appeared that a launch daemon plist file was not included with the installation.

Google searches suggested that the plist file comes with the server, so I installed postgresql84-server @8.4.10_0, which indeed installed the plist file.  In contrast with installing '84, '84-server took only moments to complete installation.

Invoking launchctl to load the plist file, rebooting or not, then calling `psql` yields the familiar error:

	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"?


Thinking that the launch daemon was not loaded, I tried loading it again:

	% sudo launchctl load -w /Library/LaunchDaemons/org.macports.postgresql84-server.plist

only to find that it was already loaded:

	org.macports.postgresql84-server: Already loaded

The plist file specifies /opt/local/bin/daemondo, which I confirmed exists and is executable on my machine.  I currently have both postgres variants active:

  postgresql84 @8.4.10_0 (active)
  postgresql84-server @8.4.10_0 (active)


Any suggestions?

Thanks in advance!
Scott