PostgreSQL authentication can be controlled using the pg_hba.conf file to specify what IP addresses have access to the postgres database. After making changes to this file you should never reboot the server but instead signal it to reload this configuration file. Follow the below steps to reload.

1. Postgres User: su - postgres
2. Make Changes: vi /var/lib/pgsql/data/pg_hba.conf
3. Reload Configs: pg_ctl reload -D /var/lib/pgsql/data/

Read the rest of this entry »