Hi,
I have a couple of postgresql servers running and they work great with
putty and ssh tunneling combined with pgadmin. I have one problem server
though and I am looking for help.
My public IP is firewalled, and I port forward port 5432. My server IP
at 192.168.100.18 works fine with code residing on the server itself,
connecting via localhost.
My pg_hba.conf contains the following setup:
local all all md5
host all all 127.0.0.1 255.255.255.255 md5
host all all 192.168.100.18 255.255.255.255 md5
host all all 66.66.66.66 255.255.255.255 md5
host all all 77.77.77.77 255.255.255.255 md5
Where 66.66.66.66 is my local public IP and 77.77.77.77 is my public IP
for the firewall and hence the server.
Usually I setup my putty connection to tunnel a port like 35432 to the
public IP of the postgresql server, say 77.77.77.77:5432
And in pgadmin I connect to localhost on port 35432 and all is well,
when I do not have a firewall in the chain...
In my case with the firewall, even with port forwarding setup for port
5432, pgAdmin times out after 5 minutes or so complaining about SSL
handshake not working...
I have installed a server.crt and server.key file in the pgsql/data
directory and the server seems to work fine with ssl_enabled in the
postgresql.conf file, and tcp enabled.
What might be causing pgAdmin these connection problems... I am not sure
if the firewall is the culprit or if I screwed up something with SSL...
Any insight most appreciated...
Dave