Plugge, Joe R. wrote: > #!/bin//bash > # > # Script: pgsession > # Author: Rao Kumar raokumar@xxxxxxxxxxxxx > # 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.m.guerrero@xxxxxxxxxxx> Center for Information Technology Services University of Oslo, Norway PGP Public Key: http://folk.uio.no/rafael/ -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
