pgAdmin3 connection problems
I'm recently setting up and running a Windows 2008 r2 server with VMware Workstation 8.
I'm running a Centos 6.2 virtual linux box with Postgresql 9.1. Everything seems ok locally and I can connect to the CentOS box via a bridged network connection.
I have followed David Ghedini's walkthrough for setting up Postgresql 9.1. So I am able to start a putty session window, log in as root and start psql shell and issue statements as postgres user. My problem is that I cannot connect using pgAdmin III from my Windows 7 client. I have updated the /var/lib/pgsql/9.1/data/postgresql.conf to enable listen_addresses '*', etc.
Could anyone give me any tips on finding my fault. Have ensured Windows Firewall is disabled on the Windows server, too.
The pgAdmin III client reports;
'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 "192.168.1.26" and accepting TCP/IP connections on port 5432?
This is the pg_hba.conf file entry added:
#TYPE DATABASE USER ADDRESS METHOD
host all all 192.168.1.0/24 trust
And the iptables file entries added:
-A INPUT -p tcp -s 0/0 --sport 1024:65535 -d 192.168.1.26 --dport 5432 -m state --state NEW,ESTABLISHED -j ACCEPT
-A OUTPUT -p tcp -s 192.168.1.26 --sport 5432 -d 0/0 --dport 1024:65535 -m state --state ESTABLISHED -j ACCEPT
Answer
You need to adjust pg_hba.conf:
http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html
Once you add your own host and corresponding user, restart postgresql server so hopefully you can connect.
Also you might need to enable it's port on the network: http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html