Re: Connection reset by peer / broken pipe

Jeff Wigal wrote:
>>> I am running Postgres 8.2.3 and am seeing the following error messages in my
>>> logs:
>>>
>>> LOG: SSL SYSCALL error: Connection reset by peer
>>> LOG: could not receive data from client: Connection reset by peer
>>> LOG: unexpected EOF on client connection
>>> LOG: could not send data to client: Broken pipe
>>
>> Do your client applications tend to leave an open connection sitting
>> idle for awhile? If so you might be getting burnt by idle-connection
>> timeouts in intervening routers. NAT-capable boxes in particular
>> will kill a connection that carries no data for "too long". If you're
>> lucky the router will offer a way to adjust its timeout ...
>
> I'm in the process of tracking down the cause of this... Is
> there any way on the server side of things to terminate a
> connection after "x" number of minutes? For what we're
> doing, there is no reason to have a connection open after 10
> minutes.

There are tcp_keepalives_idle, tcp_keepalives_interval, and tcp_keepalives_count
(see http://www.postgresql.org/docs/8.3/static/runtime-config-connection.html)

They can make the server check idle connections and detect dead ones,
which will be closed.

Yours,
Laurenz Albe