Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id B014A650EA9
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu,  3 Jul 2008 16:56: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 55430-08 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu,  3 Jul 2008 16:56:20 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.234])
	by postgresql.org (Postfix) with ESMTP id 4B564650E9F
	for <pgsql-admin@postgresql.org>; Thu,  3 Jul 2008 16:56:19 -0300 (ADT)
Received: by rv-out-0506.google.com with SMTP id b25so1287600rvf.43
	for <pgsql-admin@postgresql.org>; Thu, 03 Jul 2008 12:56:17 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:in-reply-to:references
	:mime-version:content-type:message-id:cc:content-transfer-encoding
	:from:subject:date:to:x-mailer;
	bh=/ZnCZFksYQ6xhXeagtvYWTvbDroJwcgazvNHb8HU9Ok=;
	b=Hyau41D81wFp3Cegg2FIywp5vKtlJCVFjc9jNs1WfP60bljsBU72A9pwNOsqCWy4+m
	W7UWq0y9RxrRSGKSx3vw54IlgYTdiGgSzGQu6uBwHBk4emPNck0sWEP0sTtymx303Yuq
	A+HhPLTKuGhBJxZOwR0Xk4YQT4hAdCyyWEFsM=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=in-reply-to:references:mime-version:content-type:message-id:cc
	:content-transfer-encoding:from:subject:date:to:x-mailer;
	b=Ka5dQHudrM58vsPo0j5ttQwQ2pTeCnp6YwrC/0ynuuMcQB1PHIF8dOoawpq3PKXEQK
	yExwRZVIyB9k/w1H9S6o2Le5FVrWWTwYbA4iMhbQ8YPozj2zEgAWzUhZYCsdhgWlGJ/q
	J3aAvqpK8Ov4tCqtbYO0mrPgEwAC9CL0X1JMI=
Received: by 10.114.148.1 with SMTP id v1mr1360027wad.199.1215114976855;
	Thu, 03 Jul 2008 12:56:16 -0700 (PDT)
Received: from ?192.168.0.24? ( [83.14.243.146])
	by mx.google.com with ESMTPS id s10sm789954mue.16.2008.07.03.12.55.44
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Thu, 03 Jul 2008 12:56:15 -0700 (PDT)
In-Reply-To: <9CB3C6A7-9E59-4A40-94BB-C2EE4150EC21@indiana.edu>
References: <9CB3C6A7-9E59-4A40-94BB-C2EE4150EC21@indiana.edu>
Mime-Version: 1.0 (Apple Message framework v753.1)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <5FDC87F1-8C5F-404B-BB63-8EB14CF5984C@gmail.com>
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: 7bit
From: paul socha <pawel.socha@gmail.com>
Subject: Re: Who's attached to the database?
Date: Thu, 3 Jul 2008 21:55:41 +0200
To: Carol Walter <walterc@indiana.edu>
X-Mailer: Apple Mail (2.753.1)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200807/53
X-Sequence-Number: 29663


On 2008-07-03, at 21:45, Carol Walter wrote:

> 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



  select * from pg_stat_activity  where datname='<database2drop>';


--

Pawel Socha
pawel.socha@gmail.com


perl -le 's**02).4^&-%2,).^9%4^!./4(%2^3,!#+7!2%^53%2&**y%& -;^[%"`- 
{ a%%s%%$_%ee'