diff options
| author | Lasse Haugen <haugen.lasse@gmail.com> | 2016-12-16 13:02:26 +0100 |
|---|---|---|
| committer | Lasse Haugen <haugen.lasse@gmail.com> | 2016-12-16 13:02:26 +0100 |
| commit | 8c4fe3a787a1f95e81cdd3e36d66f45115d3322f (patch) | |
| tree | b8b3ed907ff634fae047c010d2233cba5598e829 /build/test/postgres.sh | |
| parent | 64e91a665adc3eef4692db80ca98c4f6de29895a (diff) | |
| parent | fdfb87ee3fe4166f49aae9349e57ab007bbe0932 (diff) | |
Merge branch 'master' of github.com:tech-server/gondul
Diffstat (limited to 'build/test/postgres.sh')
| -rwxr-xr-x | build/test/postgres.sh | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/build/test/postgres.sh b/build/test/postgres.sh new file mode 100755 index 0000000..1540d97 --- /dev/null +++ b/build/test/postgres.sh @@ -0,0 +1,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 |