If you work with PostgreSQL in production, backups are not optional.
In this lab, I built a complete PostgreSQL 18 backup and recovery environment on Ubuntu 24.04 and tested all three major backup approaches:
- logical backups with
pg_dump - physical backups with
pg_basebackup - production-grade backups with pgBackRest, including WAL archiving and Point-In-Time Recovery (PITR)
Everything was tested on a real VM with actual recovery drills — not simulations.
Continue reading “PostgreSQL 18 Backup & Recovery Lab on Ubuntu 24.04 — pg_dump, pg_basebackup and pgBackRest”