Re: Yet Another Socket .s.PGSQL.5432 Problem - Mailing list pgsql-admin

From Tom Lane
Subject Re: Yet Another Socket .s.PGSQL.5432 Problem
Date
Msg-id 7891.1187215277@sss.pgh.pa.us
Whole thread Raw
In response to Re: Yet Another Socket .s.PGSQL.5432 Problem  ("Hilton Perantunes" <hperantunes@gmail.com>)
Responses Re: Yet Another Socket .s.PGSQL.5432 Problem  ("Hilton Perantunes" <hperantunes@gmail.com>)
List pgsql-admin
"Hilton Perantunes" <hperantunes@gmail.com> writes:
> When I stop the database, the socket file is automatically removed. That's
> the way it happened before... but now, oddly enough, I restarted the
> database at will several times, my app is still running, pgadmin too... and
> no socket file is created. o.0

Are you sure that's where the database thinks the socket file should be?
/var/run/postgresql is *not* the factory default for this; /tmp is.
If you replaced a distro build with your own or vice versa you may be
confused by that.

Wrong permissions on the directory or its parents could be the
problem, too.

> psql: could not connect to server:
> Is the server running locally and accepting
> connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?

This clip omits the most important part of the message: there should be
a kernel error code after the colon.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Hilton Perantunes"
Date:
Subject: Re: Yet Another Socket .s.PGSQL.5432 Problem
Next
From: Julio Cesar Sánchez González
Date:
Subject: Re: Configure pg_hba.conf