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.