24 lines
1.3 KiB
Bash
24 lines
1.3 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
|
|
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
|