Lists: | pgsql-novice |
---|
From: | christoph(dot)dellavalle(at)goetheanum(dot)ch |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | postmaster generates no socket |
Date: | 2003-06-26 12:09:17 |
Message-ID: | D1ECCF616FF6D611A3C3000102755F45138B87@S2BDCMAIL |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice |
Hi
I can start postmaster, but it does not generate a socket.
I startet the postmaster with -i,
in postgresql.conf I set tcpip_socket=true
unix_socket_directory = '/tmp'
in pg_hba.conf I set the server's and the client's ip-address to trust.
The attempt to connect via PHP4 results in the mesage:
Warning: Unable to connect to PostgreSQL server: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Why does it expect the socket in /var/run/postgresql/ and why does the Postmaster not create any socket at all?
Thanks very much
Christoph Della Valle
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | christoph(dot)dellavalle(at)goetheanum(dot)ch |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: postmaster generates no socket |
Date: | 2003-06-28 02:54:09 |
Message-ID: | 15051.1056768849@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice |
christoph(dot)dellavalle(at)goetheanum(dot)ch writes:
> in postgresql.conf I set tcpip_socket=true
> unix_socket_directory = '/tmp'
okay ...
> The attempt to connect via PHP4 results in the mesage:
> Warning: Unable to connect to PostgreSQL server: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
You seem to be using a nonstandard build of the client-side code that
expects unix_socket_directory to be "/var/run/postgresql". You can
either change the postmaster's setting to agree, or fix the client
to look in /tmp.
regards, tom lane