Files
Assistant/deploy/images/002_owner_passwords.sh
2026-08-16 15:22:49 +03:00

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