Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 904AC9FB2FF for ; Tue, 30 Jan 2007 13:20:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 65879-06 for ; Tue, 30 Jan 2007 13:20:33 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 1FB399FB423 for ; Tue, 30 Jan 2007 13:15:38 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l0UHFbVj065952 for ; Tue, 30 Jan 2007 13:15:37 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l0UH2Dj2061552 for pgsql-admin@postgresql.org; Tue, 30 Jan 2007 13:02:13 -0400 (AST) (envelope-from news) From: "codeWarrior" X-Newsgroups: pgsql.admin Subject: Re: Terminating a query that appears to be hung Date: Tue, 30 Jan 2007 09:05:58 -0800 Organization: iDynaTECH, Inc. Lines: 46 Message-ID: References: <006601c743fe$31e824c0$79587cca@ITLaptop> <200701292233.36805.ejortegau@cable.net.co> Reply-To: "codeWarrior" X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-RFC2646: Format=Flowed; Original To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/276 X-Sequence-Number: 24432 and from the shell prompt: you can find ALL postgreSQL process id's by: %>ps ax | grep postgres ""Eduardo J. Ortega"" wrote in message news:200701292233.36805.ejortegau@cable.net.co... > You can also kill the postgres process corresponding to the hung query. do > NOT > kill -9. Only kill. Postgres will rollback any uncomitted transaction and > finish that connection gracefully. > > On Monday 29 January 2007 18:35, 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 > > -- > Eduardo J. Ortega - Linux user #222873 > "No fake - I'm a big fan of konqueror, and I use it for everything." -- > Linus > Torvalds > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >