Re: how to disconnect users - Mailing list pgsql-admin

From Sergey Konoplev
Subject Re: how to disconnect users
Date
Msg-id g2oc3a7de1f1004120604o1cd958a7o8d67b52674106c03@mail.gmail.com
Whole thread Raw
In response to how to disconnect users  (Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>)
List pgsql-admin
2010/4/12 Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>:
> I need to disconnect user in my database without creating inconsistencies.
> What command should I use.

If you are using 8.4 then you can do pg_terminate_backend(pid)
function. For more info read
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: Eduardo Sá dos Reis
Date:
Subject: how to disconnect users
Next
From: Dennis Thrysøe
Date:
Subject: Re: "the database system is starting up"