In order to accept connections from remote client you need to set the listen_addresses parameter to something other than localhost. For example, if your PostgreSQL server sits on 192.168.1.123 then that could be the value for listen_addresses. If your PostgreSQL server has multiple addresses, you could use * so that remote clients can connect to any of the IP addresses. Or use a comma-delimited list if only some of the IP address should be used when connecting to PostgreSQL.
subscribe via RSS