From 4f756e45b8393d4388af9bb3b7ee34d2ef79b46d Mon Sep 17 00:00:00 2001 From: Kristian Lyngstol Date: Tue, 22 Nov 2016 15:35:16 +0100 Subject: Use persistent postgres storage and make grafana use postgres backing Still need to fix session storage for Grafana. After that, the container is stateless. --- build/test/postgres.sh | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100755 build/test/postgres.sh (limited to 'build/test/postgres.sh') 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 -- cgit v1.2.3