Forum OpenACS Q&A: Re: server security...

15: Re: server security... (response to 9)
Posted by Randy O'Meara on
: Error: Ns_PgOpenDb(postgres):  Could not connect to
: localhost::MyServer:  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"?

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