How to configure PostgreSQL to accept all incoming connections -


I have found a PostgreSQL data base that I configured the source IP address to accept all incoming connections regardless of Would like to do How can this be configured in the pg_hba.conf file? I am using postgreSQL version 8.4.

Simply use 0.0.0.0/0:

  all Host 0.0.0.0.0 MD5  

Make sure listen_addresses in postgresql.conf also allows all incoming connections:

  After changes You will need to reload the configuration (as the superuser):  
  SELECT pg_reload_conf ();  

Comments