Thursday, July 17, 2008

Re: [GENERAL] TODO list and "hyphen"

salman wrote:
> >> -Allow administrators to safely terminate individual sessions either
> via an SQL function or SIGTERM <<
>
> Can't you already do this with pg_cancel_backend() or kill <child pid>?

Cancel backend only cancels the current query but later queries are
still executed. Kill was never officially supported as a way to
terminate a backend, but it will be in 8.4 and there is an SQL function
to do it too.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: