blob: d9850daba72a32ceccde7bb7f5c26f697384e40a (
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
|
#!/bin/sh
# set -x
PN=postgresql
CONTROLLER_IP=%CONTROLLER_IP%
COMPUTE_IP=%COMPUTE_IP%
DB_USER=%DB_USER%
DB_PASSWORD=%DB_PASSWORD%
if [ -e /etc/${PN}/PG_VERSION ]; then
# the database has already been initialized, return
exit 0
fi
sudo -u postgres initdb -D /etc/${PN}/
sleep 2
echo "listen_addresses = '*'" >> /etc/${PN}/postgresql.conf
echo "host all all ${CONTROLLER_IP}/32 trust" >> /etc/${PN}/pg_hba.conf
echo "host all all ${COMPUTE_IP}/32 trust" >> /etc/${PN}/pg_hba.conf
sleep 2
/etc/init.d/postgresql start
sleep 10
count=0
done=0
while [ $count -le 10 ] && [ $done -eq 0 ]; do
sudo -u postgres psql -c "CREATE ROLE ${DB_USER} WITH SUPERUSER LOGIN PASSWORD '${DB_PASSWORD}'" 2> /dev/null
if [ $? -ne 0 ]; then
echo "[INFO] postgres: failed to create account for ${DB_USER}, trying again"
/etc/init.d/postgresql stop
sleep 3
/etc/init.d/postgresql start
sleep 3
else
echo "[INFO] postgres: created account for ${DB_USER}, continuing .. "
done=1
fi
count=`expr $count + 1`
done
if [ $done -eq 0 ]; then
echo "[ERROR] postgres: unable to create admin account"
exit 1
fi
ln -s /usr/share/zoneinfo /usr/share/postgresql/timezone
|
