Python psycopg2超时 [英] Python psycopg2 timeout

问题描述

我有一个大问题：
我的python软件运行在服务器的路由器上似乎有一些硬件问题。与数据库的连接大约每三遍才成功。因此psycopg2.connect（）最多可能需要5分钟才能收到超时异常。

I have a huge problem: 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 successfull about every third time. So a psycopg2.connect() can take up to 5 minutes before I get an 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 helped, since the connection didn't got established at all.

有一种方法，当出现以下情况时，我可以立即停止程序：连接库

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

推荐答案

在 connect 函数可以使用任何 libpd 支持的连接参数。其中有 connect_timeout 秒数：

When using the keyword arguments syntax to the connect function it is possible to use any of the libpd 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-PARAM关键字

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

连接超时会引发 OperationalError 异常。

A connection time out raises an OperationalError exception.

这篇关于Python psycopg2超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！