Feature request: connection manager

[raphideb]

Salut Bertrand,

maybe I am missing something but I have to manually add a connection string whenever I want to connect to a database. It would help a lot if all connections that I've ever entered were saved and displayed on the database connection screen, so that I only have to enter it once. Or a even better solution would be if I could point pgAssistant to a database and table where all connections are stored, including user and pass. Table could be something like:

cluster port database username password

The connect database screen would then read all connections from that table and let me connect with a single click. If no password is stored, it could prompt the user. The deluxe version would let me select a cluster and display all databases on that cluster, I have clusters with 30 or more dbs :D

have fun!
raphael

[beh74]

Hello Raphael,

Well, storing connexions on a database : this scare me a lot for security reasons.
I am using OpenBao (Hashicorp Vault) for it. I have in mind for months a connection manager using OpenBao to list databases connexions : what do you think ?
But i will work on the "deluxe version" you mention : display all databases and select one once connected to a cluster.

[raphideb]

Hi Bertrand,

yes hashicorp vault would also work for the password (if one wants to use the same password for every database) but cluster ip and port should be stored somewhere where it can be added programmatically like in a gitlab pipeline or something. I have over 500 dbs managed by a selfservice where I would like to use pgassistant. It would not be feasable to manage them manually.

have fun!
raphael

[tedraccoon]

now, you can manage multi databases with multidatabases button in connexion section.

[raphideb]

It works, thanks a lot!