Re: postmaster of 7.0.3 listening but pslq cannot connect - solved - Mailing list pgsql-general

From 100.179370@germanynet.de (Martin Jacobs)
Subject Re: postmaster of 7.0.3 listening but pslq cannot connect - solved
Date
Msg-id m147bRB-000QZhC@Schnecke.Windsbach.de
Whole thread Raw
In response to Re: postmaster of 7.0.3 listening but pslq cannot connect  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: postmaster of 7.0.3 listening but pslq cannot connect - solved
List pgsql-general
Hi,

Peter Eisentraut schrieb:
> Martin Jacobs writes:
>
> > Now, postmaster is listening, I can connect with telnet, netstat
> > tells that there is a connection, but psql fails to connect to
> > any database.

Solution is:

postmaster generates a socket file in dir /tmp named
.s.PGSQL.5432 This file is the culprit. I have a daily cron job
running, which removes aged files in /tmp. The socket file isn't
changed after coming to life, so my remove job deletes it. This
is the reason why psql can't connect to postmaster.

Ok, I can change my cleanup script. But wouldn't it be better to
hide the socket file in a subdirectory as it is done by the X11 font
server and X11: They write their socket files in subdirectories
/tmp/.font-unix and /tmp/.X11-unix

Suggestion: /tmp/.postgres

Comments?

>
> What did you do and what response did you get?
> ...

Martin Jacobs

--
Dipl-Ing. Martin Jacobs * Windsbach * 100.179370@germanynet.de und
martin.jacobs@an-netz.de
Registered Linux User #87175, http://counter.li.org/

pgsql-general by date:

Previous
From: "Mauricio"
Date:
Subject: Postgres Win32
Next
From: Tom Lane
Date:
Subject: Re: postmaster of 7.0.3 listening but pslq cannot connect - solved