Add a user with psql and PGBouncer active

Please, answer some short questions which should help us to understand your problem / question better?

• Which image of the operator are you using? e.g. registry.opensource.zalan.do/acid/postgres-operator:v1.7.0
• Where do you run it - cloud or metal? Kubernetes or OpenShift? Bare Metal K8s
• Are you running Postgres Operator in production? yes
• Type of issue? question

When trying to add a new user and DB with psql and afterwards trying to access the new DB with the newly created user through the PGBouncer we always receive:

pooler error: unexpected response from login query

And psql tells us:

psql: error: connection to server at "XXXX.triebwork.com", port 32241 failed: ERROR:  unexpected response from login query

I don't understand this error, as I thought, that PGBouncer is using the auth_query to ask postgres about user-permissions...

When trying to connect directly to the DB it works immediately.

How can we dynamically add and delete users and still use the PGBouncer?

No files, tests, or entry points are mentioned. Start by reproducing the difference between direct PostgreSQL access and the PgBouncer path, then inspect how auth_query handles users created through psql. Done means documenting a supported way to add and delete users while retaining PgBouncer access.