Update hba_file.conf
psql -U postgres -d postgres -c "show hba_file"
Add "all" to allow all, otherwise for access that is more restrictive specify a specific database, user and IP address for all connections to the database. For the address field append /32 for IPv4 addresses and /128 for IPv6 addresses.
# TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host INOW inuser <<inserver ipaddress>>/32 md5 host all all 127.0.0.1/32 md5
Update postgresql.conf
To update postgresql.conf, modify the listener_addresses and max_connections parameters.
Note: Changes to this file require a PostgreSQL Server
restart.
#------------------------------------------------------------------------------ # CONNECTIONS AND AUTHENTICATION #------------------------------------------------------------------------------ # - Connection Settings - listen_addresses = '*' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost'; use '*' for all # (change requires restart) port = 5432 # (change requires restart) max_connections = 300 # (change requires restart)