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
