Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 224419FB6BA for ; Sun, 28 Oct 2007 09:04:18 -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 48523-07 for ; Sun, 28 Oct 2007 09:04:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id 0EF2A9FB4D2 for ; Sun, 28 Oct 2007 09:04:13 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1Im6sG-0005ZV-Uz for pgsql-admin@postgresql.org; Sun, 28 Oct 2007 05:04:12 -0700 Message-ID: <13452689.post@talk.nabble.com> Date: Sun, 28 Oct 2007 05:04:12 -0700 (PDT) From: rski To: pgsql-admin@postgresql.org Subject: Re: Find who is connected to a database In-Reply-To: <4722694D.3050109@mhs.mphasis.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Nabble-From: robertski@o2.pl References: <4722694D.3050109@mhs.mphasis.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.774 tagged_above=0 required=5 tests=AWL=0.745, BAYES_00=-2.599, DNS_FROM_OPENWHOIS=1.13, WHOIS_MYPRIVREG=1.499 X-Spam-Level: X-Archive-Number: 200710/290 X-Sequence-Number: 27204 The best way is to turn on logs (logging connections and disconnetciona). b= ut you can also check it from database just check the pg_stat_activity table. Naomi Walker-3 wrote: >=20 > 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? >=20 > Thanks, > Naomi >=20 > --=20 > ------------------------------------------------------------------------ > Naomi Walker Chief Information Officer > Mphasis Healthcare Solutions nwalker@mhs.mphasis.com > ---An EDS Company 602-604-3100 > ------------------------------------------------------------------------ > "Intellectuals solve problems; geniuses prevent them." > -- Albert Einstein > ------------------------------------------------------------------------ >=20 > -- CONFIDENTIALITY NOTICE -- >=20 > Information transmitted by this=C3=82 e-mail is proprietary to MphasiS an= d/or > its Customers and is intended for use only by the individual or entity to > which it is addressed, and may contain information that is=C3=82 privileg= ed, > confidential or exempt from disclosure under applicable law. If you are > not the intended recipient or it appears that this e-mail has been > forwarded to you without proper authority, you are notified that any use > or dissemination of this information in any manner is strictly prohibited= . > In such cases, please notify us immediately at mailmaster@mphasis.com and > delete this mail from your records. >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >=20 >=20 --=20 View this message in context: http://www.nabble.com/Find-who-is-connected-t= o-a-database-tf4700115.html#a13452689 Sent from the PostgreSQL - admin mailing list archive at Nabble.com.