Martin Hampl <Martin(dot)Hampl(at)gmx(dot)de> writes:
> Both, PostgreSQL and PHP run just fine. However, if I try to access a
> database I just get the message "Warning: pg_connect(): Unable to
> connect to PostgreSQL server: could not connect to server: Connection
> refused Is the server running on host "localhost" and accepting
> TCP/IP connections on port 5432?"
> PostgreSQL is running and I think it is using port 5432 (however, I am
> not completely sure how to check this---"show port;"?)
My bet is that you have Postgres set to accept only Unix-socket
connections. PHP is evidently trying to connect via a TCP socket.
I think it's possible to alter the PHP connection info to use a
Unix socket, but you might prefer to turn on tcpip_socket in Postgres.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Martin Hampl||Date: 2004-03-08 23:20:05|
|Subject: Re: psql + php on Mac OS X |
|Previous:||From: Martin Hampl||Date: 2004-03-08 21:17:43|
|Subject: psql + php on Mac OS X|