📄️ WAL Basics
Understand PostgreSQL Write-Ahead Logging (WAL), why it enables crash recovery and replication, and how it relates to PITR.
📄️ pg_dump Utility
Create logical PostgreSQL backups with pg_dump, choose formats, restore with pg_restore, and back up globals safely.
📄️ Point-in-Time Recovery (PITR)
Plan PostgreSQL PITR using base backups and WAL archiving, define recovery targets, and build a restore-tested runbook.
📄️ Replication Basics
Understand PostgreSQL replication modes (streaming, logical), replication slots, and how replication differs from backups.