why can't I access my postgres from remote?

2

I have a Postgres 10.3 Server installed on an Ubuntu Server.

I did the necessary settings, which always had been enough to be able to access it from PGAdmin from my Laptop, but this time it doesn't work.

I tried the following steps:

listen_addresses = '*'
host all all 0.0.0.0/0 trust
ufw allow 5432
Postgresql restarted
Server rebooted
Server pinged with success
Restarted the VPN-Client
direct IP instead of VPN-IP
disabled IPTABLES

Locally I can connect to the server, but remote is still not working.

When I try to connect, it doesn't seem, that postgres is blocking it, but something before:

Unable to connect to server:

could not connect to server: Connection timed out (0x0000274C/10060)
Is the server running on host "10.8.0.50" and accepting
TCP/IP connections on port 5432?

What can be the reason?

postgresql
timeout
remote-access
asked on Stack Overflow Apr 19, 2018 by Timo Treichel • edited Sep 25, 2018 by Jason Aller

1 Answer

2

When the server were set up, Plesk were installed.

Plesk had an own firewall, which denied the connection. After allowing it, it worked flawless.

answered on Stack Overflow Apr 20, 2018 by Timo Treichel

User contributions licensed under CC BY-SA 3.0