Re: LOG: unexpected EOF on client connection

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Ben Carbery <ben(dot)carbery(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: LOG: unexpected EOF on client connection
Date: 2010-10-10 01:51:36
Message-ID: AANLkTins7zv_fSCar=kJW7hJBY391ifrp+rT4VZcBERv@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Oct 9, 2010 at 5:45 PM, Ben Carbery <ben(dot)carbery(at)gmail(dot)com> wrote:
>
>> Or that OP has a networking issue.  Some firewalls are known for
>> dropping what they think are idle connections when they aren't.
>>
>
> I don't think so.. EOF is an explicit termination, not a timeout as would
> caused by a firewall dropping traffic. It's more like what happens when the
> remote process on the client is killed for example. Postgres probably
> expects to see some kind of "quit" command prior to receiving the EOF.

Well, this is exactly the error I used to get when the problem was
having a firewall timeout between client and server at my last job.
The fix there was to play with the tcp_keepalive settings

--
To understand recursion, one must first understand recursion.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2010-10-10 03:52:50 Postgres won't start after setting ssl=on
Previous Message Ben Carbery 2010-10-09 23:45:02 Re: LOG: unexpected EOF on client connection