[cobalt-users] [RaQ4r] Connecting to PostgreSQL from remote

["Robert Fitzpatrick" <robert@xxxxxxxxxxx>]

I continue to have a problem connecting to Postgres from another 
location. Using phpPgAdmin, if I setup access to a second RaQ from one 
running phpPgAdmin and select the second rack from the list, I get:

Warning: Unable to connect to PostgreSQL server: PQconnectPoll() -- 
connect() failed: Connection refused Is the postmaster running (with -
i) at 'zeus.webtent.net' and accepting connections on TCP/IP 
port '5432'? in /home/sites/home/web/phpPgAdmin/lib.inc.php on line 196
Error - /home/sites/home/web/phpPgAdmin/lib.inc.php -- Line: 224
PostgreSQL said: Unable to connect to server

However, if I put phpPgAdmin directly on that second rack, it connects 
without error. I have also tried to connect using the ODBC driver for 
Postgres from a W2K server, the response is 'Unable to connect to 
server'.

It seems there is something in the Postgres config that is not 
allowing connections from the outside. I have used Webmin to go in and 
setup Allowed Hosts for the macine connecting, with no luck. I know 
the user authentication is OK because they work when phpPgAdmin is 
setup locally.

Anybody been able to connect to their Postgres database from another 
machine or have an idea what it takes?

--
Robert