Solution to PostgreSQL FATAL: no pg_hba.conf entry for host Error

If you receive the FATAL: no pg_hba.conf entry for host error when you want to connect to the PostgreSQL service externally in your projects such as PHP, Python, Django, you need to allow external connection to the ph_hba.conf file to solve it.

nano /etc/postgresql/10/main/pg_hba.conf
host all all 0.0.0.0/0 md5

We write the code on the bottom line of the file, save it and close it.

We use the following command to restart the service.

service postgresql restart

You can click for our Türkiye location Reseller packages.