From: Scott Marlowe <scott.marlowe@gmail.com>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database in use?
Date: Wed, 4 Mar 2009 14:53:26 -0700
Message-ID: <dcc563d10903041353y4e094d8dt29cce4f30c9080f6@mail.gmail.com> (raw)
In-Reply-To: <1B70D8AC-E1AF-42F2-85D9-92BF3C975ED7@indiana.edu>
References: <EA6C319D-9983-438C-8CB9-5424605A5CE1@indiana.edu>
<23817.1236025942@sss.pgh.pa.us>
<91CFD986-3CF6-4419-9908-2FEF9C469441@indiana.edu>
<28543.1236029013@sss.pgh.pa.us>
<27F905C5-A238-446A-A0E8-21174783E46C@indiana.edu>
<1730.1236043881@sss.pgh.pa.us>
<1B70D8AC-E1AF-42F2-85D9-92BF3C975ED7@indiana.edu>
On Wed, Mar 4, 2009 at 2:40 PM, Carol Walter <walterc@indiana.edu> wrote:
> This has happened or is happening to me again, only this time, it's a
> database that I just created. I restored another database into a test
> database. One of the tables is empty. I want to drop the test database and
> create a new one. When I try to drop the test database, I get this error -
> template1=# drop database km_tezt;
> ERROR: database "km_tezt" is being accessed by other users
>
> template1=# select * from pg_prepared_xacts;
> transaction | gid | prepared | owner | database
> -------------+-----+----------+-------+----------
> (0 rows)
What does "select * from pg_stat_activity say about this db?
> This database is one that I created just a few hours ago just to test some
> things myself. There can be no one in it except me. I completely closed
Correct me if I'm wrong, but isn't that enough ((just you) to cause
the drop database to fail?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, walterc@indiana.edu
Subject: Re: Database in use?
In-Reply-To: <dcc563d10903041353y4e094d8dt29cce4f30c9080f6@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox