X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 76770529BC for ; Wed, 3 Aug 2005 14:35:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24798-05 for ; Wed, 3 Aug 2005 17:35:29 +0000 (GMT) Received: from amiel.capfed2.sinectis.com.ar (amiel.capfed2.sinectis.com.ar [216.244.211.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7A01C529BF for ; Wed, 3 Aug 2005 14:35:27 -0300 (ADT) Received: from aleph.hq.sinectis.com.ar (patix.sinectis.com.ar [216.244.192.23]) by amiel.capfed2.sinectis.com.ar (Postfix) with ESMTP id 7A0D632568; Wed, 3 Aug 2005 14:35:22 -0300 (ART) Subject: Re: Blocking connection and timeout problem From: Dario Brignardello Reply-To: dbrignar@uolsinectis.com To: =?ISO-8859-1?Q?K=D6PFERL?= Robert Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-rehSCgGknmm3NEGTB7gQ" Organization: UOL Argentina S.A Date: Wed, 03 Aug 2005 14:33:17 -0300 Message-Id: <1123090397.15646.36.camel@aleph.hq.sinectis.com.ar> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200508/54 X-Sequence-Number: 18373 --=-rehSCgGknmm3NEGTB7gQ Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: quoted-printable Assuming you are on a linux box (Not sure if it's stated in your mail, sorry if I miss that) you could set /proc/sys/net/ipv4/tcp_keepalive_time to a lower value. That should do the trick :-) Hope it helps. Greetings Dario. On Wed, 2005-08-03 at 16:48 +0200, K=D6PFERL Robert wrote: >=20 >=20 >=20 > |-----Original Message----- > |From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > |Sent: Mittwoch, 03. August 2005 16:38 > |To: K=D6PFERL Robert > |Cc: pgsql-admin@postgresql.org > |Subject: Re: [ADMIN] Blocking connection and timeout problem=20 > | > | > |=3D?iso-8859-1?Q?K=3DD6PFERL_Robert?=3D wri= tes: > |> 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 :-( >=20 > Seems not like so. I waited for two hours and it still existed. >=20 > But non-the-less. Can this timeout be configured to be less? >=20 > | > | regards, tom lane > | >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >=20 >=20 --=20 Atte: Dario Brignardello Planificacion y Desarrollo Tecnologia UOL Argentina S.A Florida 537 Piso 6, Buenos Aires, Argentina +54-11-4321-9110 ext 2533 PGP public key: http://webs.uolsinectis.com.ar/dbrignar/pgp.html --=-rehSCgGknmm3NEGTB7gQ Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQBC8P/dYirddavgWGIRAoVMAJ9SKKr6X6OQJEm4SpM6DhFqhUl5JACgkf/O EB1Z5x4YsQW/6VlGN2ohTsY= =+BnD -----END PGP SIGNATURE----- --=-rehSCgGknmm3NEGTB7gQ--