38 lines
2.2 KiB
Bash
38 lines
2.2 KiB
Bash
#!/usr/bin/env sh
|
|
set -eu
|
|
psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" -v ON_ERROR_STOP=1 -v continuity_password="$CONTINUITY_DB_PASSWORD" <<'SQL'
|
|
ALTER ROLE continuity_role PASSWORD :'continuity_password';
|
|
SQL
|
|
psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" -v ON_ERROR_STOP=1 -v identity_password="$IDENTITY_DB_PASSWORD" <<'SQL'
|
|
ALTER ROLE identity_role PASSWORD :'identity_password';
|
|
SQL
|
|
psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" -v ON_ERROR_STOP=1 -v authority_password="$AUTHORITY_DB_PASSWORD" <<'SQL'
|
|
ALTER ROLE authority_role PASSWORD :'authority_password';
|
|
SQL
|
|
psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" -v ON_ERROR_STOP=1 -v situation_password="$SITUATION_DB_PASSWORD" <<'SQL'
|
|
ALTER ROLE situation_role PASSWORD :'situation_password';
|
|
SQL
|
|
psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" -v ON_ERROR_STOP=1 -v work_password="$WORK_DB_PASSWORD" <<'SQL'
|
|
ALTER ROLE work_role PASSWORD :'work_password';
|
|
SQL
|
|
psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" -v ON_ERROR_STOP=1 -v capability_password="$CAPABILITY_DB_PASSWORD" <<'SQL'
|
|
ALTER ROLE capability_role PASSWORD :'capability_password';
|
|
SQL
|
|
if [ "${EPISTEMICS_DB_PASSWORD_FILE:-}" != "" ]; then
|
|
EPISTEMICS_DB_PASSWORD="$(tr -d '\r\n' < "$EPISTEMICS_DB_PASSWORD_FILE")"
|
|
fi
|
|
: "${EPISTEMICS_DB_PASSWORD:?EPISTEMICS_DB_PASSWORD or EPISTEMICS_DB_PASSWORD_FILE is required}"
|
|
psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" -v ON_ERROR_STOP=1 -v epistemics_password="$EPISTEMICS_DB_PASSWORD" <<'SQL'
|
|
ALTER ROLE epistemics_role PASSWORD :'epistemics_password';
|
|
SQL
|
|
psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" -v ON_ERROR_STOP=1 -v commit_password="$COMMIT_DB_PASSWORD" <<'SQL'
|
|
ALTER ROLE commit_role PASSWORD :'commit_password';
|
|
SQL
|
|
if [ "${INTERACTION_DB_PASSWORD_FILE:-}" != "" ]; then
|
|
INTERACTION_DB_PASSWORD="$(tr -d '\r\n' < "$INTERACTION_DB_PASSWORD_FILE")"
|
|
fi
|
|
: "${INTERACTION_DB_PASSWORD:?INTERACTION_DB_PASSWORD or INTERACTION_DB_PASSWORD_FILE is required}"
|
|
psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" -v ON_ERROR_STOP=1 -v interaction_password="$INTERACTION_DB_PASSWORD" <<'SQL'
|
|
ALTER ROLE interaction_role PASSWORD :'interaction_password';
|
|
SQL
|