Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 057C49FB3C5 for ; Mon, 29 Jan 2007 19:35:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 16317-08 for ; Mon, 29 Jan 2007 19:35:50 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id 758C19FB3D0 for ; Mon, 29 Jan 2007 19:35:49 -0400 (AST) Received: (qmail 23149 invoked from network); 29 Jan 2007 23:35:44 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;f42b7a089d2da375e8ae36ef708ae0fc; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 29 Jan 2007 23:35:44 -0000 Received: (qmail 7425 invoked by uid 1166); 30 Jan 2007 10:35:44 +1100 Received: from 202.124.88.121 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:0(202.124.88.121):. Processed in 0.372492 secs); 29 Jan 2007 23:35:44 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:0(202.124.88.121):. Processed in 0.372492 secs Process 7415) Received: from unknown (HELO ITLaptop) (phillip.smith@weatherbeeta.com.au@202.124.88.121) by mail.weatherbeeta.com.au with SMTP; 30 Jan 2007 10:35:42 +1100 From: "Phillip Smith" To: "'Robert D Oden'" , "'PgSQL ADMIN'" Subject: Re: Terminating a query that appears to be hung Date: Tue, 30 Jan 2007 10:35:41 +1100 Message-ID: <006601c743fe$31e824c0$79587cca@ITLaptop> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: AcdDumMptBPSk5gaSraeOgl27yEvfQAQ6S0A In-Reply-To: <45BE0CB1.5070308@dbasetek.com> X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1170113744.601-23141-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.02/0.06 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/268 X-Sequence-Number: 24424 Can youo be a bit more specific...? What client? Psql should terminate the connection when it exist. pgAdmin will close it when you exit the ap, or if you choose 'Disconnect' from the menu. In PHP you'll need to call pg_close function... Every 'client' will have a different method... -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Robert D Oden Sent: Tuesday, 30 January 2007 2:03 AM To: PgSQL ADMIN Subject: [ADMIN] Terminating a query that appears to be hung 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments