Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 29 Jan 1998 20:26:32 -0800 (PST)
From:      Simon Shapiro <shimon@simon-shapiro.org>
To:        The Hermit Hacker <scrappy@hub.org>, freebsd-database@FreeBSD.ORG
Subject:   Re: your mail
Message-ID:  <XFMail.980129202632.shimon@simon-shapiro.org>
In-Reply-To: <Pine.NEB.3.95.980129131851.7021T-100000@hub.org>

next in thread | previous in thread | raw e-mail | index | archive | help
I am redirecting to the database list, which is more appropriate.  I think.

On 29-Jan-98 The Hermit Hacker wrote:
> On Thu, 29 Jan 1998, Simon Shapiro wrote:
> 
>> I am on shaky ground here, so be kind to me:
>> 
>> I am trying to get a very new PostgreSQL snapshot to work.
>> One of the things it does is create a UNIX Socket in /tmp.
>> It uses a template to create the ``filename'':
>> 
>> #define UNIXSOCK_PATH(sun,port) \
>>         (sprintf((sun).sun_path, "/tmp/.s.PGSQL.%d", (port)) + \
>>                 sizeof ((sun).sun_family))
>> 
>> This seems to work OK (I traced it in the RDBMS code), up to the bind
>> syscall.  The port is 5432, and the socket gets created as:
>> 
>> srwx------  1 pgsql  bin  0 Jan 27 16:18 /tmp/.s.PGSQL.543
>> 
>> The bind(2) call is:
> 
> 
>       Just curious, but I'm running the snapshot on my 3.0-CURRENT
> machine and I can run the full regression tests without a problem...what
> sort of problem are you experiencing?

Cannot connect.  It looks like either the pg_hba.conf file is incorrect
(including the one which works in 6.2.1), or that the sockets cannot be
opened.  While digging, I see that the filename representing the Unix
socket is wrong (the last digit gets truncated).

I need to try today's snapshot.  Maybe the problem is gone.

----------


Sincerely Yours, 

Simon Shapiro
Shimon@Simon-Shapiro.ORG                      Voice:   503.799.2313



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?XFMail.980129202632.shimon>