Skip to content

PGAdmin add DB-Users automatically #3984

Open
@MSandro

Description

@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:

  • Provide a concise description of your feature request.
  • Describe your use case. Detail the problem you are trying to solve.
  • Describe how you envision that the feature would work.
  • 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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions