Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0B6379F929B for ; Wed, 31 Oct 2007 19:44:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 30533-02-4 for ; Wed, 31 Oct 2007 19:43:56 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id F05969FCBEE for ; Wed, 31 Oct 2007 18:47:30 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so387344ugf for ; Wed, 31 Oct 2007 14:47:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=ufntL5xh/3j1yKwE0rfnmAcEGPH+dT+oaHxUHQUfpXM=; b=eibAAXcTfiyCh06KlbRXAQT6x9BT75U6zSy5M4h5o6DHhaC5dALaZy8iZGNce5oWt4dmeeFN9CgIx0dI+OlrB9VQN6dVKfYAM1LdIn+K9aDxE2IlsaXDWcXOfKfmt681YjSHGu+xsVwDTF55qqb3hSquF0LSURS2VU0PIq4Twts= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ksvFl58BTH5gEAVNoFp3uH+fxaRkjHZk3tlgFC61UpgtbAuBmnzncKZm/2o37OFn7pfEiZLs7w4qH6W+bxTVP6mLpm2TR4H5cDNWg+lss7y0thag3e0gpJUbsXcWfsja53T6PWy+IfClCEvpJk/awYqJy+5ag2lNcD6ZNm+Zbx4= Received: by 10.67.26.11 with SMTP id d11mr237952ugj.1193867248262; Wed, 31 Oct 2007 14:47:28 -0700 (PDT) Received: by 10.67.40.10 with HTTP; Wed, 31 Oct 2007 14:47:28 -0700 (PDT) Message-ID: Date: Wed, 31 Oct 2007 16:47:28 -0500 From: "Scott Marlowe" To: "Achilleas Mantzios" Subject: Re: How to kill process "idle in transaction" Cc: pgsql-admin@postgresql.org, "Patrick De Zlio" In-Reply-To: <200710301111.02475.achill@matrix.gatewaynet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-7 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <58729a240710300145m4457f63euc15007893e8a805c@mail.gmail.com> <200710301111.02475.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/326 X-Sequence-Number: 27240 T24gMTAvMzAvMDcsIEFjaGlsbGVhcyBNYW50emlvcyA8YWNoaWxsQG1hdHJpeC5nYXRld2F5bmV0 LmNvbT4gd3JvdGU6Cj4g0/Tp8iDU8d/05yAzMCDP6vT+4vHp7/IgMjAwNyAxMDo0NSwg7y/nIFBh dHJpY2sgRGUgWmxpbyDd4/Hh+OU6Cj4gPiBIaSwKPiA+Cj4gPiBXZSBhcmUgcnVubmluZyBQb3N0 Z3JlU1FMIDguMi40IHdpdGggcXVpdGUgaGlnaGx5IHVwZGF0ZWQgbWlsbGlvbnMgcm93cwo+ID4g dGFibGVzLgo+ID4KPiA+IEl0IGNvbWVzIHNvbWV0aW1lcyB0byBnZXQgc29tZSAiaWRsZSBpbiB0 cmFuc2FjdGlvbiIgcHJvY2Vzc2VzLCB3aGljaAo+ID4gZG9lc24ndCBoYXZlIGZpcnN0IHJlYWxs eSB2aWV3YWJsZSBlZmZlY3Qgb3V0IG9mIGdpdmluZyB2ZXJ5IGJhZCBlc3RpbWF0ZWQKPiA+IG51 bWJlcnMgZm9yIHBnY2xhc3MucmVsdHVwbGVzIGFuZCwgaWYgd2UgbGV0IHRoZW0gcnVuIGFzIGl0 IGlzLCBibG9jayB0aGUKPiA+IGF1dG92YWN1dW0gZnJvbSByZWxlYXNpbmcgcm93cywgYW5kIGFm dGVyIGZldyBkYXlzIHNvbWUgd29yc2UgcHJvYmxlbXMuCj4gPgo+ID4gTm93IHdlIGFyZSBhYmxl IHRvIGRldGVjdCB0aGVzZSAiaWRsZSBpbiB0cmFuc2FjdGlvbiIgcHJvY2Vzc2VzLCBidXQgd2hh dAo+ID4gdG8gZG8gd2l0aCB0aGVtID8KPiA+Cj4gPiBXaGF0IHRvIGRvIHRvIGF2b2lkIHN1Y2gg c2l0dWF0aW9uPyBIb3cgdG8gZmluZCB0aGUgYmFkIHJlcXVlc3Qgd2hpY2ggcHV0Cj4gPiB0aGUg cHJvY2VzcyBpbiB0aGlzIHN0YXRlPyBGcm9tIHRoZSB0aW1lIGl0IGlzIGlkbGUgaW4gdHJhbnNh Y3Rpb24sIHdlCj4gPiBjYW4ndCBzZWUgdGhlIHF1ZXJ5IGluIHRoZSBwZ19sb2NrIHRhYmxlIGFu eW1vcmUuCj4gPgo+ID4gSG93IHRvIGRlYWwgd2l0aCBzdWNoIHByb2Nlc3Mgd2hlbiBpdCBpcyBh bHJlYWR5IGlkbGUgaW4gdHJhbnNhY3Rpb24/IGNhbgo+ID4gd2Ugc2ltcGx5IGtpbGwgaXQ/IEl0 IGlzIGEgYmFja2VuZCBmcm9tIHBncG9vbC4gQ2FuIHdlIHNpbXBseSByZXN0YXJ0IGl0Cj4gPiAo aG93KSB3aXRob3V0IHJlc3RhcnRpbmcgYWxsIHRoZSBkYXRhYmFzZT8KPgo+IFNvbWUgY29ubmVj dGlvbiBwb29scyBpc3N1ZSBhIEJFR0lOIG9uIHRoZSBjb25uZWN0aW9uIGp1c3QKPiBhZnRlciB0 aGUgcHJldmlvdXMgdXNlciBvZiB0aGUgY29ubmVjdGlvbiBpc3N1ZXMgQ09NTUlUIGFuZAo+IHRo ZW4gY2xvc2VzIGl0IChKYm9zcyBkb2VzIGl0KS4gU28sIDxJRExFPiBpbiB0cmFuc2FjdGlvbiBp cyBub3QKPiBhcHJpb3JpIGJhZC4KCllvdSBjYW4gdHVybiBvZmYgdGhhdCBiZWhhdmlvdXIsIElJ UkMuICBJdCBpcyBicm9rZW4gYmVoYXZpb3VyIGFzIGZhcgphcyBwZ3NxbCBpcyBjb25jZXJuZWQs IEkgYmVsaWV2ZS4K