Re: BUG #5804: Connection aborted after many queries.

Paul Davis <paul(dot)joseph(dot)davis(at)gmail(dot)com> writes:
> And this intriguing error in the server logs from around that time:

> 2010-12-28 18:40:02 EST LOG: SSL renegotiation failure
> 2010-12-28 18:40:02 EST LOG: SSL failed to send renegotiation request
> 2010-12-28 18:40:02 EST LOG: SSL renegotiation failure
> 2010-12-28 18:40:02 EST LOG: SSL error: unsafe legacy renegotiation disabled
> 2010-12-28 18:40:02 EST LOG: could not send data to client:
> Connection reset by peer
> 2010-12-28 18:40:02 EST LOG: SSL error: unsafe legacy renegotiation disabled
> 2010-12-28 18:40:02 EST LOG: could not receive data from client:
> Connection reset by peer
> 2010-12-28 18:40:02 EST LOG: unexpected EOF on client connection

> Googling, I see something that suggests turning off SSL renegotiation
> which I'll try next.

In all cases, you were testing a client against a server on a different
machine, right? This looks to me like you've got two different openssl
libraries, one of which has a bogus partial fix for the recent SSL
renegotiation security issue. I'm not sure what the state of play is
in Apple's shipping version of openssl --- you might have to get an
up-to-date source distribution and compile it yourself to have non-bogus
renegotiation behavior. Or you could just disable renegotiation on the
PG server.

regards, tom lane