From:       To:      
Home > Documentation > PostgreSQL

How to bypass error "FATAL: no pg_hba.conf entry for host..."?

To resolve the error you need to find configuration file "pg_hba.conf". Add or edit the following line at the top of this file (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

After the file is updated, restart PostgreSQL server: "postgresql restart".

Have more questions? Contact us