X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2448BD1D264 for ; Wed, 28 Jan 2004 17:57:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 13174-07 for ; Wed, 28 Jan 2004 13:56:50 -0400 (AST) Received: from www.postgresql.com (www.postgresql.com [200.46.204.209]) by svr1.postgresql.org (Postfix) with ESMTP id 6BEACD1D92F for ; Wed, 28 Jan 2004 13:52:06 -0400 (AST) Received: from coig.katowice.pl (pluton.coig.katowice.pl [195.39.216.12]) by www.postgresql.com (Postfix) with ESMTP id 668C2CF6D48 for ; Wed, 28 Jan 2004 10:43:20 -0400 (AST) Received: from [195.39.216.20] (HELO pslupkowski) by coig.katowice.pl (CommuniGate Pro SMTP 4.1.8) with SMTP id 575303 for pgsql-sql@postgresql.org; Wed, 28 Jan 2004 14:38:14 +0100 Message-ID: <000c01c3e5a4$1cacf4c0$930f10ac@win.coig.com> From: =?iso-8859-2?Q?Przemys=B3aw_S=B3upkowski?= To: "Lista dyskusyjna pgsql-sql" Subject: managing users in postgresql 7.4.1 Date: Wed, 28 Jan 2004 14:39:11 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0009_01C3E5AC.7E5E49F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_50_60 X-Spam-Level: X-Archive-Number: 200401/237 X-Sequence-Number: 16630 This is a multi-part message in MIME format. ------=_NextPart_000_0009_01C3E5AC.7E5E49F0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable hi=20 Can you tell me how to disconnect some users from command line. I mean I wa= nt to disconnect some user from database without restarting postmaster when i do something like this select * from pg_stat_activity I had information but how can I use this to disconnect users from databases THX ------=_NextPart_000_0009_01C3E5AC.7E5E49F0 Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable
hi
Can you tell me how to disconnect some u= sers from=20 command line. I mean I want to disconnect some user from database without= =20 restarting postmaster
 
when i do something like this
 
select * from pg_stat_activity
 
I had information but how can I use this= to=20 disconnect users from databases
 
THX
------=_NextPart_000_0009_01C3E5AC.7E5E49F0--