I'm finding an issue with the included user for pgbouncer in the postgres_operator_examples repo named "_crunchypgbouncer"; it appears it is not valid yaml for a user in the helmchart.
The error I get is when trying to apply the manifest:
The PostgresCluster "hippo-ha" is invalid: spec.users[0].name: Invalid value: "_crunchypgbouncer": spec.users[0].name in body should match '^[a-z0-9]([-a-z0-9]*[a-z0-9])?$'
That is invalid.
I have an init.sql configmap with this otherwise I get schema errors for using PG16
apiVersion: v1
kind: ConfigMap
metadata:
name: hippo-init-sql
namespace: postgres-operator
data:
init.sql: |-
\c hippo-ha
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO _crunchypgbouncer;
ALTER DEFAULT PRIVILEGES IN SCHEMA pgbouncer GRANT SELECT ON TABLES TO _crunchypgbouncer;
So when that failed, I tried adding the user to pgbouncer using the HelmChart values. Example:
But it seems to only get values from a secret named hippo-ha-pgbouncer where the only user is "_crunchypgbouncer".
I'm having trouble adding custom users to pgbouncer or using the included user to run pgbench against the example HA postgres database from the postgres_operator_examples repository.
I'm finding an issue with the included user for
pgbouncer
in thepostgres_operator_examples
repo named "_crunchypgbouncer"; it appears it is not valid yaml for a user in the helmchart.The error I get is when trying to apply the manifest:
The PostgresCluster "hippo-ha" is invalid: spec.users[0].name: Invalid value: "_crunchypgbouncer": spec.users[0].name in body should match '^[a-z0-9]([-a-z0-9]*[a-z0-9])?$'
That is invalid.
I have an init.sql configmap with this otherwise I get schema errors for using PG16
So when that failed, I tried adding the user to
pgbouncer
using the HelmChart values. Example:So with that I try pass in this configmap with a test user:
But it seems to only get values from a secret named hippo-ha-pgbouncer where the only user is "_crunchypgbouncer".
I'm having trouble adding custom users to
pgbouncer
or using the included user to runpgbench
against the example HA postgres database from thepostgres_operator_examples
repository.Any advice/input greatly appreciated.