Backup strategy
VM backups with Proxmox Backup Server, and PostgreSQL backups with pgBackRest to S3-compatible object storage.
Context
There were no central backups: they were ad hoc or per-server.
What I did
- VM backups with Proxmox Backup Server. Nightly backup jobs, prune rules for retention, verify jobs to check backup integrity, and sync jobs to copy backups offsite.
- PostgreSQL backups with pgBackRest to S3-compatible object storage. Periodic full backups with incrementals in between, continuous WAL archiving, and a retention policy on full backups.
- Restore tests. Run ad hoc, such as after changes to the setup.
Outcome
- Every VM and database is now backed up centrally, verified, and copied offsite.