Skip to content

v5.2.0

Choose a tag to compare

View all tags
@keithf4 keithf4 released this 27 Mar 19:41
· 9 commits to v5-STABLE since this release
v5.2.0
714a65a
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

v5.2.0

Release Summary

Crunchy Data is pleased to announce the availability of pgMonitor 5.2.0. This release brings support for the latest pgmonitor extension version 2.1.0 and many bug fixes.

Major Changes

  • sql_exporter - Updated metric queries for pgmonitor-extension 2.1.0

Minor Changes

  • grafana - Improve Query Statistics dashboard to more accurately report lifetime vs time range statistics
  • grafana - Removed the Last Backup Size (Total) panel from the pgBackRest Grafana dashboard since it was backed by the removed metric.
  • postgres_exporter - Removed the metric ccp_backrest_last_info_repo_total_size_bytes.
  • prometheus - Added new alerts to monitor the new metrics for the minimum required version of the pgmonitor extension
  • sql_exporter - Add additional metrics for monitoring replication slot status. For PG16+ monitor for conflicts. For PG17+, monitor synced and failover status.
  • sql_exporter - Add scrape_error_drop_interval setting to the configuration example
  • sql_exporter - Added new metrics to monitor pgmonitor-extension version. - ccp_pgmonitor_extension_global_version - shows the currently installed version of the extension on the global database as an integer - ccp_pgmonitor_extension_per_db_version - shows the currently installed version of the extension on each monitored user database as an integer - ccp_pgmonitor_extension_global_min_version_installed - shows whether the currently installed version of the extension is the minimum required for this version of pgMonitor on the global database (0 true, 1 false) - ccp_pgmonitor_extension_per_db_min_version_installed - shows whether the currently installed version of the extension is the minimum required for this version of pgMonitor on each monitored user database (0 true, 1 false)
  • sql_exporter - Removed the metric ccp_backrest_last_info_repo_total_size_bytes. When block incremental backups are enabled, this metric is no longer available from pgBackRest.

Bugfixes

  • grafana - Fix Cache Hit Ratio panel on PG Details dashboard to always be lines. Depending on data returned was sometimes being shown as points.
  • grafana - Fix pgBackRest recovery window panel showing multiple values after a PostgreSQL switchover
  • postgres_exporter - Disable all collectors included with postgres_exporter by default in example configuration. The other options to disable default metrics are not applied to the new collections.
  • postgres_exporter - Fix the ccp_table_size_size_bytes metric to remove the duplicate word and just be ccp_table_size_bytes
  • sql_exporter - Fix the ccp_table_size_size_bytes metric to remove the duplicate word and just be ccp_table_size_bytes
  • sql_exporter - Fix the names of ccp_pgbouncer_database_db_conn_perc_used, ccp_pgbouncer_database_paused, ccp_pgbouncer_database_disabled, and ccp_pgbouncer_list_item_count to be consistent with the old metric names from postgres exporter. These new names are the ones expected in the Grafana dashboard so this change fixes that to work properly again.
  • sql_exporter - Removed extraneous double quote at the end of the pgbouncer fdw collector file
Assets 2
Loading