github.com/mboersma/deis@v1.13.4/database/templates/reload (about) 1 #!/usr/bin/env bash 2 # 3 # This script is designed to be run inside the container 4 # 5 6 # provide defaults for required envvars 7 PG_CONFIG=${PG_CONFIG:-/etc/postgresql/main/postgresql.conf} 8 PG_LISTEN=${PG_LISTEN:-*} 9 10 # run idemptoent database configuration 11 sudo -i -u postgres psql postgres <<EOF 12 ALTER ROLE postgres WITH PASSWORD '{{ getv "/deis/database/adminPass" }}'; 13 CREATE ROLE {{ getv "/deis/database/user" }} WITH LOGIN; 14 ALTER ROLE {{ getv "/deis/database/user" }} WITH PASSWORD '{{ getv "/deis/database/password" }}'; 15 CREATE DATABASE {{ getv "/deis/database/name" }} WITH OWNER {{ getv "/deis/database/user" }}; 16 EOF