我有一个在Windows 7上运行的Postgres 9.2作为服务。 每天数据库似乎停止,有时它开始单独运行,有时我需要重新启动服务。 没有太多的日志信息,我没有安装在这台电脑上的防病毒,防火墙。 我试图改善日志信息,但没有多大帮助。
我无法在Internet上find同样的问题,或者在serverfault上找不到这个问题。
有一些日志信息:
2016-09-08 06:25:27 BRT [unknown] LOG:XX000:无法接收数据
from client: unrecognized winsock error 10061 2016-09-08 06:25:27 BRT [unknown] LOCATION: pq_recvbuf, src\backend\libpq\pqcomm.c:831 2016-09-08 06:25:27 BRT [unknown] LOG: XX000: could not receive data from client: unrecognized winsock error 10061 2016-09-08 06:25:27 BRT [unknown] LOCATION: pq_recvbuf, src\backend\libpq\pqcomm.c:831 2016-09-08 06:55:39 BRT [unknown] LOG: XX000: could not receive data from client: unrecognized winsock error 10061 2016-09-08 06:55:39 BRT [unknown] LOCATION: pq_recvbuf, src\backend\libpq\pqcomm.c:831 2016-09-08 06:55:39 BRT [unknown] LOG: XX000: could not receive data from client: unrecognized winsock error 10061 2016-09-08 06:55:39 BRT [unknown] LOCATION: pq_recvbuf, src\backend\libpq\pqcomm.c:831 2016-09-08 07:15:25 BRT [unknown] LOG: XX000: could not receive data from client: unrecognized winsock error 10061 2016-09-08 07:15:25 BRT [unknown] LOCATION: pq_recvbuf, src\backend\libpq\pqcomm.c:831 2016-09-08 07:15:25 BRT [unknown] LOG: XX000: could not receive data from client: unrecognized winsock error 10061 2016-09-08 07:15:25 BRT [unknown] LOCATION: pq_recvbuf, src\backend\libpq\pqcomm.c:831 2016-09-08 10:59:20 BRT [unknown] LOG: XX000: could not receive data from client: unrecognized winsock error 10061 2016-09-08 10:59:20 BRT [unknown] LOCATION: pq_recvbuf, src\backend\libpq\pqcomm.c:831 2016-09-08 10:59:20 BRT [unknown] LOG: XX000: could not receive data from client: unrecognized winsock error 10061 2016-09-08 10:59:20 BRT [unknown] LOCATION: pq_recvbuf, src\backend\libpq\pqcomm.c:831 2016-09-08 11:14:55 BRT [unknown] LOG: XX000: could not receive data from client: unrecognized winsock error 10061 2016-09-08 11:14:55 BRT [unknown] LOCATION: pq_recvbuf, src\backend\libpq\pqcomm.c:831 2016-09-08 11:14:55 BRT [unknown] LOG: XX000: could not receive data from client: unrecognized winsock error 10061 2016-09-08 11:14:55 BRT [unknown] LOCATION: pq_recvbuf, src\backend\libpq\pqcomm.c:831 2016-09-08 11:16:08 BRT [unknown] LOG: XX000: could not receive data from client: unrecognized winsock error 10061 2016-09-08 11:16:08 BRT [unknown] LOCATION: pq_recvbuf, src\backend\libpq\pqcomm.c:831 2016-09-08 11:16:08 BRT [unknown] LOG: XX000: could not receive data from client: unrecognized winsock error 10061 2016-09-08 11:16:08 BRT [unknown] LOCATION: pq_recvbuf, src\backend\libpq\pqcomm.c:831
如果我使用服务器状态窗口打开PgAdmin III,我也会收到这些消息。
有小费吗?
谢谢
首先,在台式机上运行生产服务器,这是一个不好的做法。 我build议你迁移一个服务器的操作系统,如Windows服务器,Linux等的专用服务器。
关于您的错误[1] ,看起来像您遇到networking错误:
拒绝连接。
目标计算机主动拒绝,因此无法build立连接。 这通常是由于尝试连接到外部主机上处于非活动状态的服务(即没有运行服务器应用程序的服务)所致。
看看这里[2]了解更多细节。
如果您已经放弃解决您的networking问题,请考虑我的build议。
希望能帮助到你。
参考文献: