aboutsummaryrefslogtreecommitdiffstats
path: root/pgaas/src/stage/opt/app/pgaas/etc/create-extensions
diff options
context:
space:
mode:
Diffstat (limited to 'pgaas/src/stage/opt/app/pgaas/etc/create-extensions')
-rw-r--r--pgaas/src/stage/opt/app/pgaas/etc/create-extensions53
1 files changed, 0 insertions, 53 deletions
diff --git a/pgaas/src/stage/opt/app/pgaas/etc/create-extensions b/pgaas/src/stage/opt/app/pgaas/etc/create-extensions
deleted file mode 100644
index 70306a6..0000000
--- a/pgaas/src/stage/opt/app/pgaas/etc/create-extensions
+++ /dev/null
@@ -1,53 +0,0 @@
-#!/bin/bash
-# Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
-#
-# Licensed under the Apache License, Version 2.0 (the "License");
-# you may not use this code except in compliance
-# with the License. You may obtain a copy of the License
-# at http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing, software
-# distributed under the License is distributed on an "AS IS" BASIS,
-# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
-# implied. See the License for the specific language governing
-# permissions and limitations under the License.
-
-
-set -x
-
-die()
-{
- echo $0: "$@" 1>&2
- echo $0: "$@"
- umask 022
- echo $0: "$@" >> /tmp/pgaas-failures
- exit 1
-}
-
-[ -n "$PGDIR" ] || die "PGDIR is not set"
-
-PATH=${INSTALL_ROOT}/opt/app/pgaas/bin:$PGDIR/bin:$PATH
-
-TMP=$(mktemp /tmp/tmp.ce.XXXXXXXXXX)
-trap 'rm -f $TMP' 0 1 2 3 15
-
-echo "select datname from pg_database;" | psql --tuples-only | sed -e 's/^ *//' -e '/^$/d' -e '/^template0$/d' -e '/^repmgr$/d' > $TMP
-
-for db in $(< $TMP)
-do
- # enable temporal tables for use
- if [ -f /opt/app/postgresql-9.5.2/lib/temporal_tables.so ]
- then
- psql --dbname=$db <<-EOF
- CREATE EXTENSION temporal_tables;
- EOF
- else
- echo "$0: temporal_tables extension is not installed"
- fi
-
- # and other extensions
- psql --dbname=$db <<-EOF
- CREATE EXTENSION hstore;
- CREATE EXTENSION pgcrypto;
- EOF
-done