Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5FC409F9ABF for ; Mon, 15 Oct 2007 14:34:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 85489-10 for ; Mon, 15 Oct 2007 14:34:28 -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.171]) by postgresql.org (Postfix) with ESMTP id 5C1AE9F9AB7 for ; Mon, 15 Oct 2007 14:34:29 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so922784ugf for ; Mon, 15 Oct 2007 10:34: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=9wq2EG/V2YjSNl2fW6gkiZtHmeK3IuVorPcmSF1F7yY=; b=W2NEmyJ1akeyASmNnrQZYVVvplGqRldMnZ6L4a1lVGuEv6+ggNSdV4CpxhCKO5wH0BjTUzGcbTCZ7200tPvq1wm4gXxRFz6ThnzOpANpqG5YcT57JVFtbk95kXbHaDtpNdh6TiD27cYlNN4SW5QlozW6K5zzrdkmONQSwmk3ufQ= 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=tkmhh7GmetECWn81Nfph0PXXxuHX5U4gSD8LPxPCEXck2wZ6vhBelVXVLubCpKOi1HOprdoGPzYXRdW4qW71aLXpX9NS9SqfXuFRT4sP2N9UHh3VulbpiMBC2fM3FZjsg5CdEGz4Ip92wZ7aS5NEd2RPQfW1xmrMNRyh3o6YvhM= Received: by 10.67.115.1 with SMTP id s1mr8107880ugm.1192469667750; Mon, 15 Oct 2007 10:34:27 -0700 (PDT) Received: by 10.67.29.6 with HTTP; Mon, 15 Oct 2007 10:34:27 -0700 (PDT) Message-ID: Date: Mon, 15 Oct 2007 12:34:27 -0500 From: "Scott Marlowe" To: "Jessica Richard" Subject: Re: Is there a way to kill a connection from the pg_stat_activitly list? Cc: "Tommy Gildseth" , pgsql-admin@postgresql.org In-Reply-To: <382292.68410.qm@web56406.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <471369C9.1060301@usit.uio.no> <382292.68410.qm@web56406.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/125 X-Sequence-Number: 27039 On 10/15/07, Jessica Richard wrote: > Thanks a lot! > > "select pg_cancel_backend(procpid) " can end the current query for that > user, but then this connection becomes IDLE, still connected. > > Is there a command for me to totally disconnect a user by procpid? Some > times, I need to kick out a particular Postgres user completely.