pg_connect

[rhaggert]

doing pg_connect from the local mahcine works fine... but now i am on another server and no matter what the connection string is i can't seem to connect

this is where i am at

Warning: pg_connect() unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host xxxx.xxx.xxx and accepting TCP/IP connections on port 5432? in index.php on line 5

thanks for any help

[Sxooter]

You need to make two changes to your postgresql config to allow it to share its data with the world.

As the postgres super user, you need to first edit $PGDATA/postgresql.conf and change the line
#tcpip_socket = false

to look like:

tcpip_socket = true

Then edit $PGDATA/pg_hba.conf and add a line something like this at the end:

host all 192.168.120.1 255.255.255.255 password

The pg_hba.conf file is self documenting, so read it a bit to see if password is what you want, or trust, or md5 or etc...