Re: How to disconnect a single user in Postgresql 8.2.5 from a database

Josh Kupershmidt <schmiddy@gmail.com> writes:
> pg_terminate_backend() is just a SQL wrapper around:
>    kill -SIGTERM [backend PID]

> For versions before 8.4: if you can SSH in to the server, run the
> above on the PID of the backend your user is connected to, and that
> should terminate their connection.

The reason the function isn't there before 8.4 is that that's not
promised to work before 8.4 ... most of the time it will work, but
once in awhile you could get nasty side-effects.

            regards, tom lane