Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C201B9F9A8D for ; Mon, 15 Oct 2007 09:56:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 76022-02 for ; Mon, 15 Oct 2007 09:56:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web56403.mail.re3.yahoo.com (web56403.mail.re3.yahoo.com [216.252.111.82]) by postgresql.org (Postfix) with SMTP id 9F5B49F9A9A for ; Mon, 15 Oct 2007 09:56:07 -0300 (ADT) Received: (qmail 65525 invoked by uid 60001); 15 Oct 2007 12:56:06 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=W/NP0hH5jbAObmdBRK5Yf/CFiz6E3UraPG26ZQVIyBV5vqW9Bt3txH6yLL8wXdnEmtXdBELp9g538q21SF9KFAnbAgmm7igeARBCHQkgRgz4U5Dtx2/6iRZl51j7aYVRSz8w/vAPUYnR91vNhG/pHC63PWGDR4ooMJCEgr+4Z5k=; X-YMail-OSG: HPn4CwYVM1loh8savAQfbZ53gnG0Fd2wEKxVSNF9ViJeeyoudDHs2Xk2xKLUoOo6Jg-- Received: from [198.119.134.32] by web56403.mail.re3.yahoo.com via HTTP; Mon, 15 Oct 2007 05:56:06 PDT Date: Mon, 15 Oct 2007 05:56:06 -0700 (PDT) From: Jessica Richard Subject: Is there a way to kill a connection from the pg_stat_activitly list? To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1558268327-1192452966=:65196" Content-Transfer-Encoding: 8bit Message-ID: <23085.65196.qm@web56403.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/115 X-Sequence-Number: 27029 --0-1558268327-1192452966=:65196 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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? thanks, Jessica --------------------------------- Check out the hottest 2008 models today at Yahoo! Autos. --0-1558268327-1192452966=:65196 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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?

thanks,
Jessica


Check out the hottest 2008 models today at Yahoo! Autos. --0-1558268327-1192452966=:65196--