[Phase 3.4] PostgreSQL Backup, RPO/RTO & Disaster Recovery Verification Plan #1

Open
opened 2026-11-17 04:28:06 +00:00 by john4064 · 0 comments
Owner

Goal

Define and automate RPO/RTO targets, PostgreSQL backup retention, offsite NAS storage, and repeatable restore verification specific to Chaotic accounts, ScannedCreatureInstance records, and match logs.

Metadata

  • Phase / Step: Phase 3.4
  • Depends On: #12
  • Unlocks: Production homelab persistence readiness
  • Target Crates / Paths: deploy/sql/, scripts/, backup documentation
  • Line Budget Plan: Shell/Python verification scripts <= 400 lines

Acceptance Criteria

  • Document explicit RPO (e.g., <= 24h daily / pre-migration snapshot) and RTO targets for Chaotic PostgreSQL state.
  • Define encrypted pg_dump retention schedule and NAS target storage path.
  • Add repeatable restore-verification script loading a backup into an ephemeral postgres:16-alpine container and asserting ScannedCreatureInstance & deck integrity.
## Goal Define and automate RPO/RTO targets, PostgreSQL backup retention, offsite NAS storage, and repeatable restore verification specific to Chaotic accounts, `ScannedCreatureInstance` records, and match logs. ## Metadata - **Phase / Step:** Phase 3.4 - **Depends On:** #12 - **Unlocks:** Production homelab persistence readiness - **Target Crates / Paths:** `deploy/sql/`, `scripts/`, backup documentation - **Line Budget Plan:** Shell/Python verification scripts <= 400 lines ## Acceptance Criteria - [ ] Document explicit RPO (e.g., `<= 24h` daily / pre-migration snapshot) and RTO targets for Chaotic PostgreSQL state. - [ ] Define encrypted `pg_dump` retention schedule and NAS target storage path. - [ ] Add repeatable restore-verification script loading a backup into an ephemeral `postgres:16-alpine` container and asserting `ScannedCreatureInstance` & deck integrity.
john4064 changed title from [Infra] Define PostgreSQL & State Backup Plan for Chaotic to [Phase 3.4] PostgreSQL Backup, RPO/RTO & Disaster Recovery Verification Plan 2026-11-17 09:58:47 +00:00
Sign in to join this conversation.
No description provided.