forked from mtusi2026/mtusi2026lab2
22 lines
1.8 KiB
Bash
Executable File
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"
|