Re: pg_terminate_backend

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: postgres hackers <pgsql-hackers(at)postgresql(dot)org>, Bruce Momjian <bruce(at)momjian(dot)us>
Subject: Re: pg_terminate_backend
Date: 2006-08-03 17:12:44
Message-ID: 44D22E8C.7010406@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2006-08-03 17:16:15 Re: Replication Documentation
Previous Message Peter Eisentraut 2006-08-03 17:11:47 Re: Values list-of-targetlists patch for comments (was Re: [PATCHES]