Files
autocraft/deploy/backup.sh

23 lines
1.1 KiB
Bash
Executable File

#!/bin/bash
# Consistent snapshot of the mirror database, safe while the services run.
# deploy/backup.sh [PREFIX [KEEP]] defaults: daily 7
# Writes $AUTOCRAFT_BACKUP_DIR/PREFIX-<UTC timestamp>.db.zst (gzip without zstd),
# then deletes all but the newest KEEP files of that prefix. The database is
# $AUTOCRAFT_DB; backups default to <database dir>/backups.
set -euo pipefail
prefix="${1:-daily}"
keep="${2:-7}"
db="${AUTOCRAFT_DB:-${CRAFT_AUTO_DB:-}}"
[ -n "$db" ] || { echo "AUTOCRAFT_DB is not set" >&2; exit 1; }
dir="${AUTOCRAFT_BACKUP_DIR:-$(dirname "$db")/backups}"
umask 077
mkdir -p "$dir"
tmp="$(mktemp -p "$dir" .snapshot.XXXXXX)"
trap 'rm -f "$tmp"' EXIT
sqlite3 "$db" ".timeout 60000" ".backup '$tmp'"
[ "$(sqlite3 "$tmp" 'PRAGMA quick_check')" = ok ] || { echo "snapshot failed the integrity check" >&2; exit 1; }
out="$dir/$prefix-$(date -u +%Y%m%dT%H%M%SZ).db"
if command -v zstd >/dev/null; then zstd -q -3 -T2 -o "$out.zst" "$tmp"; else gzip -1 <"$tmp" >"$out.gz"; fi
ls -1t "$dir/$prefix"-*.db.* 2>/dev/null | tail -n +$((keep + 1)) | xargs -r rm -f --
echo "snapshot: $(ls -1t "$dir/$prefix"-*.db.* | head -1)"