Ho Ngoc Hai 8cdfe17205 feat(ops): add automated backup restore verification ...

Adds pg-verify-backup.sh that restores the latest backup to an isolated
test database and verifies integrity (table existence, row counts, key
checksums, PostGIS extension, indexes, enum types). Reports pass/fail
with optional JSON output.

- Cron schedule: daily at 04:00 UTC (2h after backup)
- On-demand: docker compose run --rm pg-verify-backup
- CI: weekly GitHub Actions workflow with artifact upload

Co-Authored-By: Paperclip <noreply@paperclip.ing>

2026-04-10 23:19:43 +07:00

14 KiB

Executable File

Raw Permalink Blame History

View Raw