CODEWITHSUNDEEP
pythonpostgresqlconnectiontimeoutpsycopg2
gulden
gulden

Reputation: 585

Python psycopg2 timeout

There seems to be some hardware problems on the router of the server my python software runs on. The connection to the database only is successful about every third time. So a psycopg2.connect() can take up to 5 minutes before I get a timeout exception.

2014-12-23 15:03:12,461 - ERROR - could not connect to server: Connection timed out
    Is the server running on host "172.20.19.1" and accepting

That's the code I'm using:

# Connection to the DB
try:
    db = psycopg2.connect(host=dhost, database=ddatabase,
                          user=duser, password=dpassword)
    cursor = db.cursor(cursor_factory=psycopg2.extras.DictCursor)
    
except psycopg2.DatabaseError, err:
    print(str(err))
    logging.error(str(err))
    logging.info('program terminated')
    sys.exit(1)

I tried some timeout additions for the query, but that didn't help, since the connection didn't get established at all.

Is there a way I can stop the program immediately, when the connection couldn't be established?

Upvotes: 50

Views: 79508

Answers (1)

Clodoaldo Neto
Clodoaldo Neto

Reputation: 125204

When using the keyword arguments syntax to the connect function it is possible to use any of the libpg supported connection parameters. Among those there is connect_timeout in seconds:

db = psycopg2.connect (
    host=dhost, database=ddatabase,
    user=duser, password=dpassword,
    connect_timeout=3
)

http://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-PARAMKEYWORDS

http://initd.org/psycopg/docs/module.html

A connection time out raises an OperationalError exception.

Upvotes: 88

Related Questions