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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
Cc: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>, Steph L <engel306sl(at)yahoo(dot)fr>, pgsql-admin(at)postgresql(dot)org
Subject: Re: How to disconnect a single user in Postgresql 8.2.5 from a database
Date: 2010-04-20 02:10:09
Message-ID: 15823.1271729409@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Josh Kupershmidt <schmiddy(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2010-04-20 03:07:00 Re: How to disconnect a single user in Postgresql 8.2.5 from a database
Previous Message Josh Kupershmidt 2010-04-20 01:24:40 Re: How to disconnect a single user in Postgresql 8.2.5 from a database