Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Incorrect "ERROR: database "xxx" is being accessed by other users"
Date
Msg-id 26311.1173773267@sss.pgh.pa.us
Whole thread Raw
In response to Incorrect "ERROR: database "xxx" is being accessed by other users"  ("Dmitry Koterov" <dmitry@koterov.ru>)
Responses Re: Incorrect "ERROR: database "xxx" is being accessed by other users"  ("Dmitry Koterov" <dmitry@koterov.ru>)
List pgsql-general
Tree view 
"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: "Dmitry Koterov"
Date:
Subject: Incorrect "ERROR: database "xxx" is being accessed by other users"
Next
From: "Dmitry Koterov"
Date:
Subject: Re: Incorrect "ERROR: database "xxx" is being accessed by other users"