Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 17DB49FBBF5 for ; Wed, 17 Oct 2007 09:00:48 -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 64925-06 for ; Wed, 17 Oct 2007 09:00:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.179]) by postgresql.org (Postfix) with ESMTP id 1C4189FBBF1 for ; Wed, 17 Oct 2007 09:00:37 -0300 (ADT) Received: by el-out-1112.google.com with SMTP id m34so555240ele for ; Wed, 17 Oct 2007 05:00:35 -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=8jfakdauOM/JNqczhjnY0i8DpMN+CnNvZEL1+7aE+H8=; b=Xx3gqkzCs+rWjXH4mvqBRmZoW/VqHYNig6DK8yx4Z8sDV2X2+8+EJMlbUlMvUubRlCqEc7J5ILjmYG1EuP5McqHUIgZ5mnwEn6mnz4xBM2Vv+IstzCb9dgD47Rc7zr3XwW0SaVOVdEtzCt0Y603PdKLt72Cg9OC3TX7rM/koRhI= 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=EryJ7Yb1mN7sTw/dCabnoFL3xIL06RwiCl6zz42WRbhKUPMNUWnlNaQmKHe5sooVYj7bRvxAKF2x5vtNnbJoRZeTxtnLZo6JCjw3LItKVLmzFEQWmwy3WWVEo6E93RYB+SLm+WIeTuH/uc6WrFonjemj3dxZkgpd/WsQFz2FeeE= Received: by 10.142.239.11 with SMTP id m11mr2419571wfh.1192622435147; Wed, 17 Oct 2007 05:00:35 -0700 (PDT) Received: by 10.143.8.5 with HTTP; Wed, 17 Oct 2007 05:00:35 -0700 (PDT) Message-ID: <36e682920710170500m6f4f946el7358d30ce4289494@mail.gmail.com> Date: Wed, 17 Oct 2007 08:00:35 -0400 From: "Jonah H. Harris" To: "Moiz Kothari" Subject: Re: Is there a way to kill a connection from the pg_stat_activitly list? Cc: "Jessica Richard" , "Scott Marlowe" , "Tommy Gildseth" , pgsql-admin@postgresql.org In-Reply-To: <82e1a9bd0710170416p77d67fc2sd28aa07f531450f0@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <379974.90208.qm@web56402.mail.re3.yahoo.com> <36e682920710160605n338de99fk300cd3062bd0417e@mail.gmail.com> <82e1a9bd0710170416p77d67fc2sd28aa07f531450f0@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/148 X-Sequence-Number: 27062 On 10/17/07, Moiz Kothari wrote: > Please do not use kill More like, please do not take advice from people who don't know what they're talking about. > it sometimes resets all the connection on your db, > you might want to use Honestly, was this supposed to be a joke? Have you RTFM? Have you looked at the code to pkill? pkill calls kill and frankly, pkill is more dangerous if you only want to kill a single session. Grr, I'm surprised to see such an uninformed statement on this list. -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com Edison, NJ 08837 | http://www.enterprisedb.com/