Add menu option to close all server connections (RM #3533)
Issue migrated from Redmine: https://redmine.postgresql.org/issues/3533 Originally created by Michael Krueger at 2018-08-01 05:47:42 UTC.
I stumbled upon the case, where I tried to connect to one server in my servergroup, using a user that had very limited permissions to the point he was not able to query the db objects tree. PGAdmin4 generated an internal error, and I thought it to be wise that I restart PGAdmin backend. After restart I opened a new browser window, and PGAdmin (due to saved sessions) tried to restore my previously failing db connection. That in turn prohibited me from disconnecting that server manually, as I was not able to reach that server in the group. Cleaning the local session cache under .pgadmin/ I was able to get PGAdmin back to work.
To not have to go to the disk to remove the sessions, I recommend a menu option that would stop PGAdmin4 from attempting to connect to any previously connected server. Something like "Close all server connections" should to the trick. Then I expect to be able to open the server group again, to reach the failing server, to be able to change its properties.
Comment migrated from Redmine: https://redmine.postgresql.org/issues/3533#note-1 Originally created by Khushboo Vashi at 2018-08-03 10:19:03 UTC.
Redmine ticket header update:
| Name | Old Value | New Value |
|---|---|---|
| Sprint changed | Ready |
Comment migrated from Redmine: https://redmine.postgresql.org/issues/3533#note-2 Originally created by Dave Page at 2018-08-08 16:19:23 UTC.
Redmine ticket header update:
| Name | Old Value | New Value |
|---|---|---|
| Fixed Version changed | 3.2 | 3.3 |
Comment migrated from Redmine: https://redmine.postgresql.org/issues/3533#note-3 Originally created by Dave Page at 2018-09-06 13:02:28 UTC.
Redmine ticket header update:
| Name | Old Value | New Value |
|---|---|---|
| Fixed Version changed | 3.3 | 3.4 |
Comment migrated from Redmine: https://redmine.postgresql.org/issues/3533#note-4 Originally created by Dave Page at 2018-10-08 09:05:23 UTC.
Redmine ticket header update:
| Name | Old Value | New Value |
|---|---|---|
| Fixed Version changed | 3.4 |
Disconnect all databases should be implemented if possible.
Tested and verified on source code. Environment: macOs 13.5.1