pgAdmin III服务器不监听 [英] pgAdmin III Server doesn't listen

问题描述

我知道这个问题已被问过多次，但是在搜索了几个小时并尝试了多种解决方案后，没有任何结果对我有用.

I'm aware that this issue has been asked multiple times, but after searching for hours and trying multiple solutions, nothing has worked for me.

问题:我无法使用pgAdmin III远程连接到我的postgresql-9.3服务器.
Postgres服务器在RHEL6上，而pgAdmin GUI在Windows上.

pg_hba.conf文件: 我最终允许所有连接，直到我发现问题为止.

Issue: I cannot connect remotely to my postgresql-9.3 server using pgAdmin III.
The postgres server is on RHEL6 and pgAdmin GUI is on Windows.

pg_hba.conf file: I've just ended up allowing all connections until I figure out the issue.

local   all             all                                     trust
# IPv4 local connections:
host    all             all             0.0.0.0/0               trust
# IPv6 local connections:
host    all             all             ::1/128                 trust

postgres.conf文件:

postgres.conf file:

listen_addresses = '*'
port = 5432
max_connections = 100

我已经重新启动服务器，而我的postgres用户没有密码. 我可以在本地访问服务器，但不能远程访问.

I have restarted the server, and don't have a password on my postgres user. I can access the server locally, but not remotely.

任何帮助将不胜感激.

运行netstat后

After running netstat

tcp        0      0 0.0.0.0:5432                0.0.0.0:*                   LISTEN      26369/postmaster   

推荐答案

防火墙问题.关闭防火墙，远程连接工作正常.

Firewall issue. Turned off firewall and remote connection worked fine.

这篇关于pgAdmin III服务器不监听的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！