#!/bin/sh
# Runs once when PostgreSQL initializes a fresh data volume.
set -eu
export GDSGATE_STORE_PASSWORD="$(cat /run/secrets/store_password)"
psql --set ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<'SQL'
\getenv app_password GDSGATE_STORE_PASSWORD
CREATE ROLE gdsgate LOGIN NOSUPERUSER NOCREATEDB NOCREATEROLE PASSWORD :'app_password';
ALTER DATABASE gdsgate OWNER TO gdsgate;
SQL
unset GDSGATE_STORE_PASSWORD