From: | Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no> |
---|---|
To: | "Plugge, Joe R(dot)" <JRPlugge(at)west(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: terminate PG connections |
Date: | 2009-06-30 18:54:44 |
Message-ID: | 4A4A5F74.1030603@usit.uio.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Plugge, Joe R. wrote:
> #!/bin//bash
> #
> # Script: pgsession
> # Author: Rao Kumar raokumar(at)netwolves(dot)com
> # Purpose: Utility to list/kill postgres database user sessions.
> # Comments: Execute this script as "postgres" user (user who runs postmaster)
>
[............]
Is it safe to kill pg sessions with Postgresql versions < 8.4?
This can be read in the 8.4 release:
"Add pg_terminate_backend() to safely terminate a backend (the SIGTERM
signal works also) (Tom, Bruce)
While it's always been possible to SIGTERM a single backend, this was
previously considered unsupported; and testing of the case found some
bugs that are now fixed."
I don't know what "some bugs that are now fixed" means, but I think I
read somewhere that killing a session with the command kill was not a
god idea.
regards
--
Rafael Martinez, <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
From | Date | Subject | |
---|---|---|---|
Next Message | Mike angelo | 2009-06-30 19:29:03 | Restiring pg_dump text file |
Previous Message | Plugge, Joe R. | 2009-06-30 18:36:27 | Re: terminate PG connections |