Re: terminate PG connections

[Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>]

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/