💡 [REQUEST] - Allow for settable ignore_startup_parameters for pgbouncer

[arnoldthebat]

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

[JonathanRenon-EDB]

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.