Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E52EB9FA35A for ; Mon, 15 Oct 2007 10:57:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 31980-09 for ; Mon, 15 Oct 2007 10:57:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pat.uio.no (pat.uio.no [129.240.10.15]) by postgresql.org (Postfix) with ESMTP id 3BDE09FA195 for ; Mon, 15 Oct 2007 10:57:16 -0300 (ADT) Received: from mail-mx9.uio.no ([129.240.10.39]) by pat.uio.no with esmtp (Exim 4.67) (envelope-from ) id 1IhQ8q-0004Uf-AG; Mon, 15 Oct 2007 15:37:56 +0200 Received: from inhaca.uio.no ([129.240.202.141]) by mail-mx9.uio.no with esmtp (Exim 4.67) (envelope-from ) id 1IhPuj-0000dy-UJ; Mon, 15 Oct 2007 15:23:22 +0200 Message-ID: <471369C9.1060301@usit.uio.no> Date: Mon, 15 Oct 2007 15:23:21 +0200 From: Tommy Gildseth User-Agent: Thunderbird 2.0.0.6 (X11/20070728) MIME-Version: 1.0 To: Jessica Richard CC: pgsql-admin@postgresql.org Subject: Re: Is there a way to kill a connection from the pg_stat_activitly list? References: <23085.65196.qm@web56403.mail.re3.yahoo.com> In-Reply-To: <23085.65196.qm@web56403.mail.re3.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-UiO-ClamAV-Virus: No X-UiO-Spam-info: not spam, SpamAssassin (score=-4.8, required=12.0, autolearn=disabled, AWL=0.186, UIO_MAIL_IS_INTERNAL=-5) X-UiO-Scanned: 21A9652E8D3912C412C079BBAF95DB4C93517438 X-UiO-SPAM-Test: remote_host: 129.240.202.141 spam_score: -47 maxlevel 200 minaction 2 bait 0 mail/h: 2 total 523 max/h 38 blacklist 0 greylist 0 ratelimit 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/118 X-Sequence-Number: 27032 Jessica Richard wrote: > When you see a hanging Postgres connection (or a job running so long > and you don't want to continue any more) from > > select * from pg_stat_activity > > and you want to disconnect it, > > how do you do it? |pg_cancel_backend() |http://www.postgresql.org/docs/8.1/interactive/functions-admin.html -- Tommy Gildseth DBA, Gruppe for databasedrift Universitetet i Oslo, USIT m: +47 45 86 38 50 t: +47 22 85 29 39