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