Mercurial > public > ssdt-docker

comparison postgres/setupExtensions.sh @ 81:53671513b240

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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