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

Posted April 26, 2020 688 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.

Submit an answer

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!