forked from mtusi2026/mtusi2026lab7
39 lines
1.5 KiB
Bash
Executable File
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"
|