Re: Broken pipes - Mailing list pgsql-general

From Tom Lane
Subject Re: Broken pipes
Date
Msg-id 29111.1004139033@sss.pgh.pa.us
Whole thread Raw
In response to Broken pipes  ("mike sears" <matrix@quadrent.net>)
List pgsql-general
"mike sears" <matrix@quadrent.net> writes:
> pq_recvbuf: unexpected EOF on client connection

This indicates that you have clients that are disconnecting
ungracefully, but it doesn't tell us much about why.

One recently-understood possibility is that if you are using psql
with password authentication, then psql doesn't prompt you for a
password until it's tried and failed to connect without.  That
failure provokes one of these messages.  (For 7.2, we've hacked the
postmaster to suppress the log message in that case.)

Otherwise you have misbehaving client-side software.  I think that
the ODBC driver is known not to disconnect gracefully, but I don't
know of any other problems that would cause this, short of client
crashes.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: null != null ???
Next
From: "Eric Ridge"
Date:
Subject: Re: UNIQUE constraint violations and transactions