How to configure PostgreSQL to accept all incoming connections

Question

I've got a PostgreSQL data base that I'd like to configure to accept all incoming connections regardless of the source IP address. How can this be configured in the pg_hba.conf file? I'm using postgreSQL version 8.4.

Answer 1

Just use 0.0.0.0/0:

host    all             all             0.0.0.0/0            md5

Make sure the listen_addresses in postgresql.conf allows all incoming connections as well:

listen_addresses = '*'

After the changes you have to reload the configuration (as a superuser):

SELECT pg_reload_conf();