#!/bin/bash

sudo su postgres

PW="password"
DB="gargandbV5"
USER="gargantua"

psql -c "CREATE USER \"${USER}\"
psql -c "ALTER USER \"${USER}\" with PASSWORD \"${PW}\""

psql -c "DROP DATABASE IF EXISTS \"${DB}\""
createdb "${DB}"
psql "${DB}" < schema.sql

psql -c "ALTER DATABASE \"${DB}\" OWNER to \"${USER}\" ;"