Postgres在Windows上停止

我有一个在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议。

希望能帮助到你。

参考文献:

  1. https://msdn.microsoft.com/en-us/library/windows/desktop/ms740668(v=vs.85).aspx
  2. https://www.postgresql.org/message-id/[email protected]