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
