Fwd: Problem with connection dropping

Not 100% sure what's going on with the network between here and there. He's
on a Time Warner or Comcast residential network between his PC in Colorado
and my server down in Georgia.

He's not intentionally leaving a connection open. When things go as they
should, the entire transaction lasts about 3-4 minutes from connection to
disconnect. From a programming perspective, I'm pretty careful to
explicitly open and close connections with the program.

Any ideas?

On Fri, Apr 10, 2009 at 11:27 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Jeff Wigal (Referee Assistant)" <jeff(at)referee-assistant(dot)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
>