Self-hosted Supabase backups and PITR: verify and run a restore drill
Context: Backup and point-in-time-recovery posture for the self-hosted Supabase Postgres is not visible from the app repo. This is a priority before marketing traffic.
Scope:
- Confirm automated Postgres backups exist (frequency, retention, offsite copy).
- Confirm WAL archiving / PITR is configured.
- Document and rehearse a full restore into a scratch environment.
- Include Garage S3 bucket backup or replication for uploaded media.
Done when: a restore drill succeeds and the runbook is written.