Release Summary
Version 1.0.0 of pgbouncer_fdw includes support for targetting multiple PgBouncers as well as support for multiple versions of PgBouncer
IMPORTANT NOTE: All objects in this extension are dropped and recreated as part of this update. Privileges ARE NOT preserved as part of this update, so please ensure privileges you have on these objects are preserved before upgrading so that they can be reapplied. Note that execution by PUBLIC on the admin functions is once again revoked by this update.
Major Changes
-
Add support for gathering statistics from multiple PgBouncer targets
- A new configuration table has been added to define the names of all FDW servers.
- All views have an additional column to identify the PgBouncer target
- All administrative command functions have had a parameter for the FDW server name added to them. These functions intentionally do not use the configuration table to avoid accidentally running an admin command on multiple servers.
-
Add better support for multiple versions of PgBouncer. Support for 1.17 has been backported into this version of pgbouncer_fdw.