source /vagrant/scripts/functions.sh
logger1 'Begin provisioner "install-scorr-postgres-database"...'

logger2 'Set Postgres user "postgres" password="postgres"'
sudo -u postgres psql -U postgres -d postgres -c "alter user postgres with password '$POSTGRES_PASSWORD';"


logger2 'DEPLOYING SCORR DATABASE BACKUP...'
logger2 'Modify pg_hba.conf to allow pg_restore without password prompt'
# Enable pg_restore without password
# Change pg_hba.conf to:
# host   all   all   127.0.0.1/32   trust
sed -i.bak1 's/^\(host\s*all\s*all\s*127\.0\.0\.1\/32\s*\)md5/\1trust/g' /etc/postgresql/$POSTGRES_VERSION/main/pg_hba.conf


logger2 'Restarting postgres...'
service postgresql restart
logger2 'Waiting 10 seconds for postgres to restart'
sleep 10


logger2 'Create scorr database'
createdb --username postgres --host localhost --port 5432 --owner postgres --echo scorr


logger2 'Restore SCoRR database'
sudo -u postgres pg_restore --username postgres --host localhost --port 5432 --dbname scorr --verbose /vagrant/$POSTGRES_SCORR_SQL_DUMP_FILE


logger2 'Restore pg_hba.conf to original settings'
# Restore pg_restore settings
# Change pg_hba.conf to:
# host   all   all   127.0.0.1/32   md5
sed -i.bak2 's/^\(host\s*all\s*all\s*127\.0\.0\.1\/32\s*\)trust/\1md5/g' /etc/postgresql/$POSTGRES_VERSION/main/pg_hba.conf