> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Not sure. My admin tool is more proof of concept at this point. I
> > think ultimately we will need to allow administrators to such individual
> > backend terminations.
>
> I hope the tool is set up to encourage them to try something safer
> (ie, CANCEL QUERY) first...
Yes, the CANCEL button appears before the TERMINATE button.
On SIGTERM, I think we are fooling ourselves if we think people aren't
SIGTERM'ing individual backends. Terminating individual db connections
is a very common job for an administrator. If SIGTERM doesn't cause
proper shutdown for individual backends, I think it should.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026