pgadmin4 icon indicating copy to clipboard operation
pgadmin4 copied to clipboard

Add menu option to close all server connections (RM #3533)

Open dpage opened this issue 7 years ago • 5 comments

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.

dpage avatar Aug 01 '18 05:08 dpage

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

dpage avatar Aug 03 '18 10:08 dpage

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

dpage avatar Aug 08 '18 16:08 dpage

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

dpage avatar Sep 06 '18 13:09 dpage

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

dpage avatar Oct 08 '18 09:10 dpage

Disconnect all databases should be implemented if possible.

akshay-joshi avatar Jun 21 '24 11:06 akshay-joshi

Tested and verified on source code. Environment: macOs 13.5.1

anilsahoo20 avatar Nov 06 '24 10:11 anilsahoo20