scarver2 / ehr-portal / 23344020560

77%

push

github

feat: PGHero database monitoring and PostgreSQL 18 upgrades (#22)

* feat: add PGHero database monitoring tool to ActiveAdmin

- Add pghero gem (~> 3.7) to Gemfile
- Mount PGHero engine at /pghero with admin role authentication
- Add PGHero link to ActiveAdmin Tools menu alongside Sidekiq and Honeybadger
- Provides visual database performance insights and query analysis
- Accessible only to authenticated admin users

Co-Authored-By: Claude Haiku 4.5 <noreply@anthropic.com>

* upgraded nokogiri 1.19.2 (x86_64-darwin) (was 1.19.1)

* feat: enable PostgreSQL query statistics for PGHero

- Add pg_stat_statements shared library to PostgreSQL configuration
- Set pg_stat_statements.track to 'all' to capture all query statistics
- Enable in both development (compose.yml) and production (Kamal deploy.api.yml)
- Allows PGHero to analyze and display query performance insights

Co-Authored-By: Claude Haiku 4.5 <noreply@anthropic.com>

* chore: update PostgreSQL to version 18 in compose.yml and CI workflow

Align local development and CI environments with production PostgreSQL 18.
Previously used 17 in both places while production already runs 18.

compose.yml already includes pg_stat_statements query tracking for PGHero.

Co-Authored-By: Claude Haiku 4.5 <noreply@anthropic.com>

* fix: update PostgreSQL volume mount for Docker 18+ compatibility

PostgreSQL 18+ Docker images use a different data directory structure
and expect the volume to be mounted at /var/lib/postgresql instead of
/var/lib/postgresql/data. This change allows pg_ctlcluster to manage
data in version-specific subdirectories.

Fixes container startup error when upgrading from PostgreSQL 17 to 18.

Co-Authored-By: Claude Haiku 4.5 <noreply@anthropic.com>

* fix: standardize PostgreSQL 18 volume mounts across all configurations

Update all Kamal and Docker configurations to use the correct PostgreSQL 18
volume mount path (/var/lib/postgresql instead of /var/lib/postgresql/data).

This prevents data d... (continued)

75 of 115 branches covered (65.22%)

Branch coverage included in aggregate %.

116 of 198 relevant lines covered (58.59%)

5.5 hits per line