Answer the question
In order to leave comments, you need to log in
How to connect to a remote Postgresql server?
I have a Debian 8 server with Postgresql-9.4 installed and a PgAdmin client on my work machine.
When I try to connect from PgAdmin to Postgresql on a remote server I get an error:
Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "52.90.210.0" and accepting TCP/IP connections on port 5432?
In the Postgresql configuration, I specified that it would listen to all addresses
. In pg_hba, it also allowed all ips to work with all databases
. Judging by netstat, postgresql listens on port 5432
iptables -S
-P INPUT ACCEPT
-P FORWARD ACCEPT
-P OUTPUT ACCEPT
После конфигурации сервер был перезагружен.
Answer the question
In order to leave comments, you need to log in
Ребят, всем спасибо за участие. Проблему решил.
Сервер размещен на aws.amazon.com и в настройках instance было разрешение только на подключение по SSH на 22 порт.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question