db_Dockerfile

FROM nornagon/postgres
MAINTAINER mike@suteki.co.uk

ADD sql sql
ADD create_db.sh /src/

USER postgres

RUN /src/create_db.sh

------- create_db.sh

#! /bin/bash

id

/etc/init.d/postgresql start

psql --command "CREATE USER queuespy WITH SUPERUSER PASSWORD 'queuespy';"

createdb -O queuespy queuespy

psql -l

for i in /sql/tables/*.sql
do
    psql --file=$i --dbname=queuespy
done

for i in /sql/static_data/*.sql
do
    psql --file=$i --dbname=queuespy
done

/etc/init.d/postgresql stop