Have a Question?
Categories
< All Topics
Print

Remote clients cannot connect to PostgreSQL database

A Collective Data client on the same computer as the Postgresql database can connect, but remote clients cannot.

The two most common causes of this are the following:

The computer that has the Postgresql database installed on it has a firewall running. Add port 5432 to the firewall’s exceptions.

Postgresql database is not configured by default to accept remote connections. To allow for other clients to connect to the PostgreSQL database, you will need to make a change to a configuration file. On the server where the collectiveServer is installed, open the pg_hba.conf file in the C:\Program Files\PostgreSQL\8.2\data directory. Edit the file by adding the second entry/line shown below. This will allow for all connections.

# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 0.0.0.0/0 md5

If postgresql is installed on another computer follow the same workflow.

Table of Contents