Re: Problem with connection dropping

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jeff Wigal (Referee Assistant)" <jeff(at)referee-assistant(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problem with connection dropping
Date: 2009-04-11 03:27:51
Message-ID: 6954.1239420471@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

"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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Praveen K Sharma2 2009-04-13 12:52:40 geeting error in installing iodbc
Previous Message Jeff Wigal (Referee Assistant) 2009-04-11 03:21:46 Problem with connection dropping