What backup types exist and how does point-in-time recovery work?

Answer preview

A backup strategy is defined by two numbers: RPO (how much data you can afford to lose) and RTO (how long you can be down). Backups alone only give you the last snapshot — combining a physical base backup with continuous WAL archiving is what lets you recover to any second before…