blob: 70306a62625bd267db1cf6c015c01c79ff5bfcd2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
#!/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
|
