12 lines
498 B
Bash
12 lines
498 B
Bash
#!/bin/bash
|
|
set -e
|
|
|
|
for pair in "ota_prod:${POSTGRES_PASS_PROD}" "ota_preprod:${POSTGRES_PASS_PREPROD}" "ota_omnex_cli:${POSTGRES_PASS_OMNEX_CLI}" "ota_omnex_admin:${POSTGRES_PASS_OMNEX_ADMIN}" "ota_mobile_prod:${POSTGRES_PASS_MOBILE_PROD}" "ota_mobile_preprod:${POSTGRES_PASS_MOBILE_PREPROD}"; do
|
|
db="${pair%%:*}"
|
|
pass="${pair##*:}"
|
|
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" <<-EOSQL
|
|
CREATE USER ${db} WITH PASSWORD '${pass}';
|
|
CREATE DATABASE ${db} OWNER ${db};
|
|
EOSQL
|
|
done
|