Re: pgadmin 3.5 drop database fails because of active connection

Поиск
Список
Период
Сортировка
От Khushboo Vashi
Тема Re: pgadmin 3.5 drop database fails because of active connection
Дата
Msg-id CAFOhELfXStHuXpkhfOP_ehQanHVhEeRhqbmCtf1+9fW1ez8dFw@mail.gmail.com
обсуждение исходный текст
Ответ на pgadmin 3.5 drop database fails because of active connection  (John Nowlan <JohnNowlan@Cunet.Carleton.Ca>)
Ответы RE: pgadmin 3.5 drop database fails because of active connection
Список pgadmin-support
Дерево обсуждения


On Sat, Nov 17, 2018 at 7:06 PM John Nowlan <JohnNowlan@cunet.carleton.ca> wrote:

Version

3.5

Copyright

Copyright 2013 - 2018, The pgAdmin Development Team

Python Version

3.6.5 (v3.6.5:f59c0932b4, Mar 28 2018, 16:07:46) [MSC v.1900 32 bit (Intel)]

Flask Version

0.12.4

Application Mode

Desktop

Current User

pgadmin4@pgadmin.org

 

-          windows 10

-          desktop

 

I try and click on a db in tree view and from menu select delete/drop

-          get msg:

Error message

ERROR: database "mah" is being accessed by other users DETAIL: There is 1 other session using the database.

-          Appears selecting the db from tree view creates session, therefore always a session to db and unable to drop from gui

This should not be the case.The database connection has been closed before deleting it. 
There should be another session (Ex: psql, query tool) which is creating this problem. So, try to close all the sessions before deleting any database from GUI.

 

 

В списке pgadmin-support по дате отправления: