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

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Steph L <engel306sl(at)yahoo(dot)fr>
Cc: 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-19 15:52:10
Message-ID: l2nc3a7de1f1004190852nbbfb67f3v9cba052fdbb0b599@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 19 April 2010 15:27, Steph L <engel306sl(at)yahoo(dot)fr> wrote:
>
> How to disconnect a single user in Postgresql 8.2.5 from a database ?

AFAIK the only way is to upgrade to 8.4 and use pg_terminate_backend():
http://www.postgresql.org/docs/8.4/interactive/functions-admin.html

--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray(dot)ru(at)gmail(dot)com / Skype: gray-hemp / ICQ: 29353802

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-04-19 16:41:17 Re: archived WALL files question
Previous Message Josi Perez (3T Systems) 2010-04-19 15:44:16 register a service in Windows