pgAdmin III Server doesn't listen

2019-09-19 08:00发布

问题:

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.

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 file:

listen_addresses = '*'
port = 5432
max_connections = 100

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

Any help would be greatly appreciated.

Edit: After running netstat

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

回答1:

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