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@sss.pgh.pa.us> wrote:
"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