Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 27DD81337B86 for ; Tue, 9 Nov 2010 22:32:36 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 06966-06 for ; Wed, 10 Nov 2010 02:32:29 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.egcrc.net (mail.egcrc.net [63.193.204.10]) by mail.postgresql.org (Postfix) with ESMTP id C797D1337B79 for ; Tue, 9 Nov 2010 22:32:28 -0400 (AST) Received: from EGCRC-EX04.egcrc.org ([::1]) by EGCRC-EX03.egcrc.org ([::1]) with mapi; Tue, 9 Nov 2010 18:32:28 -0800 From: Tena Sakai To: Shoaib Mir CC: "pgsql-admin@postgresql.org" Date: Tue, 9 Nov 2010 18:32:28 -0800 Subject: Re: I want to find out who is using a database Thread-Topic: [ADMIN] I want to find out who is using a database Thread-Index: AcuAfqt7XVkjvnnqSAOgTuzlSVD9ygAAHONv Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-Entourage/13.4.0.100208 acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_C8FF4392D072tsakaigalloucsfedu_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201011/73 X-Sequence-Number: 36039 --_000_C8FF4392D072tsakaigalloucsfedu_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you, Shoaib. Tena On 11/9/10 6:26 PM, "Shoaib Mir" wrote: On Wed, Nov 10, 2010 at 1:17 PM, Tena Sakai wrote: Can somebody please tell me how I find who it is using the xxxxx database? select * from pg_stat_activity where datname =3D ''; --_000_C8FF4392D072tsakaigalloucsfedu_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Re: [ADMIN] I want to find out who is using a database Thank you, Shoaib.

Tena


On 11/9/10 6:26 PM, "Shoaib Mir" <shoaibmir@gmail.com> wrote:

On Wed, Nov 10, 2010 at 1:17 PM, Tena Sakai= <tsakai@gallo.ucsf.edu> wrote:=

Can somebody please tell me how I find who it is using the
xxxxx database?