blob: 1540d9737ab521f1ed6df5266906836e441e6c89 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
#!/bin/bash
set -e
if [ ! -d /var/lib/postgresql/9.4/main ]; then
echo Bootstrapping DB
mkdir -p /var/lib/postgresql/9.4/main
chown -R postgres /var/lib/postgresql/9.4
su postgres -c '/usr/lib/postgresql/9.4/bin/initdb /var/lib/postgresql/9.4/main'
service postgresql start
su postgres -c "psql --command=\"CREATE ROLE nms PASSWORD 'risbrod' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;\""
su postgres -c "createdb -O nms nms"
su postgres -c "psql --command=\"CREATE ROLE grafana PASSWORD 'grafana' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;\""
su postgres -c "createdb -O grafana grafana"
su postgres -c "cat /opt/gondul/build/schema.sql | psql nms"
service postgresql stop
echo Bootstrap done
fi
exec pg_ctlcluster --foreground 9.4 main start
|
