pgbouncer default password / secret? #754
Unanswered
stanvv
asked this question in
Questions & Answers
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
We have a setup with pgbouncer enabled.
pgbouncer: enabled: true
We try to setup the pgbouncer exporter from prometheus community: https://artifacthub.io/packages/helm/prometheus-community/prometheus-pgbouncer-exporter
To setup the connection string, we need a username and a password. I tried to use the default "pgbouncer" user (which by default is the only user with permissions on the pgbouncer database), but could not find the password.
For now I've manually fixed it by granting a manually created user access to the pgbouncer database (
grant all privileges on database pgbouncer to mycustomuser@mypostgreqldatabase;
) and manually adding that same user asadmin_user
topgbouncer.ini
in the pgbouncer pod.But obviously that's a mess to setup in code eventually.
Therefore two questions:
2a: I cannot find a way to add
admin_users
to pgbouncer.ini via helm values.2b: I cannot find a way to edit the auth_file (/home/pgbouncer/users.txt) before deployment
Beta Was this translation helpful? Give feedback.
All reactions