Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group