PGAdmin add DB-Users automatically

[MSandro]

Have an idea to improve PGO? We'd love to hear it! We're going to need some information from you to learn more about your feature requests.

Please be sure you've done the following:

• [X] Provide a concise description of your feature request.
• [X] Describe your use case. Detail the problem you are trying to solve.
• [X] Describe how you envision that the feature would work.
• [X] Provide general information about your current PGO environment.

Overview

It would be great if the servers would be automatically added to PGAdmin with the corresponding user accounts.

Use Case

It would only be a small improvement to not have to look up the username before logging in. Every time PGAdmin restarts, the server credentials are lost, this is annoying. I can still understand that the passwords are not persistently stored, but the handling of the usernames is annoying.

Desired Behavior

• a server entry could be created automatically for each user to PGAdmin
• a YAML field in the PostgresCluster to define that this user should be included in the PGAdmin.

Environment

Tell us about your environment:

Please provide the following details:

• Platform: (Kubernetes, OpenShift, Rancher, GKE, EKS, AKS etc.) Rancher RKE2
• Platform Version: (e.g. 1.20.3, 4.7.0) 1.30.3
• PGO Image Tag: (e.g. ubi8-5.x.y-0) ubi8-5.6.1-0
• Postgres Version (e.g. 15) 16
• Storage: (e.g. hostpath, nfs, or the name of your storage class) VSphere CSI
• Number of Postgres clusters: (XYZ) 18

[jmckulk]

Hello @MSandro, taking a look at this after a while. Are you still interested in this issue? Can you confirm if you are using the PGAdmin api and its user management features or are you using the pgAdmin included through the PostgresCluster API?