PostgreSQL的错误:无法从客户端接收数据:试图在了一个操作是不是一个插座(PostgreSQ

2019-10-16 14:14发布

PostgreSQL的9.1.3版。 操作系统为Windows XP。 反病毒是F-Secure公司。 postgres.exe的六个实例在运行。

下面是什么在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的,但它并没有区别。 任何想法,为什么?

Answer 1:

这是不寻常的停止或禁用,即使防病毒产品导致的问题。 他们有时必须完全卸载,以避免他们在正常的数据库操作的方式获得。 另一个可能的可能性是存在需要被配置为允许所述TCP服务器套接字,以被打开或由不同的PostgreSQL过程中使用的UDP套接字有关的统计数据通信的防火墙。



文章来源: PostgreSQL error: could not receive data from client: An operation was attempted on something that is not a socket