diff options
| author | Kristian Lyngstol <kly@kly.no> | 2016-11-22 15:35:16 +0100 |
|---|---|---|
| committer | Kristian Lyngstol <kly@kly.no> | 2016-11-22 15:35:16 +0100 |
| commit | 4f756e45b8393d4388af9bb3b7ee34d2ef79b46d (patch) | |
| tree | 38aa83689db61ea3291fb89791d277ae4961f1b1 /build/test/postgres.sh | |
| parent | c38af8933072bb2b9606cd6490e1a802ab4c4187 (diff) | |
Use persistent postgres storage and make grafana use postgres backing
Still need to fix session storage for Grafana. After that, the container is
stateless.
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 |