Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A3C02650E23 for ; Fri, 4 Jul 2008 13:41:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 25515-05 for ; Fri, 4 Jul 2008 13:41:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id 50BCC64FD64 for ; Fri, 4 Jul 2008 13:41:06 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 097F647000D for ; Fri, 4 Jul 2008 18:41:03 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 3Ag+1Dao4jRa for ; Fri, 4 Jul 2008 18:41:02 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id EDB3247000C; Fri, 4 Jul 2008 18:41:02 +0200 (CEST) Date: Fri, 4 Jul 2008 18:41:02 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: Who's attached to the database? Message-ID: <20080704164102.GA4933@easy2.in-chemnitz.de> References: <902696.39596.qm@web59510.mail.ac4.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <902696.39596.qm@web59510.mail.ac4.yahoo.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/71 X-Sequence-Number: 29681 On Fri, Jul 04, 2008 at 06:50:43AM -0700, Lennin Caro wrote: > try this > > select pg_cancel_backend(); > > if the command not work kill the process in os > > kill -9 proccessid_os *NO*! Never kill -9 a postgres backend!!! This is like a headshot, no chance to clean up. You will make your whole pg server shut down! A simple kill should suffice. Tino. -- "What we nourish flourishes." - "Was wir nähren erblüht." www.craniosacralzentrum.de www.forteego.de