I'm having problem connecting to PostgreSQL through Python/Psycopg2.
The PostgreSQL server is running on 192.168.1.6, CentOS 5.5. I can already connect through LAN workstations using Navicat, I'm pretty sure I had the right post opened in iptables.
But when connecting from Python/psycopg2, I got this error
conn = psycopg2.connect(database='test', user='sql', host='184.108.40.206', password='sql') Traceback (most recent call last): File "<pyshell#11>", line 1, in <module> conn = psycopg2.connect(database='test', user='sql', host='220.127.116.11', password='sql') OperationalError: could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "18.104.22.168" and accepting TCP/IP connections on port 5432?
I tried to disable firewall and iptables on both client and server machine, still the same error.