if i remember correctly, kill -TERM <the procpid of the query> should do it. you can get the pid of the query process by looking at pg_queries table Vikram ps: be careful you dont kill -9 or some such..... On Fri, 13 May 2005, Brandon Hines wrote: > > Is there a method for killing a query from the server. > > I have a number of users that manage to run queries that busy the server > preventing a number of critical queries from running within an > acceptable time limit. > > I would like to kill off the queries that appear to be busying the > server without having to take postgres down altogether. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >
