Thread: pgadmin 3.5 drop database fails because of active connection
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
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
- 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
I stand corrected. Looks like it was pgbouncer..
Thanks
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.