Forum OpenACS Q&A: Re: server security...
: localhost::MyServer: could not connect to server:
: No such file or directory
: Is the server running locally and accepting
: connections on Unix domain socket
On RH (and probably others also), in /etc/rc.d/rc.sysinit, add the third line below. The first two should already be there. This will clean out a leftover .pid file and allow the /etc/rc.d/init.d/postgresql startup script to start PG on boot.
# Delete Postgres sockets
rm -f /tmp/.s.PGSQL.*
rm -f ~postgres/data/*.pid