Newer
Older
Alexander König
committed
#!/bin/bash
set -e
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" <<-EOSQL
CREATE USER secretdspaceuser WITH PASSWORD 'secretdspacepassword';
CREATE DATABASE "secretdspacedbname" OWNER secretdspaceuser ENCODING "UTF-8" TEMPLATE template0;
CREATE DATABASE "secretdspaceutilsdbname" OWNER secretdspaceuser ENCODING "UTF-8" TEMPLATE template0;
EOSQL
psql --username "$POSTGRES_USER" --set=utildir="/tmp/sql/" -p 5432 secretdspaceutilsdbname < /tmp/sql/utilities.sql