spb/toveli

1#!/bin/zsh2# Sauvegarde chiffrée de la base PostgreSQL Toveli (compte applicatif, lecture) → data/backups/toveli-YYYYmmdd-HHMM.sql.gz.age3# Restauration testée : age -d -i key.txt fichier.age | gunzip | psql $DATABASE_URL4set -euo pipefail5cd "$(dirname "$0")/.."6export PATH=/opt/homebrew/opt/postgresql@17/bin:/opt/homebrew/bin:$PATH7: "${DATABASE_URL:?DATABASE_URL requise}"8mkdir -p data/backups9out="data/backups/toveli-$(date +%Y%m%d-%H%M).sql.gz"10pg_dump --no-owner --no-privileges "$DATABASE_URL" | gzip -9 > "$out"11if [[ -n "${BACKUP_AGE_RECIPIENT:-}" ]] && command -v age >/dev/null; then age -r "$BACKUP_AGE_RECIPIENT" -o "$out.age" "$out" && rm -f "$out"; out="$out.age"; fi12ls -t data/backups/toveli-* | tail -n +15 | xargs -r rm -f13echo "sauvegarde OK : $out ($(du -h "$out" | cut -f1))"14