Message "28000: no pg_hba.conf entry for host \"xx.xxx.xxx.xxxx\", user \"User", database \"databasename\", SSL off"

user_5892650 0
Viewed 5706

I 'm trying to connect postgresql database remotely ( Heroku ). I use ASP Web api but always i have the same exception :Message "28000: no pg_hba.conf entry for host \"xx.xxx.xxx.xxxx\", user \"User", database \"databasename\", SSL off" I search some solution by editing the pg_hba.conf file and i add : host databasename username xx.xxx.xxx.xxxx md5 and no change .

npgsql heroku ssl postgresql asp.net
3 Answers

host all all 0.0.0.0/0 trust

or host all all 192.168.0.0/24 trust

of course, you also need

listen_address = '*'
user_17190660
Related