Post-Reboot Issue: Postmaster Not Accessible

Rich Shepard <rshepard@xxxxxxxxxxxxxxx> · Wed, 28 Feb 2007 07:13:26 -0800 (PST)

  After having to reboot my server/workstation this morning, I've a problem with
postgresql; one I've never before encountered.

  The postmaster is running:

9959 pts/1    S      0:00 /usr/bin/postmaster -D /var/lib/pgsql/data

and the socket is present:

srwxrwxrwx 1 root root 0 2007-02-28 05:20 /tmp/.s.PGSQL.5432=

  But I cannot connect to the database for SQL-Ledger nor from the command
line:

[rshepard@salmo ~]$ psql
psql: could not connect to server: Connection refused
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

  The server is running locally. How can I test whether it's accepting
connections on the socket? And, what can I do to get it back to normal and
accpting connections?

Thanks,

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863