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

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.


Hello, were you able to solve this problem?

I am having the same issue but from a .net app in DO’s kubernetes cluster.

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!

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.

I’d like to plus one this question as well