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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
