Critical: Migrate mcd-tracker Postgres to CNPG shared cluster #189

Closed
opened 2026-03-27 00:48:31 +00:00 by forgejo_admin · 0 comments

Type

Bug

Lineage

standalone — discovered scope from #187 review. Same vulnerability as basketball-api.

Repo

forgejo_admin/pal-e-platform

What Broke

mcd-tracker Postgres is a standalone Deployment pod with local-path PVC, zero backups, zero replication — identical to the basketball-api vulnerability documented in #187. Same fix: migrate to CNPG shared cluster.

Repro Steps

  1. kubectl get pvc -n mcd-tracker — standalone postgres-data PVC
  2. kubectl get backups -n mcd-tracker — no resources found

Expected Behavior

mcd-tracker database on CNPG with daily Barman backups, WAL archiving, restore verification.

Environment

  • Namespace: mcd-tracker
  • DB: PostgreSQL 16 (Alpine), standalone Deployment

Acceptance Criteria

  • mcd-tracker database exists on CNPG shared cluster
  • Daily Barman backup covers mcd-tracker data
  • Old standalone postgres removed after verification
  • #187 — basketball-api migration (do first, pattern established)
  • project-mcd-tracker
### Type Bug ### Lineage standalone — discovered scope from #187 review. Same vulnerability as basketball-api. ### Repo `forgejo_admin/pal-e-platform` ### What Broke mcd-tracker Postgres is a standalone Deployment pod with local-path PVC, zero backups, zero replication — identical to the basketball-api vulnerability documented in #187. Same fix: migrate to CNPG shared cluster. ### Repro Steps 1. `kubectl get pvc -n mcd-tracker` — standalone postgres-data PVC 2. `kubectl get backups -n mcd-tracker` — no resources found ### Expected Behavior mcd-tracker database on CNPG with daily Barman backups, WAL archiving, restore verification. ### Environment - Namespace: mcd-tracker - DB: PostgreSQL 16 (Alpine), standalone Deployment ### Acceptance Criteria - [ ] mcd-tracker database exists on CNPG shared cluster - [ ] Daily Barman backup covers mcd-tracker data - [ ] Old standalone postgres removed after verification ### Related - `#187` — basketball-api migration (do first, pattern established) - `project-mcd-tracker`
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
forgejo_admin/pal-e-platform#189
No description provided.