On Mon, Mar 01, 2004 at 03:48:00PM -0800, Kuldeep Tanna wrote: > How do I cancel the execution of that query. I tried restarting / > stopping postmaster, but pg_ctl gives an error message "Unable to > shutdown server"
Find the pid of the backend doing the work (you can use psto find it) and then issue kill -2 <pid> A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster