and from the shell prompt: you can find ALL postgreSQL process id's by: %>ps ax | grep postgres
""Eduardo J. Ortega"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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: [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 > > -- > 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 > ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
