Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 3847E9FB30D for ; Mon, 29 Jan 2007 21:10:07 -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 94231-08 for ; Mon, 29 Jan 2007 21:09:57 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.240]) by postgresql.org (Postfix) with ESMTP id EBE109F939E for ; Mon, 29 Jan 2007 21:10:01 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c24so641571ana for ; Mon, 29 Jan 2007 17:10:01 -0800 (PST) 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=XmIud3BhZ9oxX2/xzeSAZcRuBkdsYArtwNd4tSZ7J6eKRZD1iyN7ly/qqQFj+3lhWxYi4ODXdr/jDLMwY2/vxB0QUrhvgPRk3yXGp8URuyx68T790f0RktSFlua1NEeCa5M8IqG7IfBuik33u8xRCBh+FvTfj/Cbm3f/eJLOvgk= Received: by 10.114.175.16 with SMTP id x16mr318821wae.1170119400400; Mon, 29 Jan 2007 17:10:00 -0800 (PST) Received: by 10.114.79.4 with HTTP; Mon, 29 Jan 2007 17:10:00 -0800 (PST) Message-ID: Date: Mon, 29 Jan 2007 22:10:00 -0300 From: "Guido Barosio" To: "Phillip Smith" Subject: Re: Terminating a query that appears to be hung Cc: "Robert D Oden" , "PgSQL ADMIN" In-Reply-To: <006601c743fe$31e824c0$79587cca@ITLaptop> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <45BE0CB1.5070308@dbasetek.com> <006601c743fe$31e824c0$79587cca@ITLaptop> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/269 X-Sequence-Number: 24425 Hmm, if you are a sysadmin you may want to get the process id for the query, running something like: Select procpid,current_query from pg_stat_activity where datname="dbname"; If you are running Linux, you'll get the procpid (pid) for the offending query and by sending "kill -15 " you are killing/terminating the query. No idea on how to proceed if your platform is Windows. Best wishes, Guido Barosio On 1/29/07, Phillip Smith wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Guido Barosio ----------------------- http://www.globant.com guido.barosio@globant.com