certification prep · cohort
PostgreSQL Administration Primer
5 weeks · 6 hrs/week
For developers inheriting “small” Postgres instances. You will practice user privileges, pg_stat_activity triage, and upgrade checklists on disposable VMs.
What ships in this outline
- Role modeling lab with least privilege
- Connection pool sizing worksheet
- Extension allowlist policy template
- Upgrade dry-run with rollback notes
- On-call friendly cheat sheet
Outcomes
- Produce a privilege matrix for a three-tier app
- Complete a minor version upgrade in lab with timing notes
- List pool misconfigurations you should test for
Lead mentor
Priya Nishimura
Operations coordinator; ex DBA for a healthcare integrator.
FAQ
No. Labs are isolated; you translate checklists home.
Helpful for PostgreSQL foundation exams; we are not an official prep provider.
High availability with Patroni/etcd is overview-only.
Experience notes
“Pool sizing worksheet ended our mystery 503s. Upgrade lab timing matched our maintenance window estimates.”
“Wish there was one more HA lecture, but primer delivered what it promised.”