v5.1.1-RC1

Release candidate 1 for version 5.1.1

v5.1.0

Release Summary

Crunchy Data is pleased to announce the availability of pgMonitor 5.1.0. This release brings support for PostgreSQL 17. It also brings more flexible Grafana dashboards, an HAProxy dashboard and better support for etcd and pgBackRest.

Major Changes

• grafana - add support for new metrics in PG17
• sql_exporter - add support for PG17

Minor Changes

• grafana - Add a new variable dropdown to all dashboards for the Datasource. Allows more flexiblity when importing the dashboard to different environments.
• grafana - Add panel to PG Details dashboard to track autovac workers running vs max
• grafana - add a dashboard for HAProxy
• sql_exporter - Add metrics to track current autovacuum workers running and max autovacuum workers
• sql_exporter - A password for the ccp_monitoring database role is no longer set when using the setup_db.sql file.
• sql_exporter - Make the default privileges for the setup_db.yml file world readable (when installing via package).

Bugfixes

• grafana - Fix etcd dashboard to use new metric names in etcd 3.5
• postgres_exporter - Fix query for pgBackRest monitoring to handle 3 number versions

v5.1.0-beta1

Beta1 release for version 5.1

v5.0.0

Release Summary

Crunchy Data is pleased to announce the availability of pgMonitor 5.0.0. This release brings support for a new Prometheus exporter for PostgreSQL - sql_exporter. It also supports a new monitoring extension to make metric collection easier and more performant. This changelog contains all changes that have been added since the 4.11.0 release.

Please see the 5.0.0 upgrade documentation for more information on converting to the new sql_exporter.

Major Changes

• grafana - Add new dashboards for sql_exporter support. New PostgreSQL Overview and PgBouncer direct metrics dashboards
• grafana - New Grafana minimum version is now 10.4. All dashboards have been updated to fix AngularJS deprecation warnings and re-exported from 10.4.
• grafana - Organize packages to allow better choice of available Grafana dashboards
• grafana - Remove top level general Overview dashboard
• pgmonitor-extension - Add more extensive support for materialized views and refreshed tables for expensive or custom metric queries
• pgmonitor-extension - Add support for using the PostgreSQL pgmonitor-extension to aid in metrics collection with sql_exporter
• postgres_exporter - Note that postgres_exporter is still supported but will be deprecated in a future version
• sql_exporter - Add support for directly connecting to PgBouncer to collect metrics
• sql_exporter - Add support for new PostgreSQL metrics collecting exporter (sql_exporter)

Minor Changes

• prometheus - Added OOMKiller Alert using node_exporter metrics

Bugfixes

• docs - add reference links to upstream configuration docs
• exporter - fix the pgbackrest-info.sh to force the necessary console output level that it expects
• grafana - fix some queries that were searching on the wrong label (datname vs. dbname)
• sql_exporter - add new metric for n_tup_newpage_upd
• sql_exporter - use the new views from pgmonitor-extension instead of full queries

v5.0.0-beta2

Beta 2 release for version 5.0.0

v5.0.0-beta1

Beta 1 release for version 5.0.0

v4.11.0

Release Summary

Crunchy Data is pleased to announce the availability of pgMonitor 4.11.0. This release primarily updates support for the underlying applications to more recent versions. This changelog contains all changes that have been added since the 4.10.0 release.

Minor Changes

• alertmanager - minimum version 0.23, maximum 0.26.x
• blackbox_exporter - minimum version 0.22.x, maximum 0.24.x
• grafana - minimum version 9.2.19, maximum 9.9.x
• node_exporter - minimum version 1.5.0, maximum 1.7.x
• postgres_exporter - minimum version 0.10.1, maximum 0.15.x
• prometheus - minimum version 2.38, maximum 2.49.x

v4.11.0-beta4

chore: revert new grafana alertmanager dashboard (#391)

v4.11.0-beta3

N/A

v4.11.0-beta2

N/A