Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3C80F650E23 for ; Fri, 4 Jul 2008 10:47:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 55509-02 for ; Fri, 4 Jul 2008 10:47:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n4b.bullet.mail.ac4.yahoo.com (n4b.bullet.mail.ac4.yahoo.com [76.13.13.74]) by postgresql.org (Postfix) with SMTP id 7BA9E64FD64 for ; Fri, 4 Jul 2008 10:47:26 -0300 (ADT) Received: from [76.13.13.26] by n4.bullet.mail.ac4.yahoo.com with NNFMP; 04 Jul 2008 05:38:01 -0000 Received: from [76.13.10.171] by t3.bullet.mail.ac4.yahoo.com with NNFMP; 04 Jul 2008 13:47:24 -0000 Received: from [127.0.0.1] by omp112.mail.ac4.yahoo.com with NNFMP; 04 Jul 2008 13:47:24 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 4528.30024.bm@omp112.mail.ac4.yahoo.com Received: (qmail 36351 invoked by uid 60001); 4 Jul 2008 13:47:23 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=LvULqf9kw3us2L/ki2BJZg47FK9I44un3NdcmmhRKqOZPXQrSQtOIo7lzJycP/EkB4iXLRVoD856O9S+HgkzcWhDwLMIHXnWhK7bs2yIwsrxsNAWF3/fhyfXVCq4IaQJf8D75ItMiFi8MsKsIAL1gB/JmeWbNvR5gBV3hIOft7Q=; Received: from [209.88.228.11] by web59510.mail.ac4.yahoo.com via HTTP; Fri, 04 Jul 2008 06:47:23 PDT X-Mailer: YahooMailWebService/0.7.199 Date: Fri, 4 Jul 2008 06:47:23 -0700 (PDT) From: Lennin Caro Reply-To: lennin.caro@yahoo.com Subject: Re: Who's attached to the database? To: pgsql-admin@postgresql.org, Carol Walter In-Reply-To: <9CB3C6A7-9E59-4A40-94BB-C2EE4150EC21@indiana.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <807218.35260.qm@web59510.mail.ac4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.201 tagged_above=0 required=5 tests=AWL=0.013, RCVD_IN_BL_SPAMCOP_NET=2.188 X-Spam-Level: ** X-Archive-Number: 200807/65 X-Sequence-Number: 29675 ps auxw | grep postgres list the user and some time the process in execution --- On Thu, 7/3/08, Carol Walter wrote: > From: Carol Walter > Subject: [ADMIN] Who's attached to the database? > To: pgsql-admin@postgresql.org > Date: Thursday, July 3, 2008, 7:45 PM > Hi, Guys, > > I'm trying to drop a database and I'm getting an > error that says that > the database is being accessed by other users. Is there a > way I can > find out who these users are or if there really is a user > accessing it? > > Carol > > -- > Sent via pgsql-admin mailing list > (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin