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.
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
> > to my Postgres server using the ODBC driver. I have about 15 customers
> > 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
> > 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
In response to
pgsql-odbc by date
|Next:||From: Tom Lane||Date: 2009-04-14 01:06:55|
|Subject: Re: Fwd: Problem with connection dropping |
|Previous:||From: Adrian Klaver||Date: 2009-04-13 14:19:14|
|Subject: Re: geeting error in installing iodbc|