Are you sure your isp isn't blocking access? First thought to come
to mind is shaw cable might be blocking port 5432. Can you try and
telnet to the box from your server on port 5432? Also check to make
sure pgsql is listening on tcp/ip. Also if you're a home shaw
customer, are you behind a nat router? Have you opened up access on
the nat router to get to your box behind it?
HTH,
Gavin
On Feb 4, 2006, at 2:14 PM, vince@xxxxxxxxxxxxx wrote:
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.
---------------------------(end of
broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
