Consistent Database Backups with btrfs Snapshots + Backrest Hooks

This page did not load. You can still read it on the original site — the toolbar below keeps your place in the directory.

When you back up a directory with restic or Backrest, and that directory contains live databases like PostgreSQL or SQLite, copying the data files directly can leave you with a backup that won’t start — or worse, one that starts silently with corrupt data. This article shows how to freeze the whole data directory into a consistent state with a btrfs subvolume snapshot, and have Backrest…

Read on nite07.com ↗