Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 57B599FCC59 for ; Fri, 26 Oct 2007 20:18:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 02751-04-2 for ; Fri, 26 Oct 2007 20:17:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from eciweb.eldocomp.com (eciweb.eldocomp.com [205.159.99.28]) by postgresql.org (Postfix) with ESMTP id 272F99FCDC7 for ; Fri, 26 Oct 2007 20:17:48 -0300 (ADT) Received: from ecimail.eldocomp.com [172.20.128.2] by eciweb.eldocomp.com with XWall v3.38 ; Fri, 26 Oct 2007 16:17:45 -0700 Received: from [127.0.0.1] ([172.20.131.10]) by ecimail.eldocomp.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 26 Oct 2007 16:17:43 -0700 References: <26960.1193434395@sss.pgh.pa.us> <20071026144005.3aa6cc29@scratch> <27413.1193435100@sss.pgh.pa.us> <472262A5.2020605@mhs.mphasis.com> <1065.1193440140@sss.pgh.pa.us> In-Reply-To: <1065.1193440140@sss.pgh.pa.us> From: Naomi Walker To: Tom Lane Cc: "Milen A. Radev" , "pgsql-admin@postgresql.org" Subject: Re: Find the Person Connected to a Database Date: Fri, 26 Oct 2007 16:17:43 -0700 X-Assembled-By: XWall v3.38 Message-ID: <47227597.7030306@mhs.mphasis.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.282 tagged_above=0 required=5 tests=AWL=1.484, BAYES_00=-2.599, HTML_MESSAGE=0.001, MIME_QP_LONG_LINE=1.396 X-Spam-Level: X-Archive-Number: 200710/276 X-Sequence-Number: 27190 This is a multi part MIME message. --_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks for jogging my memory! Works like a charm. Naomi >> select * from pg_stat_activity where datname =3D ; >> =20 > > If that doesn't work because you've got stats collection turned off, > "ps" will help too: > > http://www.postgresql.org/docs/8.1/static/monitoring.html > > On Solaris, note the Tip at the bottom (not sure if it applies to recent > Solaris versions but a few years ago it was critical). > > regards, tom lane > =20 --=20 ------------------------------------------------------------------------ Naomi Walker Chief Information Officer Mphasis Healthcare Solutions nwalker@mhs.mphasis.com =20 ---An EDS Company 602-604-3100 ------------------------------------------------------------------------ "Intellectuals solve problems; geniuses prevent them." =20 -- Albert Einstein ------------------------------------------------------------------------ -- CONFIDENTIALITY NOTICE -- Information transmitted by this=C2=A0e-mail is proprietary to MphasiS and/or= its Customers and is intended for use only by the individual or entity to w= hich it is addressed, and may contain information that is=C2=A0privileged, c= onfidential or exempt from disclosure under applicable law. If you are not t= he intended recipient or it appears that this e-mail has been forwarded to y= ou without proper authority, you are notified that any use or dissemination = of this information in any manner is strictly prohibited. In such cases, ple= ase notify us immediately at mailmaster@mphasis.com and delete this mail fro= m your records. --_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable =20 Thanks for jogging my memory!  Works like a charm.

Naomi
=20
=20
select * from pg_stat_activity where datname =3D <th=
e_db_about_to_be_dropped>;
=20   
=20
=20

If that doesn't work because you've got stats collection turned off,
"ps" will help too:

http://www.postgresql.org/docs/8.1/static/monitori=
ng.html

On Solaris, note the Tip at the bottom (not sure if it applies to recent
Solaris versions but a few years ago it was critical).

=09		regards, tom lane
=20 


--=20
------------------------------------------------------------------------
Naomi Walker                          Chief Information Officer
Mphasis Healthcare Solutions          nwalker@mhs.mphasis.com
=20 ---An EDS Company                   602-604-3100
------------------------------------------------------------------------
"Intellectuals solve problems; geniuses prevent them."
=20 --  Albert Einstein
------------------------------------------------------------------------











-- CONFIDENTIALITY NOTICE --







-- CONFIDENTIALITY NOTICE --

Info= rmation transmitted by this=A0e-mail is proprietary to MphasiS and/ or its Customers and is inte= nded for use only by the individual or entity to which it is addressed, and may contain inform= ation that is privileged, confidential or exempt from disclosure under applicable law. If = you are not the intended recipient or it appears that this mail has been forwarded to you wi= thout proper authority, you are notified that any use or dissemination of this informatio= n in any manner is strictly prohibited. In such cases, please notify us immediately at mailm= aster@mphasis.com and delete this e-mail from your records.

 

--_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb--