v2.1.1

What's Changed

• feature: seed and validate testing harness (#30) by @randoneering

CI/CD

• Feat/enhance ci (#31) by @randoneering

Full Changelog: v2.1.0...v2.1.1

v2.1.0

v2.1.0 — Info and System-Level Checks

This release adds ten new health checks focused on server configuration and system state,
giving you a clearer picture of how PostgreSQL is tuned and what it's doing.

New checks

Memory configuration

• shared_buffers Setting — reports the current value
• shared_buffers At Default — flags when the value is still at PostgreSQL's 128 MB default
• work_mem Setting — reports the current value
• work_mem At Default — flags when the value is still at PostgreSQL's 4 MB default
• effective_cache_size Setting — reports the current value
• maintenance_work_mem Setting — reports the current value

System state

• Transaction ID Wraparound Risk — reports XID age and remaining headroom per database
• Checkpoint Stats — shows timed vs. forced checkpoint counts and the forced ratio; works on
  PG 15/16 (pg_stat_bgwriter) and PG 17+ (pg_stat_checkpointer)
• Server Role — reports whether the instance is a primary or standby
• Connection Utilization — shows current connection usage against max_connections

Test coverage

• Seven new integration tests covering view/function parity, standalone view installation,
  wraparound value formatting, checkpoint guidance by server version, and a regression check
  that keeps the _pg_firstaid_checkpoint_stats helper identical across all three install
  scripts
• pgTAP tests added for all new checks
• Integration test suite now skips cleanly with a clear message when PostgreSQL environment
  variables are missing

Other changes

• Partial indexes are no longer flagged as duplicates in the managed view
• Managed-database testing documentation updated to reflect that AWS validation is active;
  Azure and GCP support is best-effort until those test environments can be funded

v2.0.0

Added

• Added a new set of query-focused health checks to pgFirstAid.
• Added matching query health checks to view_pgFirstAid.sql and view_pgFirstAid_managed.sql.
• Added pgTAP coverage for the new health checks.
• Added managed database validation workflow support.
• Added cross-cloud testing support for PostgreSQL 15-18 across AWS, Azure, and GCP.

Changed

• Updated GitHub Actions workflows for broader automated testing coverage.
• Updated OpenTofu deployment definitions used by the test matrix.
• Updated integration test and deployment workflow behavior for managed database validation.
• Refreshed README.md, workflow docs, and contribution guidance to match the new testing setup.

Fixed

• Fixed workflow variable mismatches that caused failing runs.
• Fixed missing engine version handling in AWS workflow configuration.
• Removed or trimmed overly broad Tofu workflow behavior after follow-up cleanup.

v1.4.1

What's Changed

• adding DO sponsorship by @randoneering in #22
• Feature/sponsors update by @randoneering in #23
• Feature/testing suite by @randoneering in #24
• pgTAP bug fix and created GH Action to test with PRs by @randoneering in #25

Full Changelog: v1.4.0...v1.4.1

v1.4.0

New Features:

• Low priority health checks - Including checks for idle connections over an hour and additional monitoring queries
• Managed service view - Dedicated view for managed PostgreSQL platforms (RDS, Cloud SQL, Azure)
• CONTRIBUTING.md - Contribution guidelines for the project

Stats:
10 commits
15 files changed
+1,874 / -102 lines