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 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5
Example: The client IP-Address is “10.0.0.12”.
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 10.0.0.12/24 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 = '*'