Introduction
How To Configure PostgreSQL To Accept All Incoming Connections?
Procedure
You need to add the following line to the /var/lib/pgsql/data/pg_hba.conf file:
host all all 0.0.0.0/0 md5
And then run the following command to confirm that the changes are made:
grep -Ei "(^\s*host\b)" /var/lib/pgsql/data/pg_hba.conf
The next step would be to modify the main configuration file for PostgreSQL. Open `/var/lib/pgsql/data/postgresql.conf` and then replace the following line:
listen_addresses = '127.0.0.200, localhost' # what IP address(es) to listen on;
With this:
listen_addresses = '*' # what IP address(es) to listen on;
When that's done, you will need to restart the database server with the following script:
/scripts/restartsrv_postgresql