How to configure postgresql postgresql.conf listen_addresses for multiple ip addresses [closed]

listen_addresses controls which IPs the server will answer on, not which IPs the server will permit connections to authenticate from. It’s entirely reasonable and normal to use listen_addresses '*' so the server will accept incoming connections on any ip assigned to an interface on the postgresql server host, while using pg_hba.conf to control access at a finer grained level for which IPs the server will accept logins from for specific databases and users.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)