Re: Incorrect "ERROR: database "xxx" is being accessed by other users"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Incorrect "ERROR: database "xxx" is being accessed by other users"
Дата
Msg-id 26311.1173773267@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Incorrect "ERROR: database "xxx" is being accessed by other users"  ("Dmitry Koterov" <dmitry@koterov.ru>)
Ответы Re: Incorrect "ERROR: database "xxx" is being accessed by other users"
Список pgsql-general
Дерево обсуждения 
"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 по дате отправления:

Предыдущее
От: "Dmitry Koterov"
Дата:
Сообщение: Incorrect "ERROR: database "xxx" is being accessed by other users"
Следующее
От: "Dmitry Koterov"
Дата:
Сообщение: Re: Incorrect "ERROR: database "xxx" is being accessed by other users"