我在 Windows 7 上以服务形式运行 Postgres 9.2。数据库似乎每天都会停止运行，有时它会自行重新启动，有时我需要重新启动服务。没有太多日志信息，我没有在这台计算机上安装防病毒软件和防火墙。我尝试改进日志信息，但效果不大。
我在互联网上或 serverfault 上找不到同样的问题。
有一些日志信息：
2016-09-08 06:25:27 BRT [未知] 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 与服务器状态窗口一起打开，我也会收到这些消息。
有小费吗？
谢谢
答案1
首先，在台式机上运行生产服务器是一种不好的做法。我建议您迁移到具有服务器操作系统（如 Windows 服务器、Linux 等）的专用服务器。
关于您的错误[1]，看起来您遇到了网络错误：
连接被拒绝。
无法建立连接，因为目标计算机主动拒绝。这通常是由于尝试连接到外部主机上处于非活动状态的服务（即没有运行任何服务器应用程序的服务）所致。
请参阅此处[2]了解更多详细信息。
如果您已经放弃解决网络问题，请考虑我的建议。
希望能帮助到你。
参考：