Report this

What is the reason for this report?

Hot to solve "no pg_hba.conf entry for host "ip", user "db-user", database "db-name", SSL off"

Posted on April 26, 2020

I have a nodejs app that I’m migrating to digitalocean. I have been getting the same error since Friday.

I have tried all solutions I’ve seen online but none seems to help. e.g adding droplet ip to trusted sources. I tried removing the sslmode flag too but it doesn’t seem to help at all

This is the error I’m getting after including the DB_URL and running npm start which is to first migrate the managed database. ERROR: no pg_hba.conf entry for host “ip”, user “db-user”, database “db-name”, SSL off

I tried creating another db and user and connecting to it but was still getting the same error.

Please help, How can I solve it? Thanks.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.