Mercurial > public > ssdt-docker

annotate trainingdb/setupDatabase.sh @ 341:9735d4fef9c5 production v2.7.0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
flow: Merged <release> '2.7.0' to <master> ('production').
author aldrich@ssdt-ohio.org
date Mon, 04 May 2020 19:13:14 +0100
parents a5175713518c
children
rev   line source
36
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
1 #!/bin/bash
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
2
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
3 export PGUSER=postgres
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
4 TEST=`psql <<- EOSQL
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
5 SELECT 1 FROM pg_database WHERE datname='$DB_NAME';
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
6 EOSQL`
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
7
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
8 if [[ $TEST == "1" ]]; then
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
9 echo "$DB_NAME exists. continuing startup."
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
10 # database exists
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
11 # $? is 0
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
12 exit 0
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
13 else
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
14 echo "Creating $DB_NAME for $DB_USER"
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
15 psql <<- EOSQL
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
16 CREATE ROLE $DB_USER WITH LOGIN ENCRYPTED PASSWORD '${DB_PASS}' CREATEDB;
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
17 CREATE DATABASE $DB_NAME WITH OWNER $DB_USER TEMPLATE template0 ENCODING 'UTF8';
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
18 GRANT ALL PRIVILEGES ON DATABASE $DB_NAME TO $DB_USER;
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
19 EOSQL
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
20
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
21 echo "Restoring backup file"
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
22
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
23 gunzip -f $BACKUP_FILE -c | psql
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
24
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
25 fi
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
26
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
27 echo ""
a5175713518c add training db images
smith@nwoca.org
parents:
diff changeset
28 echo "$DB_NAME database created"