Repository Public
1#!/bin/bash2# Restores a Music SP backup.3# scripts/restore.sh db <backup.dump.enc> <postgres URL of an EMPTY target database>4# scripts/restore.sh library <backup dir>/library <target STORAGE_ROOT>5# After both: start the app; renditions and thumbnails missing on disk are rebuilt with6# tsx scripts/rebuild-derived.ts7set -euo pipefail8cd "$(dirname "$0")/.."9if [ -f .env ]; then10 while IFS='=' read -r k v; do11 case "$k" in BACKUP_PASSPHRASE_FILE) v="${v%\"}"; v="${v#\"}"; [ -n "${!k:-}" ] || export "$k=$v" ;; esac12 done < .env13fi14export PATH="/opt/homebrew/opt/postgresql@17/bin:/opt/homebrew/bin:$PATH"15case "${1:-}" in16 db)17 file="${2:?backup file}"; target="${3:?target database URL}"18 : "${BACKUP_PASSPHRASE_FILE:?BACKUP_PASSPHRASE_FILE missing}"19 openssl enc -d -aes-256-cbc -pbkdf2 -iter 200000 -pass "file:$BACKUP_PASSPHRASE_FILE" -in "$file" | pg_restore --no-owner --no-privileges --exit-on-error -d "$target"20 echo "database restored from $file" ;;21 library)22 src="${2:?library backup directory}"; dest="${3:?target STORAGE_ROOT}"23 mkdir -p "$dest"; chmod 700 "$dest"24 rsync -a "$src/" "$dest/"25 echo "library restored into $dest" ;;26 *) sed -n 2,6p "$0"; exit 2 ;;27esac28