FATAL: no pg_hba.conf entry for host
You might get this error on connecting to PostgreSQL server using psql utility.
We can resolve this problem by following the below steps.
Step1: Login to the PostgreSQL server via SSH as root
Step2: Open the PostgreSQL configuration file and add or update following line.
listen_addresses = '*'
This will allow PostgreSQL instance to accept connections through any ipaddress in server.
Step3: Add or modify the following lines in pg_hba.conf.
host all all 0.0.0.0/0 md5
This will allow the users to login with an encrypted password.
Step4: Restart the PostgreSQL service.