Data / Instructor-led studio
PostgreSQL Administration Intensive
Backups, replication basics, roles, and vacuum tuning for teams inheriting busy databases.
Overview
Built for practitioners who already write SQL but must own uptime. You practice failover storytelling, pg_stat_statements interpretation, and maintenance windows that fit Vietnam evening traffic patterns.
What is included
- Hands-on replication lab with delayed replicas
- Role design workshop with least-privilege templates
- Backup drill script you can adapt to your employer
- Incident communication checklist used in Flux Blaze labs
- Monitoring hooks compatible with open metrics stacks
- Two fire-drill scenarios with mentor debriefs
- Written runbook template with version history guidance
Outcomes you can show
- Deliver a three-page runbook covering backup verification and restore drill results.
- Demonstrate a rollback path for a failed migration script.
- Facilitate a fifteen-minute incident recap using the cohort checklist.
Experience notes
“Delayed replica exercise mirrored what we run in Ho Chi Minh—Duy’s debrief on checkpoint spikes saved me a pager night.”
“Runbook template alone justified the time; I translated it into Vietnamese for our internal wiki the following week.”
FAQ
Can I use my employer’s cluster?
You may, provided you have written permission. Most learners use the Flux Blaze sandbox to avoid policy conflicts.
Is Windows supported?
Labs assume SSH access; Windows with WSL2 works. Pure GUI-only setups may struggle with replication exercises.
Limitations?
We do not provide on-call coverage for your workplace systems; this is education, not managed services.