Re: Yet Another Socket .s.PGSQL.5432 Problem

Tom, really... the socket lies in /tmp/. The socket file has 0777
postgres:postgres. /tmp/ has 0777 root:root.

The socket file is removed when I stop the database.

On 8/15/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Hilton Perantunes" <hperantunes(at)gmail(dot)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
>

--
Hilton William Ganzo Perantunes
Sistemas de Informação - Universidade Federal de Santa Catarina
--
Dinheiro não traz felicidade, mas dá uma sensação tão parecida... -_-