Mercurial > public > ssdt-docker

comparison postgres/setupDatabase.sh @ 90:63cb9be89a26 production v1.0.0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
flow: Merged <release> 'v1.0.0' to <master> ('production').
author smith@nwoca.org
date Thu, 22 Sep 2016 01:49:20 +0100
parents 53671513b240
children
comparison
equal deleted inserted replaced
1:44f401c902ba 90:63cb9be89a26
1 #!/bin/bash
2
3 export PGUSER=postgres
4 result=`psql -t -A <<- EOSQL
5 SELECT 1 FROM pg_database WHERE datname='$DB_NAME';
6 EOSQL`
7
8 echo "checking for existing $DB_NAME ( $result ) "
9
10 if [[ $result == "1" ]]; then
11 echo "$DB_NAME exists. continuing startup."
12 # database exists
13 # $? is 0
14 exit 0
15 else
16 echo "Creating $DB_NAME for $DB_USER"
17 psql <<- EOSQL
18 CREATE ROLE $DB_USER WITH LOGIN ENCRYPTED PASSWORD '${DB_PASS}' CREATEDB;
19 CREATE DATABASE $DB_NAME WITH OWNER $DB_USER TEMPLATE template0 ENCODING 'UTF8';
20 GRANT ALL PRIVILEGES ON DATABASE $DB_NAME TO $DB_USER;
21 EOSQL
22 fi
23
24 echo ""
25 echo "$DB_NAME database created"