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

Posted April 26, 2020 1.4k views
DigitalOcean Managed PostgreSQL Database

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 DBURL 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.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

I’d like to plus one this question as well