Re: Terminating a backend

Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > I am suggesting we add a new fuction pg_terminate_backend() that does
> > everything just like cancel, but also sets a global variable that we
> > check in the loop where we look for the next command and if it is set,
> > we exit the backend.
> 
> And if you never *get* to that loop, what have you accomplished?
> 
> Keep in mind that 99% of the excuse for people to want to use SIGTERM is
> that the backend isn't responding to SIGINT.  If you've fixed things so
> that SIGTERM cannot get them out of any situation that SIGINT doesn't
> get them out of, I don't think it's a step forward.

What I hear people ask is that they don't want the backend to read the
next command but to exit.  That seems like a reasonable request.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +