EnterpriseDB
💡 [REQUEST] - Allow for settable ignore_startup_parameters for pgbouncer
Summary
To allow for scenarios where pgbouncer needs overrides to startup parameters, pgbouncer.ini.j2 would be beneficial to allow the following setting:
Instead of ignore_startup_parameters = extra_float_digits
ignore_startup_parameters = {{ pgbouncer_ignore_startup_parameters | default('extra_float_digits') }}
Other than that, allow ;%include /etc/pgbouncer/pgbouncer-other.ini to be un-remarked and then we can place salient overrides in this file instead
Use case
This would allow scenarios such as allowing for `pooler error: unsupported startup parameter: search_path' without changing the JDBC connection strings (in this case)
Drawbacks
Potentially allows dangerous overrides to pgbouncer settings
Unresolved questions
No response
The request has been taken into account, we have created a ticket on our internal board and will keep you updated once this will be selected for an upcoming release.
