Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5440E9FB389 for ; Mon, 29 Jan 2007 11:29:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 82633-04 for ; Mon, 29 Jan 2007 11:29:19 -0400 (AST) X-Greylist: delayed 00:24:05.486502 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id CDC619FB30D for ; Mon, 29 Jan 2007 11:29:25 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.dbasetek.com (h-66-134-184-74.chcgilgm.covad.net [66.134.184.74]) by svr4.postgresql.org (Postfix) with ESMTP id 0B0BF5AFA1E for ; Mon, 29 Jan 2007 15:05:15 +0000 (GMT) Received: from [192.168.1.51] ([192.168.1.51]) by mail.dbasetek.com (8.12.11/8.12.11) with ESMTP id l0TF59DM025192 for ; Mon, 29 Jan 2007 09:05:09 -0600 Message-ID: <45BE0CB1.5070308@dbasetek.com> Date: Mon, 29 Jan 2007 09:03:13 -0600 From: Robert D Oden Organization: Database Marketing Technologies Inc User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: PgSQL ADMIN Subject: Terminating a query that appears to be hung Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-DMT-MailScanner-Information: Please contact the ISP for more information X-DMT-MailScanner: Found to be clean X-DMT-MailScanner-From: roden@dbasetek.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200701/261 X-Sequence-Number: 24417 Is there a way to terminate a client session without having to restart Postgres. Thanks -- Robert D Oden Database Marketing Technologies, Inc 951 Locust Hill Circle Belton MO 64012-1786 Ph: 816-318-8840 Fax: 816-318-8841 roden@dbasetek.com