PHP/postgreSQL

From: vince(at)weaktight(dot)com
To: pgsql-php(at)postgresql(dot)org
Subject: PHP/postgreSQL
Date: 2006-02-04 22:14:35
Message-ID: 20060204171435.7lfphylyooggs08c@webmail.weaktight.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

I'm running PHP/mySQL via a web hosting service. I require my PHP scripts to
access an external PostgreSQL database.

I have the PostgreSQL server setup to accept connections from anyone:
[pg_hba_conf]

# TYPE DATABASE USER CIDR-ADDRESS METHOD
host all all 0.0.0.0/0 trust

[--]

I've tested this connection via pgAdminIII and I'm able to connect using this
IP, but when I try to connect via php from the hosted webpage...

My php script is simple:

<?php
$conn_string = "host=24.85.82.xxx port=5432 dbname=PGSQL1 user=postgres
password=xxx";

$dbconn = pg_connect($conn_string);

if ($dbconn) {

print "Successfully connected to: " . pg_host($dbconn) . "<br/>\n";

} else {

print pg_last_error($dbconn);
exit;
}

pg_close($dbconn);
?>

But I'm foiled by:

Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect
to server: Operation timed out Is the server running on host "24.85.82.xxx" and
accepting TCP/IP connections on port 5432? in
/usr/local/psa/home/vhosts/weaktight.com/httpdocs/mytest.php on line 13

Any thoughts or suggestions would be greatly appreciated. I'm not very
experienced with any of this stuff.

Thanks.

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Gavin M. Roy 2006-02-04 23:40:54 Re: PHP/postgreSQL
Previous Message operationsengineer1 2006-02-04 21:41:30 Re: php and postgresql on windows