cd ..

Backup strategy

VM backups with Proxmox Backup Server, and PostgreSQL backups with pgBackRest to S3-compatible object storage.

Proxmox Backup ServerpgBackRestS3-compatible 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.