#!/bin/bash -v

DB_NAME=sandoz_bbmb
DB_DUMP=/var/backup/fast/db_dumps/pg-${DB_NAME}-backup.gz
DB_DUMP=/var/backup/fast/db_dumps/pg-db-${DB_NAME}-backup.gz

ls -l $DB_DUMP
sudo -u postgres dropdb $DB_NAME

sudo -u postgres createdb -E UTF8 -T template0 $DB_NAME
if [ $? -ne 0 ] ; then exit 1; fi
if [ ! -f $DB_DUMP ] 
then
  echo "Cannot find $DB_DUMP. Have look at the get_db_dumps.rb script or get it directly from"
  exit 1
fi

sudo -u postgres psql -c "create user sandoz with UNENCRYPTED password 'sandoz';"
sudo -u postgres psql -c "alter user sandoz with UNENCRYPTED password 'sandoz';"
sudo -u postgres psql -c "grant all privileges on database $DB_NAME to sandoz ;"
sudo -u postgres psql -c 'create role apache with LOGIN;'
sudo -u postgres psql -c "create role $DB_NAME with LOGIN;"

zcat $DB_DUMP | sudo -u postgres psql $DB_NAME
if [ $? -ne 0 ] ; then exit 1; fi