Re: psql + php on Mac OS X

From: Martin Hampl <Martin(dot)Hampl(at)gmx(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: psql + php on Mac OS X
Date: 2004-03-08 23:20:05
Message-ID: 2224BF0A-7157-11D8-88A0-000393674318@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

It works, hooray! Thank you *very* much!

Regards,
Martin.

Am 08.03.2004 um 23:59 schrieb Tom Lane:

> 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

Browse pgsql-novice by date

  From Date Subject
Next Message Lola Lee 2004-03-09 00:31:44 Re: psql + php on Mac OS X
Previous Message Tom Lane 2004-03-08 22:59:25 Re: psql + php on Mac OS X