pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how 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>
  2010-04-12 13:04 ` Re: how to disconnect users Sergey Konoplev <gray.ru@gmail.com>
  2010-04-12 13:26 ` Re: how to disconnect users Vibhor Kumar <vibhor.aim@gmail.com>
  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 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>
  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 12:30 how to disconnect users Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
@ 2010-04-12 13:26 ` Vibhor Kumar <vibhor.aim@gmail.com>
  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