Being able to create or import PgBouncer users through the PerconaPGCluster CR

[ennekein]

Proposal

At the moment, the operator creates only one user _crunchypgbouncer in the users.txt file for PgBouncer. We would benefit from being able to create our own users with the right set of permissions,

Either of these options would work:

1. Being able to create users for PgBouncer in the proxy config in the PerconaPGCluster the same way it is done for PostgreSQL in the users section.
2. Being able to propagate roles created in the users section to PgBouncer.

Use-Case

This would allow us to use the PgBouncer metrics exporter with a user that has the appropriate permissions.

Is this a feature you are interested in implementing yourself?

No

Anything else?

No response

[hors]

Hi @ennekein we have a task about it https://perconadev.atlassian.net/browse/K8SPG-650 . We will implement it soon

[ennekein]

@hors Great, thank you!