From: | 100(dot)179370(at)germanynet(dot)de (Martin Jacobs) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postmaster of 7.0.3 listening but pslq cannot connect - solved |
Date: | 2000-12-17 10:53:05 |
Message-ID: | m147bRB-000QZhC@Schnecke.Windsbach.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)179370(at)germanynet(dot)de und
martin(dot)jacobs(at)an-netz(dot)de
Registered Linux User #87175, http://counter.li.org/
From | Date | Subject | |
---|---|---|---|
Next Message | Ing. Michael Petroni | 2000-12-17 11:36:43 | Re: Concurrent transaction problem |
Previous Message | lucian00 | 2000-12-17 06:56:54 | LM devel GLIB2_2 |