PostgreSQL: Set listen_addresses for multiple Host Addresses

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

If you are facing any connection issue with PostgreSQL, you can find a solution like “make it listen_addresses = *”. I observed this configuration in many client machines which is not good for security purpose.

PostgreSQL: How to Allow Remote Connection to Connect Database

People are doing because more than one host accessing PostgreSQL Database, but there is a solution of this.

PostgreSQL people are wondering about the option like “Can we give multiple host addresses in listen_addresses?”

The answer is YES. If you have more than one client host, you must provide the list of host addresses with comma separated values.

Example: