| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | "alexandre::aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Killing process through of a function |
| Date: | 2005-02-18 18:15:40 |
| Message-ID: | 20050218181540.GA79521@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Feb 18, 2005 at 10:05:25AM -0200, alexandre::aldeia digital wrote:
> IBM DB2 have functions that allow the DBA to disconnect some clients.
> This is very usefull for database maintenance without giving a shell to him.
As I mentioned, you could write a function in C, PL/Perl, etc.,
that sends a signal to a client's backend process, but I think
there's concern about how robust that is, which is why it hasn't
become a standard function. See the following message and the
messages it references:
http://archives.postgresql.org/pgsql-general/2005-02/msg00426.php
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-02-18 18:17:07 | Re: PGSQL 8.0.1 Win 2K Installation Problem |
| Previous Message | Joshua D. Drake | 2005-02-18 18:15:21 | Re: PostgreSQL Replication |