Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8DB219FC925 for ; Fri, 26 Oct 2007 19:25:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18423-05 for ; Fri, 26 Oct 2007 19:25:21 -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 C34539FC7FA for ; Fri, 26 Oct 2007 19:25:19 -0300 (ADT) Received: from ecimail.eldocomp.com [172.20.128.2] by eciweb.eldocomp.com with XWall v3.38 ; Fri, 26 Oct 2007 15:25:18 -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 15:25:17 -0700 From: Naomi Walker To: "pgsql-admin@postgresql.org" Subject: Find who is connected to a database Date: Fri, 26 Oct 2007 15:25:17 -0700 X-Assembled-By: XWall v3.38 Message-ID: <4722694D.3050109@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=1.95 tagged_above=0 required=5 tests=AWL=0.553, BAYES_50=0.001, MIME_QP_LONG_LINE=1.396 X-Spam-Level: * X-Archive-Number: 200710/273 X-Sequence-Number: 27187 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.