Problems With Bad PID and Missing Socket

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problems With Bad PID and Missing Socket
Date: 2008-12-08 21:58:42
Message-ID: Pine.LNX.4.64.0812081354270.16841@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I upgraded the distribution on my system and am now having problems
opening a local application. /var/log/apache/error.log shows:

Error: 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"?
Compilation failed in require at /usr/local/sql-ledger/login.pl line 85.
[Sat Nov 29 11:50:17 2008] [notice] caught SIGTERM, shutting down

While I thought I had saved the solution message from the last time this
happened, I did not do so. After stopping and restarting postgresql, there
is no domain socket .s.PGSQL.5432 in /tmp. How do I get it back?

Perhaps related to this, when I restart postgres I see:

Starting PostgreSQL
19895
PostgreSQL daemon already running

and I don't understand why the daemon is already running if I shut down the
application.

Rich

--
Richard B. Shepard, Ph.D. | Integrity Credibility
Applied Ecosystem Services, Inc. | Innovation
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2008-12-08 22:14:07 Re: Problems With Bad PID and Missing Socket -- UPDATE
Previous Message Tom Lane 2008-12-08 21:42:02 Re: Possible bug with ALTER LANGUAGE ... OWNER TO ...