- Compatible with PostgreSQL 17
- PG17 restructured the pg_stat_bgwriter catalog information. This extension has been restructured around those changes:
- Changed the
ccp_stat_bgwriter
metric from a materialized view to a standard view - Removed columns from
ccp_stat_bgwriter
that are no longer part ofpg_catalog.pg_stat_bgwriter
- New metrics views created:
ccp_stat_checkpointer
andccp_stat_io_bgwriter
. These align with where the columns frompg_stat_bgwriter
were moved to. - For versions of PG older than 17, these new metrics still apply and simply pull that data from the original
pg_stat_bgwriter
catalog and present them in the new format. - All applications that made use of the old
ccp_stat_bgwriter
metric will need to be updated to use the new metrics. - Due to dropping old metrics and recreating new ones, permissions may need to be regranted to any monitoring roles that use these new views.
- Changed the
- The first three number version of pgBackRest (2.52.1) was not being handled properly. Fix handling of version number so that it now returns a padded integer similar to PostgreSQL's server_version_num.