1

Currently I need to establish remote connection with my server (Ubuntu 16.04 LTS). I Install Postgresql and I made the following settings:

/etc/postgresql/9.5/main/postgresql.conf: 

listen_addresses='*'

/etc/postgresql/9.5/main/pg_hba.conf: 

host    all             all             0.0.0.0/0               md5

If run this command: netstat -anpt | grep LISTEN shows the port is listening enter image description here

but when I try to establish the connection, I have this error: enter image description here

And this tool tells me that the port is closed: enter image description here

Rul
  • 157
  • 1
  • 2
  • 10

1 Answers1

4

Allowing only on Configurations of Postgresql server is not enough. You need to add a firewall rule in google compute engine. Check this

Firewall rules control incoming or outgoing traffic to an instance. By default, incoming traffic from outside your network is blocked.

Marlon Abeykoon
  • 11,927
  • 4
  • 54
  • 75
  • It works, Thank you!! [Config from gCloud](https://imgur.com/a/nmJd6) [info from my console](https://imgur.com/a/Ee2QK) – Rul Sep 10 '17 at 17:22