Forum OpenACS Q&A: Response to ConnectDBStart() -- connect failed: not such file or directory

how are you starting PG?  obvious thing to check first is it needs -i specified to listen on TCP sockets.  otherwise at the very least your startup script should show where errors are logged.  (common are /var/log/messages and /tmp/postgres.log)

can you connect with psql?