I'm trying to access a postgres database remotely and I can't for the life of me get it to work.
I've installed a Gen 2 linux VM in Azure with Ubuntu 14.04 and installed postgres. SSH works remotely, and psql works fine while remoted in.
Steps I've taken:
'*'and confirmed via
show listen_addressesthat it's listening to
host all all 0.0.0.0/0 md5.
After these steps, I'm able to work with and access psql just fine, but whenever I attempt to remotely connect to the instance via pgAdmin3, I get an error stating that the connection timed out.
Further, when I use a port checker remotely, port 5432 is reported as closed.
What am I missing/doing incorrectly?
Thanks in advance.