percona / percona/percona-postgresql-operator
Being able to create or import PgBouncer users through the PerconaPGCluster CR
Nobody has claimed this yet.
- Dominant language
- Go
- Stars
- 385
- Forks
- 83
- Avg merge
- 2d 5h
- Merged PRs (30d)
- 39
Description
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:
- 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.
- 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
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by tracing how the PerconaPGCluster CR's users section is translated into PostgreSQL roles and how the PgBouncer users.txt file is generated. Compare the two proposed approaches and determine which configuration path can support the metrics exporter; done means the CR can provision or propagate an appropriately permissioned PgBouncer user.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, kubernetes, postgresql
- Domain
- databases, infrastructure
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100