Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id BF87E9F9DEF for ; Fri, 26 Oct 2007 19:12:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 27158-08 for ; Fri, 26 Oct 2007 19:12:01 -0300 (ADT) X-Greylist: delayed 00:15:04.018937 by SQLgrey-1.7.5 Received: from eciweb.eldocomp.com (eciweb.eldocomp.com [205.159.99.28]) by postgresql.org (Postfix) with ESMTP id 577A39F9B90 for ; Fri, 26 Oct 2007 19:12:00 -0300 (ADT) Received: from ecimail.eldocomp.com [172.20.128.2] by eciweb.eldocomp.com with XWall v3.38 ; Fri, 26 Oct 2007 14:56:54 -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 14:56:53 -0700 References: <26960.1193434395@sss.pgh.pa.us> <20071026144005.3aa6cc29@scratch> <27413.1193435100@sss.pgh.pa.us> In-Reply-To: <27413.1193435100@sss.pgh.pa.us> From: Naomi Walker Cc: "pgsql-admin@postgresql.org" Subject: Find the Person Connected to a Database Date: Fri, 26 Oct 2007 14:56:53 -0700 X-Assembled-By: XWall v3.38 Message-ID: <472262A5.2020605@mhs.mphasis.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.503 tagged_above=0 required=5 tests=BAYES_40=-0.185, MIME_QP_LONG_LINE=1.396, MISSING_HEADERS=1.292 X-Spam-Level: ** X-Archive-Number: 200710/271 X-Sequence-Number: 27185 I'm trying to drop a database in a postgres 8.1.4 instance (x86 Solaris=20 10 OS), but someone is connected to the database. What is the best way to find out exactly who is connected? Thanks, Naomi --=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.