Re: postmaster of 7.0.3 listening but pslq cannot connect - solved

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/

In response to

Responses

Browse pgsql-general by date

  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