SPB Git

Repository Public

restore.sh 1.2 KB 28 lines shellscript

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
Files main
Menu

Theme