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 /etc/postgresql/9.5/main/postgresql.conf
.
I have ran the command service postgresql restart
after making each of the changes.
psql --host=your.azure.ip --port=5432 --user=yourUserName
? I suspect a pgadmin misconfiguration is more likely.pg_hba.conf
, not the one you are editing.