check_pgactivity 2.7

2023-09-25 - Version 2.7:

Changelog:

• add: compatibility with PostgreSQL 15 and 16, Jehan-Guillaume de Rorthais, Thomas Reiss
• change: stat_snapshot_age is compatible from PostgreSQL v9.5 to v14, Benoit Lobréau
• change: simplify session accounting in backends_status, Thomas Reiss
• fix: compatibility of backup_label_age with PostgreSQL 15 and after, Thomas Reiss
• fix: in pg_dump_backup, error explicitly if --path is a directory, Christophe Courtois
• fix: temp_files on PG10 was counting all DB files, Christophe Courtois, Benoit Lobréau
• fix: make check_archiver output oldest_ready_wal=0 when archive queue is empty, Thomas Reiss
• fix: make check_archiver work properly with PostgreSQL 10 without being superuser, Thomas Reiss
• fix: in backends_status, avoid "idle in transaction" false positive for PostgreSQL 9.2 and after, Thomas Reiss
• fix: issue with check_pgactivity missing lock file, Joern Ott, Julien Rouhaud, Jehan-Guillaume de Rorthais
• fix: in btree_bloat, adjust index tuple header size, Shangzi Xie, Jehan-Guillaume de Rorthais

Many thanks to all contributors of this release for feedbacks, bug reports, patches and patch reviews, etc

check_pgactivity 2.6

2022-07-08 - Version 2.6

Changelog:

• add: new session_stats service to gather miscellaneous session statistics, Frédéric Yhuel
• add: compatibility with PostgreSQL 14, Frédéric Yhuel
• change: service autovacuum does not show max_workers anymore for 8.2 and below, Jehan-Guillaume de Rorthais
• change: various messages and code cleanup, Julian Vanden Broeck, Jehan-Guillaume de Rorthais
• fix: last_vacuum and last_analyse to reports the correct oldest maintenance, Frédéric Yhuel, Jehan-Guillaume de Rorthais
• fix: service check_oldest_idlexact now use state_change instead of xact_start to calculate the idle time, Thomas Reiss
• fix: improve locking around the status file to avoid dead locks and status file truncation, Arnaud Aujou, Julien Rouhaud, Jehan-Guillaume de Rorthais
• fix: possible division by 0 in table_bloat service, Pavel Golub
• fix: threshold check and support interval for service check_stat_snapshot_age, Jehan-Guillaume de Rorthais
• fix: service check_archiver when a .history or .backup file is staled, Thomas Reiss
• fix: service sequences_exhausted now checks also sequences that are not owned by a table column, Thomas Reiss
• fix: service check_archiver when no WAL was ever archived, Thomas Reiss

Many thanks to all contributors of this release for feedbacks, bug reports, patches and patch reviews, etc.

check_pgactivity 2.5

2020-11-24 - Version 2.5

Changelog:

• add: new oldest_xmin service
• add: new extensions_versions service
• add: new checksum_errors service
• add: support for v13 and other improvements on replication_slots
• add: v13 compatibility for service wal_files
• add: various documentation details and examples
• add: support service replication_slots on standby
• add: accept single b or o as size unit
• add: json and json_strict output formats
• add: size and/or delta thresholds for database_size service
• add: thresholds are now optional for service database_size
• add: support for v12 and v13 archive_folder
• regression: threshold repslot becomes spilled in service replication_slots
• regression: in services latest_vacuum and latest_analyze: a critical alert is now raised on tables that were never analyzed/vacuumed or whose maintenance date was lost due to a crash
• fix: avoid alerts for lack of maintenance on inactive db
• fix: forbid rare cases of division by zero in wal_files
• fix: do not alert on missing file in temp_files for v10+
• fix: detect lack of maintenance in last_vacuum and last_analyze for never maintained tables
• fix: backend count for v10+
• fix: replace NaN with "U" for strict outputs
• fix: do not count walsenders as part of max_connections
• fix: broken archiver service with v10+
• fix: perl warning when archiver is not active

check_pgactivity 2.4

2019-01-30 - v2.4

Changelog:

• add a new uptime service
• add ability to filter by application_name in longest_query and oldest_idlexact service
• add minimal delta size to pgdump_backup service to avoid alert when backup grows small in size
• allow psql connections without providing connection arguments:
  rely on the binary default behaviour and environment variables
• returns CRITICAL if connection fails for service connection, instead of UNKNOWN
• add information on necessary privileges for all services
• replication_slots service handle wal files and pg_replslots files separately
• take account of the new BRIN summarize state of autovacuum
• avoid warning for -dev versions in pga_version service
• ignore startup and backup replication states in service streaming_delta
• many fixes

check_pgactivity 2.3

2017-11-13 - Version 2.3

Changelog :

• add complete support for PostgreSQL 10, including non-privileged monitoring features
• add some documentation to help new contributors
• add ability to use time units for thresholds in service backend_status
• fix a long-standing bug in service backends_status
• fix several issues

check_pgactivity 2.3_beta1

2017-09-20 - Version 2.3 beta1

Changelog :

• add complete support for PostgreSQL 10, including non-privileged monitoring features
• add some documentation to help new contributors
• add ability to use time units for thresholds in service backend_status
• fix a long-standing bug in service backends_status
• fix sequences_exhausted to work with sequences attached to unusual types
• fix fetching method for service minor_version

check_pgactivity 2.2

• add support for PostgreSQL 9.6
• improve and rename "ready_archives" to "archiver"
• add service sequences_exhausted to monitor sequence usage
• add service stat_snapshot_age to detect a stuck stats collector process
• add service wal_receiver to monitor replication on standby's end
• add service pgdata_permission to monitor rights and ownership of the PGDATA
• add support for "pending restart" parameters from PostgreSQL 9.5+ in check_settings
• add timeline id in perfdata output from wal_files
• fix wal_files, archiver, check_is_replay_paused, check_hot_standby_delta, check_streaming_delta and check_replication_slots for PostgreSQL 10
• fix archive_folder to handle compressed archived WAL properly
• fix backends_status for PostgreSQL 9.6
• warn when no rows are returned in custom_query service
• make thresholds optional in service hot_standby_delta
• make thresholds optional in service streaming_delta
• remove useless thresholds in backends/maximum_connections perfdata
• add warn/crit threshold to steaming_delta perfdatas
• use parameter server_version_num to detect PostgreSQL version
• fix a race condition in is_storable to handle concurrent executions
  correctly
• fix a bug in service locks that occurs with PostgreSQL 8.2
• fix rounding in hit_ratio
• fix perl warning when some ENV variables are not defined
• fix bug in "human" output format
• fix version check for all hosts for service hot_standby_delta
• fix bug in pg_dump_backups related to age of global files
• fix documentation about default db connection

check_pgactivity 2.2_rc2

This is the second release candidate for check_pgactivity 2.2.

This release fixes a bug left in service wal_files as timeline ids were not taken as hexadecimal values.

check_pgactivity 2.2_rc1

This is the first release candidate for check_pgactivity 2.2.

See CHANGELOG.md for more informations.

check_pgactivity 2.0

2016-08-29 2.0:

• support various output format
• add output format "nagios_strict"
• add output format "debug"
• add output format "binary"
• add output format "human"
• force UTF8 encoding
• do not connect ot the cluster if using --dbinclude for service pg_dump_backup
• add argument --dump-status-file, useful for debugging
• add service "table_unlogged"
• add basic support to timeline cross in service archive_folder
• add service "settings"
• add service "invalid_indexes"
• fix a bug where pod2usage couldn't find the original script
• fix wal size computation for 9.3+ (255 -vs- 256 seg of 16MB)
• fix perl warning with pg_dump_backup related to unknown database
• fix buffers_backend unit in check_bgwriter