Skript restore_database.sh
Automaticky generovaná dokumentace skriptu scripts/restore_database.sh.
1#!/usr/bin/env bash
2echo "Restoring database"
3psql -U postgres -c "DROP DATABASE IF EXISTS ${DBNAME};"
4psql -U postgres -c "CREATE DATABASE ${DBNAME};"
5psql -U postgres -c "CREATE ROLE cz_archeologickamapa_api;"
6psql -U postgres -c "CREATE ROLE cz_archeologickamapa_api_view;"
7psql -U postgres -c "CREATE ROLE ${DB_FLAG_ROLE};"
8psql -U postgres -c "ALTER ROLE ${DB_FLAG_ROLE} CONNECTION LIMIT 0;"
9pg_restore -v -e -d ${DBNAME} -e /tmp/${USED_DB_BACKUP} > /tmp/log
10psql -U postgres -c "ALTER ROLE ${DB_FLAG_ROLE} CONNECTION LIMIT -1;"
11psql -U postgres -c "GRANT ALL PRIVILEGES ON DATABASE ${DBNAME} TO postgres;"
12echo "Database restored successfully"