Backup Fundamentals
PostgreSQL Continuous Protection Clinic
Align WAL shipping, PITR targets, and replica promotion drills for teams that cannot afford ambiguous recovery points.
470,000 KRW · 20 hours · Live online clinic
Program description
DBAs and infra engineers pair on WAL retention math, checksum verification, and controlled promotion drills with rollback paths. The course highlights honest trade-offs when storage budgets tighten.
What is included
- WAL retention calculator with storage forecasts
- Promotion drill script with rollback branch
- Checksum verification cadence for large clusters
- Monitoring queries for replication lag spikes
- Documentation pack for handoffs between shifts
- Risk note template for schema migrations
- Pairing guide for infra and DBA review sessions
Outcomes you can evidence
- Complete a promotion drill with a documented rollback path.
- Set WAL retention numbers finance acknowledges on paper.
- Ship a shift handoff doc that names last known good checkpoints.
Mentor
Hana Sato
Lead backup instructor with deep experience in database continuity clinics.
FAQ
MySQL instead?
Concepts translate, but labs are PostgreSQL-specific.
Managed cloud databases?
We note provider controls, yet exercises assume self-managed clusters.
Not covered?
Logical corruption inside tables requires DBA tooling beyond this clinic.
Participant notes
Promotion drill script is blunt in a good way. ★★★★★