PostgreSQL – Allow Remote Connection to Connect Database

When a client machine tried to connect the PostgreSQL Server, it got an error like “psql:could not connect to server:Connection refused”.
If you need to the connect all clients with PostgreSQL server, you should perform the below two actions.

1. Add client IP-Address ranges into pg_hba.conf :
pg_hba.conf is a configuration file which controls the Client Authentication. This file automatically installed when the data directory is initialized.
Below is a default entry in pg_hba.conf file.

# IPv4 local connections:
host      all        all      md5
# IPv6 local connections:
host      all        all        ::1/128           md5

Example: The client IP-Address is “”.
For connecting this client to PostgreSQL Server, add below entry in the pghba.conf and after that save the file and restart PostgreSQL Service.

host    all         all    md5

2. Change listen_addresses parameter in postgresql.conf :
In the PostgreSQL configuration file (postgresql.conf), by default listen address is ‘localhost’.

listen_addresses = 'localhost'

Change this parameter value from ‘localhost’ to ‘*’ for that all clients can connect from different networks.

listen_addresses = '*'