Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 37C6B1337B68
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  9 Nov 2010 22:23:46 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 45789-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 10 Nov 2010 02:23:38 +0000 (UTC)
X-Greylist: delayed 00:05:33.456326 by SQLgrey-1.7.6
Received: from mail.egcrc.net (mail.egcrc.net [63.193.204.10])
	by mail.postgresql.org (Postfix) with ESMTP id 78DB51336B42
	for <pgsql-admin@postgresql.org>; Tue,  9 Nov 2010 22:23:38 -0400 (AST)
Received: from EGCRC-EX04.egcrc.org ([::1]) by EGCRC-EX03.egcrc.org ([::1])
	with mapi; Tue, 9 Nov 2010 18:17:49 -0800
From: Tena Sakai <tsakai@gallo.ucsf.edu>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Date: Tue, 9 Nov 2010 18:17:48 -0800
Subject: I want to find out who is using a database
Thread-Topic: I want to find out who is using a database
Thread-Index: AcuAfROzfb1bZCtqTb6tgYv7Z2dndQ==
Message-ID: <C8FF4024.D06A%tsakai@gallo.ucsf.edu>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
user-agent: Microsoft-Entourage/13.4.0.100208
acceptlanguage: en-US
Content-Type: multipart/alternative;
	boundary="_000_C8FF4024D06Atsakaigalloucsfedu_"
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201011/69
X-Sequence-Number: 36035

--_000_C8FF4024D06Atsakaigalloucsfedu_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi Everybody,

I want to drop a database and recreate it from a backup file.
But when I issue a dropdb command it wouldn=92t let me do
so.  It tells me: database xxxxx is being accessed by other
users.

Can somebody please tell me how I find who it is using the
xxxxx database?

Thank you.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu

--_000_C8FF4024D06Atsakaigalloucsfedu_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html><head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252"><title>I want to find out who is using a database</title>
</head>
<body>
<font face=3D"Calibri, Verdana, Helvetica, Arial"><span style=3D"font-size:=
11pt">Hi Everybody,<br>
<br>
I want to drop a database and recreate it from a backup file.<br>
But when I issue a dropdb command it wouldn=92t let me do<br>
so. &nbsp;It tells me: database xxxxx is being accessed by other<br>
users.<br>
<br>
Can somebody please tell me how I find who it is using the<br>
xxxxx database?<br>
<br>
Thank you.<br>
<br>
Regards,<br>
<br>
Tena Sakai<br>
<a href=3D"tsakai@gallo.ucsf.edu">tsakai@gallo.ucsf.edu</a></span></font>
</body>
</html>


--_000_C8FF4024D06Atsakaigalloucsfedu_--