Обсуждение: Disconnect from all dbs
Hi all,
On my development machine I keep 40+ databases and during a typical day I will open several of them to answer support calls or carry on development.
Although I can disconnect from individual db one by one it is a tad slow process so I would love to be able to disconnect from all open databases on a server in one go, but could not find how to do it.
Is that possible ?
have a good day
Didier
On Mon, Sep 30, 2019 at 1:51 PM Didier Gasser-Morlay <didiergm@gmail.com> wrote:
Hi all,On my development machine I keep 40+ databases and during a typical day I will open several of them to answer support calls or carry on development.Although I can disconnect from individual db one by one it is a tad slow process so I would love to be able to disconnect from all open databases on a server in one go, but could not find how to do it.Is that possible ?
All the connected databases will be disconnected if you just disconnect the server itself.
have a good dayDidier
I tried that already but unfortunately when you reconnect the server all previously connected dbs will reconnect along with the display layout they were in (how much the tree below the db was expanded)
what I would like is a way to "close" or disconnect from all opened dbs and collapse the tree view for each individual db
On Mon, 30 Sep 2019 at 10:28, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:
On Mon, Sep 30, 2019 at 1:51 PM Didier Gasser-Morlay <didiergm@gmail.com> wrote:Hi all,On my development machine I keep 40+ databases and during a typical day I will open several of them to answer support calls or carry on development.Although I can disconnect from individual db one by one it is a tad slow process so I would love to be able to disconnect from all open databases on a server in one go, but could not find how to do it.Is that possible ?All the connected databases will be disconnected if you just disconnect the server itself.have a good dayDidier
Hi,
On Mon, Sep 30, 2019 at 3:38 PM Didier Gasser-Morlay <didiergm@gmail.com> wrote:
I tried that already but unfortunately when you reconnect the server all previously connected dbs will reconnect along with the display layout they were in (how much the tree below the db was expanded)
When you click on the database node, then it will connect (except the maintenance database) and expand the tree view. You can also disable the automatic tree expanding feature by setting the value of File > Preferences > Browser tree state saving interval to -1.
what I would like is a way to "close" or disconnect from all opened dbs and collapse the tree view for each individual db
Still you think your requirement doesn't match then create the feature request for the same @ https://redmine.postgresql.org/projects/pgadmin4
Thanks,
Khushboo
On Mon, 30 Sep 2019 at 10:28, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:On Mon, Sep 30, 2019 at 1:51 PM Didier Gasser-Morlay <didiergm@gmail.com> wrote:Hi all,On my development machine I keep 40+ databases and during a typical day I will open several of them to answer support calls or carry on development.Although I can disconnect from individual db one by one it is a tad slow process so I would love to be able to disconnect from all open databases on a server in one go, but could not find how to do it.Is that possible ?All the connected databases will be disconnected if you just disconnect the server itself.have a good dayDidier