FATAL: no pg_hba.conf entry for host , user "administrator", database "imdb", SSL off code example

Example: no pg_hba.conf entry for host user database ssl off

Add or edit the following line in your postgresql.conf :

listen_addresses = '*'
Add the following line as the first line of pg_hba.conf. It allows access to all databases for all users with an encrypted password:

# TYPE DATABASE USER CIDR-ADDRESS  METHOD
host  all  all 0.0.0.0/0 md5
Restart Postgresql after adding this with service postgresql restart or the equivalent command for your setup.

Tags:

Misc Example