#!/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"