Re: Problem with connection dropping

"Jeff Wigal (Referee Assistant)" <jeff@referee-assistant.com> writes:
> I'm seeing some intermittent issues with a client who is trying to connect
> to my Postgres server using the ODBC driver.  I have about 15 customers who
> are able to connect without issue, but one seems to be having problems.

> Here's what I'm seeing in the server's log file

> xx.xxx.xxx.xxx(1351) 2009-04-10 21:08:20 EDT LOG:  connection authorized:
> user=xxx database=xxx
> ...
> xx.xxx.xxx.xxx(1351) 2009-04-10 21:25:49 EDT LOG:  could not receive data
> from client: Connection timed out
> xx.xxx.xxx.xxx(1351) 2009-04-10 21:25:49 EDT LOG:  unexpected EOF on client
> connection

Is he allowing the connection to sit idle?  If so, this might represent
a router timeout.  What network hardware is between your machine and
this customer's?

            regards, tom lane