Files

22 lines
1.8 KiB
Bash
Executable File

#!/bin/sh
# Восстановление dump в НОВОЕ хранилище (временный контейнер со свежим томом) и сверка с рабочей БД.
# Использование: sh scripts/restore-check.sh backups/messenger-XXXX.dump
# ВНИМАНИЕ: не запускался в среде подготовки (там нет Docker); эквивалентный эксперимент выполнен через
# scripts/track2_restore.py на двух отдельных серверах PostgreSQL (см. evidence/track2-restore.json).
set -eu
cd "$(dirname "$0")/.."
DUMP="${1:?usage: restore-check.sh <dump>}"
DC="docker compose --env-file .env"
NAME="pg-restore-check-$$"
trap 'docker rm -f "$NAME" >/dev/null 2>&1 || true' EXIT
docker run -d --name "$NAME" -e POSTGRES_PASSWORD=restore-check-only -e POSTGRES_USER=messenger -e POSTGRES_DB=restored postgres:17.6-alpine >/dev/null
i=0; until docker exec "$NAME" pg_isready -U messenger -d restored >/dev/null 2>&1; do i=$((i+1)); [ $i -le 60 ] || exit 1; sleep 1; done
START=$(date +%s)
docker exec -i "$NAME" pg_restore -U messenger -d restored --no-owner --exit-on-error < "$DUMP"
docker exec "$NAME" psql -U messenger -d restored -qc "ANALYZE"
echo "restore+analyze seconds: $(( $(date +%s) - START ))"
Q="select 'users',count(*) from users union all select 'chats',count(*) from chats union all select 'chat_members',count(*) from chat_members union all select 'messages',count(*) from messages union all select 'messages_md5', md5(string_agg(id::text||chat_id::text||sender_id::text||created_at::text||md5(text), ',' order by id))::text from messages"
echo "--- restored ---"; docker exec "$NAME" psql -U messenger -d restored -At -c "$Q"
echo "--- source (rows after the dump may differ: that is the RPO window) ---"
$DC exec -T postgres psql -U messenger -d messenger -At -c "$Q"