I get the following error when trying to connect:
"FATAL: no pg_hba.conf entry for host "", user "postgres", database "postgres", SSL off"
The db is installed on an Ubuntu machine in Azure. I have allowed inbound connections on port 5432, so there should be no issue there however.
I have edited and added the following lines to the
/etc/postgresql/9.5/main/pg_hba.conf file on the server:
host all all 0.0.0.0/0 md5 hostssl all all 0.0.0.0/0 md5
even when I tried to change the mode to trust, I couldn't get a connection established.
I also edited the listen addresses to be:
"listen_addresses = '*'" in
I have ran the command
service postgresql restart after making each of the changes.