Postgres Pro
Downloads
Home   >   mailing lists

Re: How to disconnect a single user in Postgresql 8.2.5 from a database - Mailing list pgsql-admin

From Sergey Konoplev
Subject Re: How to disconnect a single user in Postgresql 8.2.5 from a database
Date
Msg-id l2nc3a7de1f1004190852nbbfb67f3v9cba052fdbb0b599@mail.gmail.com
Whole thread Raw
In response to How to disconnect a single user in Postgresql 8.2.5 from a database  (Steph L <engel306sl@yahoo.fr>)
Responses Re: How to disconnect a single user in Postgresql 8.2.5 from a database  (Josh Kupershmidt <schmiddy@gmail.com>)
List pgsql-admin
Tree view 
On 19 April 2010 15:27, Steph L <engel306sl@yahoo.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.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802

pgsql-admin by date:

Previous
From: "Josi Perez (3T Systems)"
Date:
Subject: register a service in Windows
Next
From: "Kevin Grittner"
Date:
Subject: Re: archived WALL files question