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 <pid>" 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] ---------------------------(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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
