Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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='192.198.1.6', password='sql')

Traceback (most recent call last):
  File "<pyshell#11>", line 1, in <module>
    conn = psycopg2.connect(database='test', user='sql', host='192.198.1.6', password='sql')
OperationalError: could not connect to server: Connection timed out (0x0000274C/10060)
        Is the server running on host "192.198.1.6" 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.

share|improve this question

1 Answer 1

LAN? 192.198.1.6? You see the error?
Try:

192.168.1.6

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.