4 months ago
I have my variable set to PGBOUNCER_POOL_MODE:transaction but it is still operating as session is this a known issue?
2 Replies
4 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open brody • 4 months ago
4 months ago
Hi, I set PGBOUNCER_POOL_MODE=transaction for my PostgreSQL instance, but PgBouncer still seems to be using session mode. Can you check:
1. That the environment variable is applied to the running PgBouncer process.
2. That the config file isn’t overriding it.
3. If there are any restrictions in Railway’s setup that force session mode.
4 months ago
Thank you for the reply.
1. I checked the logs and it does not show that it is running in transaction mode.
2. I am unsure how to access the config file as it was deployed from a template.
3. I don't believe there is I looked at the docker image and it is mirroring bitnamis pgbouncer and their docs say to set that variable.