Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Blocking connection and timeout problem
Date
Msg-id 1199.1123079895@sss.pgh.pa.us
Whole thread Raw
In response to Blocking connection and timeout problem  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
List pgsql-admin
Tree view 
=?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 :-(

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: FATAL: cache lookup failed for access method 6881280
Next
From: KÖPFERL Robert
Date:
Subject: Re: Blocking connection and timeout problem