Files

39 lines
1.5 KiB
Bash
Executable File

#!/bin/sh
set -eu
case "${1:-}" in
create) sql_file=/bootstrap/roles.sql ;;
grant) sql_file=/bootstrap/grants.sql ;;
*) echo "usage: $0 create|grant" >&2; exit 2 ;;
esac
: "${POSTGRES_DB:?POSTGRES_DB is required}"
: "${POSTGRES_USER:?POSTGRES_USER is required}"
: "${POSTGRES_PASSWORD:?POSTGRES_PASSWORD is required}"
: "${POSTGRES_API_PASSWORD:?POSTGRES_API_PASSWORD is required}"
: "${POSTGRES_DISPATCHER_PASSWORD:?POSTGRES_DISPATCHER_PASSWORD is required}"
: "${POSTGRES_WORKER_PASSWORD:?POSTGRES_WORKER_PASSWORD is required}"
: "${POSTGRES_RECONCILER_PASSWORD:?POSTGRES_RECONCILER_PASSWORD is required}"
: "${POSTGRES_EXPORTER_PASSWORD:?POSTGRES_EXPORTER_PASSWORD is required}"
: "${POSTGRES_MIGRATE_PASSWORD:?POSTGRES_MIGRATE_PASSWORD is required}"
export PGPASSWORD=$POSTGRES_PASSWORD
export PGSSLROOTCERT=${PGSSLROOTCERT:-/run/security/internal-ca/ca.crt}
export PGSSLCERT=${PGSSLCERT:-/run/security/client/tls.crt}
export PGSSLKEY=${PGSSLKEY:-/run/security/client/tls.key}
export PGSSLMODE=verify-full
psql \
--host=postgres \
--username="$POSTGRES_USER" \
--dbname="$POSTGRES_DB" \
--set=ON_ERROR_STOP=1 \
--set=api_password="$POSTGRES_API_PASSWORD" \
--set=dispatcher_password="$POSTGRES_DISPATCHER_PASSWORD" \
--set=worker_password="$POSTGRES_WORKER_PASSWORD" \
--set=reconciler_password="$POSTGRES_RECONCILER_PASSWORD" \
--set=exporter_password="$POSTGRES_EXPORTER_PASSWORD" \
--set=migrate_password="$POSTGRES_MIGRATE_PASSWORD" \
--file="$sql_file"