postgres-operator-examples icon indicating copy to clipboard operation
postgres-operator-examples copied to clipboard

PGBouncer config

Open rgherta opened this issue 3 years ago • 1 comments

Can we atm customize the pgbouncer settings like max_conn etc ? the config file is managed by the operator and I see nothing helpful in the CRDs.

rgherta avatar Jan 28 '22 19:01 rgherta

Hi @rgherta I believe you can customize pgbouncer by editing the postgrescluster definition and adding something like the following:

spec:
  proxy:
    pgBouncer:
      config:
        global:
          pool_mode: transaction
          max_client_connection: 200

alrooney avatar Mar 22 '22 21:03 alrooney

Hello, just to double-check, I tried out the suggestion, which does work. (Though max_client_connection => max_client_conn I think.)

Please reopen if this is still an issue.

benjaminjb avatar Oct 13 '22 19:10 benjaminjb