From: Vibhor Kumar <vibhor.aim@gmail.com>
To: Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
Cc: pgsql-admin@postgresql.org
Subject: Re: how to disconnect users
Date: Mon, 12 Apr 2010 18:56:43 +0530
Message-ID: <0E59D630-3944-4245-89C6-DAD23A149479@gmail.com> (raw)
In-Reply-To: <D887A3507A6746039F4A53BF1F8D61F6@PJF123067>
References: <1A57E5A7-AEB8-412B-B3A7-D52768F2FCF7@geysirit.dk>
<EF75DFD93ED8426DBD604A45461B8A9E@PJF123067>
<4BBDA7AC0200002500030589@gw.wicourts.gov>
<D887A3507A6746039F4A53BF1F8D61F6@PJF123067>
On 12-Apr-2010, at 6:00 PM, Eduardo Sá dos Reis wrote:
> I need to disconnect user in my database without creating inconsistencies. What command should I use.
>
> Grateful
>
> Eduardo
Which Version of PostgreSQL are you using?
In PostgreSQL 8.4, you can use pg_terminate_backend() function.
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
Mob: +91-9011042623
Web:www.EnterpriseDB.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vibhor.aim@gmail.com, eduardoreis@pjf.mg.gov.br
Subject: Re: how to disconnect users
In-Reply-To: <0E59D630-3944-4245-89C6-DAD23A149479@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox