SPB Git

Repository Public

restore.sh 743 B 13 lines shellscript

1#!/bin/zsh2# Disaster recovery: restores a backup into an EMPTY database. Usage: scripts/restore.sh <db-....dump.enc> [database]3set -euo pipefail4export PATH="/opt/homebrew/bin:/opt/homebrew/opt/postgresql@17/bin:/usr/bin:/bin"5F="$1"; DB="${2:-sp_message}"6KEY="$HOME/.config/sp-message/backup.key"7n=$(psql -tAc "select count(*) from information_schema.tables where table_schema='public'" "$DB")8[ "$n" -eq 0 ] || { echo "Database $DB is not empty; refusing to restore over it."; exit 1; }9openssl enc -d -aes-256-cbc -pbkdf2 -iter 200000 -pass "file:$KEY" -in "$F" | pg_restore --no-owner -d "$DB"10mkdir -p "$HOME/sp-message-data/blobs"11rsync -a "$HOME/backups/sp-message/blobs/" "$HOME/sp-message-data/blobs/"12echo "restored $F into $DB"13
Files main
Menu

Theme