X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E69AAD1B27A for ; Mon, 19 Jul 2004 18:26:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02448-10 for ; Mon, 19 Jul 2004 21:26:57 +0000 (GMT) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 73711D1B1AE for ; Mon, 19 Jul 2004 18:26:53 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i6JK3b9U027972; Mon, 19 Jul 2004 16:03:38 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i6JLQpN28834; Mon, 19 Jul 2004 17:26:52 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id 38TXWNRC; Mon, 19 Jul 2004 17:26:49 -0400 Subject: Re: users connected From: Robert Treat To: Cardoso Patrick Cc: pgsql-admin@postgresql.org In-Reply-To: <20040716144053.81CE922B150@mail.iut-rodez.fr> References: <20040716144053.81CE922B150@mail.iut-rodez.fr> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 19 Jul 2004 17:26:50 -0400 Message-Id: <1090272411.2711.48.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/222 X-Sequence-Number: 14290 On Fri, 2004-07-16 at 10:42, Cardoso Patrick wrote: > Hi, > > Is it possible to know the number of users connected to a > database ? > > Regards > > select * from pg_stat_activity; Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL