Re: Blocking connection and timeout problem - Mailing list pgsql-admin

From KÖPFERL Robert
Subject Re: Blocking connection and timeout problem
Date
Msg-id ED4E30DD9C43D5118DFB00508BBBA76EB16822@neptun.sonorys.at
Whole thread Raw
In response to Blocking connection and timeout problem  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
Responses Re: Blocking connection and timeout problem  (Guido Barosio <gbarosio@gmail.com>)
Re: Blocking connection and timeout problem  (Dario Brignardello <dbrignar@sinectis.com>)
Re: Blocking connection and timeout problem  (Dario Brignardello <dbrignar@uolsinectis.com>)
List pgsql-admin

|-----Original Message-----
|From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
|Sent: Mittwoch, 03. August 2005 16:38
|To: KÖPFERL Robert
|Cc: pgsql-admin@postgresql.org
|Subject: Re: [ADMIN] Blocking connection and timeout problem
|
|
|=?iso-8859-1?Q?K=D6PFERL_Robert?= <robert.koepferl@sonorys.at> writes:
|> Why is that? Why isn't client A's transaction detected as dead ?
|
|It will be eventually, when the TCP connection times out.  The standard
|timeout is generally an hour or two :-(

Seems not like so. I waited for two hours and it still existed.

But non-the-less. Can this timeout be configured to be less?

|
|            regards, tom lane
|

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Blocking connection and timeout problem
Next
From: Guido Barosio
Date:
Subject: Re: Blocking connection and timeout problem