Re: pg_terminate_backend - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: pg_terminate_backend
Date
Msg-id 44D22E8C.7010406@pse-consulting.de
Whole thread Raw
In response to Re: pg_terminate_backend  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: pg_terminate_backend
Next
From: Peter Eisentraut
Date:
Subject: Re: Replication Documentation