From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | John Iliffe <john(dot)iliffe(at)iliffe(dot)ca>, Joe Conway <mail(at)joeconway(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unable to connect to Postgresql |
Date: | 2017-04-09 19:05:18 |
Message-ID: | e2b6c867-72c0-f848-9712-4f2629745172@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 04/09/2017 11:33 AM, John Iliffe wrote:
> On Saturday 08 April 2017 18:10:35 Joe Conway wrote:
>> On 04/08/2017 01:23 PM, John Iliffe wrote:
>>> On Saturday 08 April 2017 09:38:07 Adrian Klaver wrote:
>>>> So what if you change the connection to use -h localhost?
>>>
>>> Can you please expand on that request? I'm not sure where you want me
>>> to put that directive. I'm using the mod_php module in Apache.
>>
>> See the second example here:
>>
>> http://php.net/manual/en/function.pg-connect.php
>>
>> 8<-------------
>> $dbconn2 = pg_connect("host=localhost port=5432 dbname=mary");
>> // connect to a database named "mary" on "localhost" at port "5432"
>> 8<-------------
>>
>> That will try to use a tcp connection on localhost instead of a unix
>> socket.
>>
> Thanks Joe. I Changed the pg_connect line in the script to:
>
> --------------------------
> $db_handle = pg_connect('dbname=yrarc host=192.168.1.6 port=5432
> user=xxxx password=xxxxxx');
> ---------------------------
So is this on the machine that has the Postgres server?
If not change to that machine and use host=localhost, otherwise just
change to host=localhost.
>
> Even though "localhost" is in the /etc/hosts file the lookup failed to
> resolve so I provided the full IP address. The error from Apache is:
Can you show us the /etc/host file?
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | John Iliffe | 2017-04-09 19:15:50 | Re: Unable to connect to Postgresql |
Previous Message | Joe Conway | 2017-04-09 18:34:01 | Re: Unable to connect to Postgresql |