8182ad75b9
Fix activity query
...
* Modify the activity query to ensure each state is always reported.
* Fix the activity preprocessor to unwrap the value from the array
containing it.
2025-10-18 12:49:09 -04:00
175fd85f9f
Remove Debian 10
...
* The Debain 10 Docker image may have been removed. Remove it from the
list of supported distros until a source can be found.
2025-10-18 02:47:50 -04:00
e9c97d65cb
Fix OEL7 and AL2 targets
2025-10-18 02:42:02 -04:00
af5d9cf186
Add Amazon Linux 2 support, prepare for PG18
...
* Add Amazon Linux 2 as a supported OS.
* Dynamically select the package manager for Amazon and Oracle Linux.
* Prepare for supporting PostgreSQL 18. Specifically, the Docker image
seems to have moved the data directory, so get that dynamically.
2025-10-18 02:11:08 -04:00
17c15e7e48
Add support for Amazon Linux 2023, bump version to 1.1.0-rc1
...
* Add support for packaging for Amazon Linux 2023
* Bump version to 1.1.0-rc1
* Tidy up the Makefile a bit
2025-10-18 01:00:30 -04:00
f55bcdcfae
Merge branch 'dev/locks' into develop
2025-10-17 01:35:43 -04:00
e7b97a9e88
Add items to template
...
* Add items to the Zabbix template for:
- Backgroubd writer / checkpoint stats
- Lock stats
- Connection states
2025-10-17 01:24:33 -04:00
3ade30c04a
Add script to shot tempalte coverage
...
* Add a script to compare the defined metrics with those used in the
Zabbix template.
* Add a Makefile target to run the above script.
2025-10-09 02:21:17 -04:00
ab039dc412
Improve test coverage
...
* Refactor some functions to improve unit test coverage.
* Use the "coverage" module if available along with unit tests.
2025-10-08 23:53:45 -04:00
75c5d76047
Add a metric for tracking the number of granted locks
2025-09-23 01:14:50 -04:00
43cd162313
Refactor to make pylint happy
2025-09-23 01:12:49 -04:00
29bfd07dad
Run code through black
2025-07-14 01:58:08 -04:00
60589c2058
Update undiscovered item behavior
2025-07-14 01:39:57 -04:00
ea3aca3455
Filter out initial logical replication sync workers
...
* Slots are crated for each table during the initial sync, which only
live for the duration of the copy for that table.
* The initial sync backend workers' names are also based on the table
being copied.
* Filter out the above in Zabbix discovery based on application_name and
slot_name.
2025-07-07 13:15:03 -04:00
cc71547f5f
Include application_name in replication discovery data
2025-07-07 13:07:11 -04:00
107d5056d6
Merge branch 'main' into develop
2025-07-06 03:37:37 -04:00
e930178e9c
Merge branch 'rel/1.0.4'
2025-07-06 03:35:39 -04:00
5afc940df8
Bump release version to 1.0.4
2025-07-06 03:35:00 -04:00
3961aa3448
Add Gentoo ebuild for 1.0.4-rc1
2025-07-06 03:32:27 -04:00
8fd57032e7
Update Makefile to support rc versions, bump version
...
* Support packaging RC versions for deb and rpm packages
* Bump version to 1.0.4-rc1
2025-07-06 03:28:36 -04:00
5ede7dea07
Fix package-all make target
...
* Fix the package-all target in the Makefile
* Remove storage of raw sequence stats
2025-07-05 12:28:36 -04:00
5ea007c3f6
Merge branch 'dev/sequences' into develop
2025-07-05 01:18:01 -04:00
7cb0f7ad40
Fix typo in activity query
2025-07-05 01:17:35 -04:00
83fa12ec54
Correct types for slot LSN lag metrics
2025-07-04 02:46:25 -04:00
98b74d9aed
Add sequence metrics to Zabbix template
2025-07-04 02:45:43 -04:00
45953848e2
Remove some type casts from working around Decimal types
2025-07-03 10:16:20 -04:00
6116f4f885
Fix missing json default
2025-07-03 02:08:45 -04:00
24d1214855
Teach json how to serialize decimals
2025-07-03 01:47:06 -04:00
3c39d8aa97
Remove CIDR prefix from replication id
2025-07-03 01:13:58 -04:00
ebb084aa9d
Add initial query for sequence usage
2025-07-01 02:29:56 -04:00
86d5e8917b
Merge branch 'dev/io_stats' into develop
2025-07-01 01:30:21 -04:00
be84e2b89a
Report some I/O metrics in bytes
2025-06-30 02:00:06 -04:00
fd0a9e1230
Add backend I/O discoovery items to template
2025-06-29 02:08:19 -04:00
b934a30124
Add pg_stat_io query
...
* Add a query for pg_stat_io metrics grouped by backend type
* Switch some unsupported values from 0 to NULL to better reflect their
nonexistence
2025-06-28 00:30:03 -04:00
ea397ef889
Improve docker-related query test failure avoidance
2025-06-18 17:39:16 -04:00
def6bab7f4
Add a pause after deploying test db containers as a temporary kludge
2025-06-18 03:30:27 -04:00
ecb616f6d9
Allow retry in query tests
2025-06-18 03:23:43 -04:00
b7f731c6ac
Fix and reformat several queries
2025-06-18 03:03:34 -04:00
4fba81dc2c
Add initial bgwriter and activity metrics queries
2025-06-17 02:40:52 -04:00
9225e745b0
Handle division by zero possibility
...
* When no I/O activity has been reported in pg_statio_all_tables for a
database, the queries resulted in a division by zero. Cange this to a
NULL instead. Still a problem for Zabbix, but maybe a little cleaner.
2025-06-17 01:16:57 -04:00
b981a9ad36
Add slot lag metrics
2025-06-16 00:56:14 -04:00
c0185d4b86
Remove extra quotes in replication slot query
2025-06-15 02:20:45 -04:00
d34dfc5bf7
Fix replication monitoring queries
2025-06-15 02:19:10 -04:00
7c395a80fe
Add metrics for tracking cache hit ratios
2025-06-13 01:16:24 -04:00
8fe81e3ab3
Fix global variable placement
2025-06-04 12:49:35 -04:00
cfe01eb63e
Fix typo in latest version Zabbix item
2025-06-04 01:44:25 -04:00
55b9b16deb
Install to /usr/bin
...
* Standardize all install methods to use /usr/bin rather than some of
them using /usr/local/bin
* Make the init script executable in install-openrc
2025-06-04 01:16:59 -04:00
6a22597f1f
Fix ID age query and template
2025-06-04 00:47:51 -04:00
295d1d6310
Fix typo in install-openrc
2025-06-03 19:38:59 -04:00
8b804f3912
Add requests as a dependency, split install target
...
* Add requests as a dependency on all OSs
* Split the install target into a common target and separate
install-systemd and install-openrc targets to support installing on
Alpine
2025-06-03 19:34:58 -04:00
