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