Thread: postmaster generates no socket

postmaster generates no socket

From
christoph.dellavalle@goetheanum.ch
Date:
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
runninglocally 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

Re: postmaster generates no socket

From
Tom Lane
Date:
christoph.dellavalle@goetheanum.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
runninglocally 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