pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to disconnect users
3+ messages / 3 participants
[nested] [flat]
* how to disconnect users
@ 2010-04-12 12:30 Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
0 siblings, 2 replies; 3+ messages in thread
From: Eduardo Sá dos Reis @ 2010-04-12 12:30 UTC (permalink / raw)
To: pgsql-admin
I need to disconnect user in my database without creating inconsistencies. What command should I use.
Grateful
Eduardo
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: how to disconnect users
@ 2010-04-12 13:04 Sergey Konoplev <gray.ru@gmail.com>
parent: Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
1 sibling, 0 replies; 3+ messages in thread
From: Sergey Konoplev @ 2010-04-12 13:04 UTC (permalink / raw)
To: Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: how to disconnect users
@ 2010-04-12 13:26 Vibhor Kumar <vibhor.aim@gmail.com>
parent: Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
1 sibling, 0 replies; 3+ messages in thread
From: Vibhor Kumar @ 2010-04-12 13:26 UTC (permalink / raw)
To: Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-04-12 13:26 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-04-12 12:30 how to disconnect users Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
2010-04-12 13:04 ` Sergey Konoplev <gray.ru@gmail.com>
2010-04-12 13:26 ` Vibhor Kumar <vibhor.aim@gmail.com>
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