#!/bin/sh set -eu restore_database=${RESTORE_DATABASE:-messenger_restore} backup_file=$(mktemp) trap 'rm -f "$backup_file"' EXIT started_at=$(date +%s) docker compose exec -T postgres sh -eu -c ' export PGPASSWORD="$POSTGRES_PASSWORD" pg_dump --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" --format custom ' > "$backup_file" docker compose exec -T postgres sh -eu -c ' export PGPASSWORD="$POSTGRES_PASSWORD" dropdb --username "$POSTGRES_USER" --if-exists "$1" createdb --username "$POSTGRES_USER" "$1" ' sh "$restore_database" docker compose exec -T postgres sh -eu -c ' export PGPASSWORD="$POSTGRES_PASSWORD" pg_restore --username "$POSTGRES_USER" --dbname "$1" --no-owner --no-privileges ' sh "$restore_database" < "$backup_file" original=$(docker compose exec -T postgres sh -eu -c ' export PGPASSWORD="$POSTGRES_PASSWORD" psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" --tuples-only --no-align --command " SELECT count(*) FROM users; SELECT count(*) FROM chats; SELECT count(*) FROM chat_members; SELECT count(*) FROM messages; WITH sample AS ( (SELECT * FROM messages ORDER BY created_at, id LIMIT 5) UNION ALL (SELECT * FROM messages ORDER BY created_at DESC, id DESC LIMIT 5) ) SELECT md5(COALESCE(string_agg( id::text || '\''|'\'' || chat_id::text || '\''|'\'' || sender_id::text || '\''|'\'' || md5(text) || '\''|'\'' || created_at::text, '\'';'\'' ORDER BY created_at, id ), '\'''\'')) FROM sample; " ') restored=$(docker compose exec -T postgres sh -eu -c ' export PGPASSWORD="$POSTGRES_PASSWORD" psql --username "$POSTGRES_USER" --dbname "$1" --tuples-only --no-align --command " SELECT count(*) FROM users; SELECT count(*) FROM chats; SELECT count(*) FROM chat_members; SELECT count(*) FROM messages; WITH sample AS ( (SELECT * FROM messages ORDER BY created_at, id LIMIT 5) UNION ALL (SELECT * FROM messages ORDER BY created_at DESC, id DESC LIMIT 5) ) SELECT md5(COALESCE(string_agg( id::text || '\''|'\'' || chat_id::text || '\''|'\'' || sender_id::text || '\''|'\'' || md5(text) || '\''|'\'' || created_at::text, '\'';'\'' ORDER BY created_at, id ), '\'''\'')) FROM sample; " ' sh "$restore_database") if [ "$original" != "$restored" ]; then echo "backup verification failed" >&2 exit 1 fi finished_at=$(date +%s) users=$(printf '%s\n' "$original" | sed -n '1p') chats=$(printf '%s\n' "$original" | sed -n '2p') members=$(printf '%s\n' "$original" | sed -n '3p') messages=$(printf '%s\n' "$original" | sed -n '4p') cat > evidence/lab2-backup-restore.txt <