>> Killing backends with runaway queries is a routine administrative >> task. > >Cancelling runaway queries is a routine task. I'm less >convinced that a >remote kill (ie SIGTERM) facility is such a great idea.
Consider a scenario like: User A starts transaction. User A issues a LOCK TABLE (or does something to lock it) User A goes on vacation without commit/rollback User A might well be Program A instead, of course. Caught in a tight loop, waiting for user input, or whatever. In this case, SIGINT (query cancel) will not help, because all locks held by the transaction will still be held. If there was a way to "force rollback" a connection, that could be done. Buf AFAIK there are none? And would those be safer/better than terminating the backend? //Magnus ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
