PostgreSQL错误：无法从客户端接收数据：尝试对非套接字的对象进行操作 [英] PostgreSQL error: could not receive data from client: An operation was attempted on something that is not a socket

问题描述

PostgreSQL版本9.1.3。操作系统是Windows XP。防病毒软件是F-Secure。正在运行postgres.exe的六个实例。

PostgreSQL version 9.1.3. OS is Windows XP. Anti-virus is F-Secure. Six instances of postgres.exe are running.

这是pg_log中的内容：

Here's what's in the pg_log:

2012-04-08 14:58:23 PDT LOG:  incomplete startup packet
2012-04-08 14:58:24 PDT LOG:  database system is ready to accept connections
2012-04-08 14:58:24 PDT LOG:  autovacuum launcher started
2012-04-08 14:58:25 PDT LOG:  could not receive data from client: An operation was attempted on something that is not a socket.

2012-04-08 14:58:25 PDT LOG:  incomplete startup packet
2012-04-08 14:58:27 PDT LOG:  could not receive data from client: An operation was attempted on something that is not a socket.

我禁用了F-Secure，但是没什么用。知道为什么吗？

I disabled F-Secure but it made no difference. Any idea why?

推荐答案

即使停止或禁用，防病毒产品也不会引起问题。有时必须将它们完全卸载，以免妨碍正常的数据库操作。另一个可能的可能性是，有一个防火墙需要配置为允许打开TCP服务器套接字，或者允许各种PostgreSQL进程使用的UDP套接字进行有关统计信息的通信。

It is not unusual for antivirus products to cause problems even when stopped or disabled. They must sometimes be completely uninstalled to avoid having them get in the way of normal database operations. Another likely possibility is that there is a firewall which needs to be configured to allow the TCP server socket to be opened or the UDP socket used by the various PostgreSQL processes to communicate regarding statistics.

这篇关于PostgreSQL错误：无法从客户端接收数据：尝试对非套接字的对象进行操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！