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.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
