Mercurial > public > ssdt-docker
comparison postgres/setupExtensions.sh @ 81:53671513b240
DEP-10: add timezone and locale settings. add java base image. add native APR for tomcat
author | smith@nwoca.org |
---|---|
date | Mon, 11 Apr 2016 17:46:42 -0400 |
parents | 5c093612ce89 |
children |
comparison
equal
deleted
inserted
replaced
80:5c093612ce89 | 81:53671513b240 |
---|---|
1 #!/bin/bash | 1 #!/bin/bash |
2 | 2 |
3 export PGUSER=postgres | 3 export PGUSER=postgres |
4 TEST=`psql <<- EOSQL | 4 result=`psql -t -A <<- EOSQL |
5 SELECT 1 FROM pg_database WHERE datname='$DB_NAME'; | 5 SELECT 1 FROM pg_database WHERE datname='$DB_NAME'; |
6 EOSQL` | 6 EOSQL` |
7 | 7 |
8 if [[ $TEST == "1" ]]; then | 8 echo "Checking extensions on $DB_NAME ( $result )" |
9 if [[ $result == "1" ]]; then | |
9 psql $DB_NAME <<- EOSQL | 10 psql $DB_NAME <<- EOSQL |
10 CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; | 11 CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; |
11 EOSQL | 12 EOSQL |
12 echo "Set extensions on $DB_NAME" | 13 echo "Set extensions on $DB_NAME" |
13 fi | 14 fi |