Postgres Pro
Downloads
Home   >   mailing lists

Re: Incorrect "ERROR: database "xxx" is being accessed by other users" - Mailing list pgsql-general

From Dmitry Koterov
Subject Re: Incorrect "ERROR: database "xxx" is being accessed by other users"
Date
Msg-id d7df81620703130141l41c2208bl87494ef4f7a8d75a@mail.gmail.com
Whole thread Raw
In response to Re: Incorrect "ERROR: database "xxx" is being accessed by other users"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Incorrect "ERROR: database "xxx" is being accessed by other users"  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view
Yes, I have one!
How to remove it now? I tried DEALLOCATE for gid returned by

select * from pg_prepared_xacts;

but it says "prepared statement does not exist"...
Database restart does not reset the prepared transaction...


On 3/13/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Dmitry Koterov" <dmitry@koterov.ru> writes:
> I have a database which I cannot delete (the same for rename):
> ERROR:  database "xxx" is being accessed by other users
> But it is NOT accessed by anybody, because:

Have you checked for prepared transactions in that DB?  See
pg_prepared_xacts view (I've been burnt by that myself...)

                        regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Incorrect "ERROR: database "xxx" is being accessed by other users"
Next
From: "Albe Laurenz"
Date:
Subject: Re: Incorrect "ERROR: database "xxx" is being accessed by other users"