> Bruce Momjian <[EMAIL PROTECTED]> 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
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html