v1.4.0

Release Summary

Version 1.4.0 of pgbouncer_fdw is a bugfix release.

Bug Fixes

• Update to support column change in databases from reserve_pool to reserve_pool_size in pgBouncer 1.24
• Set proper data type for pool_size and reserve_pool_size in users

v1.4.0-RC3

Release candidate 3 for 1.4.0

v1.4.0-RC2

Version 1.4.0 Release Candidate 2

v1.4.0-RC1

1.4.0 Release Candidate 1

v1.3.0

Release Summary

Version 1.3.0 of pgbouncer_fdw is a new feature and bugfix release.

New Features

• Update to support pgBouncer 1.24
• Improved support for newer columns that don't exist in older versions of pgBouncer
• Add checks to ensure future compatibility works for all versions of 1.x but stops before 2.x

v1.2.0

Release Summary

Version 1.2.0 of pgbouncer_fdw is a new feature release.

New Features

• Add support for PgBouncer 1.23.
  • Adds replication column to clients, servers and sockets functions and views.
  • Adds server_lifetime column to databases functions and views.
  • Adds total_server_assignment_count and avg_server_assignment_count columns to stats functions and views.
  • Adds pool_size, max_user_connections and current_connections columns to users functions and views.

v1.1.0

Release Summary

Version 1.1.0 of pgbouncer_fdw is a new feature release

New Features

• Add support for PgBouncer 1.21. Adds prepared_statements column to clients, servers and sockets functions and views.

v1.0.1

Release Summary

Version 1.0.1 of pgbouncer_fdw is a bugfix release

Bugfixes

• Fix missing comma that caused missing column "pgbouncer_target_host" in "pgbouncer_servers" and "pgbouncer_dns_zones" views

v1.0.0

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.

Minor Changes

Bugfixes

v0.5

-- Update to support pgBouncer 1.18.0. Note that as of v0.5, this extension requires at least version 1.18.0 of pgBouncer. If you still need to support an older version, v0.4 works with pgBouncer 1.16 and v0.3 works with older versions of pgBouncer. There are no other changes in this version other than a compatibility update.

-- Several views are dropped and recreated as part of this update. Privileges should be preserved, but it is recommended to double-check them.