Learning path
DBA Path
Own the cluster: maintenance, replication, backup/recovery, security and capacity.
DBA · Advanced · 5 courses · 19 simulations
The path
Courses, then incidents
Work through the courses, then practise the incidents — each step links to its page.
- Course MVCC and VACUUM →
- Course Autovacuum, Bloat and Freeze →
- Course Streaming Replication and Failover →
- Course WAL Archiving and Point-in-Time Recovery →
- Course pg_dump and pg_restore →
- vacuum-bloat Autovacuum starvation in a tenant database →
- vacuum-bloat Table bloat after update churn →
- vacuum-bloat Index bloat after churn →
- vacuum-bloat Long transaction prevents cleanup →
- vacuum-bloat Dead tuples growth →
- vacuum-bloat Vacuum cost-delay misconfiguration →
- vacuum-bloat Freeze age warning →
- vacuum-bloat XID wraparound emergency simulation →
- vacuum-bloat REINDEX needed →
- vacuum-bloat Unsafe VACUUM FULL capstone →
- storage-backup Disk full from temp files →
- storage-backup pg_wal disk pressure →
- storage-backup Archive directory backlog →
- storage-backup Backup target full →
- storage-backup Base backup missing WAL →
- security-access pg_hba blocks the application →
- security-access Overprivileged application role →
- security-access Missing CONNECT privilege on the target database →
- security-access User has access to the wrong database →