Csaba Nagy wrote: >> "man kill" says the default is SIGTERM. >> > > OK, so that means I do use it... is it known to be dangerous ? I thought > till now that it is safe to use. Apparently you never suffered any problems from that; neither did I.
> What about "select pg_cancel_backend()" > That's the function wrapper around kill -SIGINT, which is probably the way you could safely stop your queries most of the time. Regards, Andreas ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq