#!/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 }" 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"