#!/bin/sh set -eu : "${API_DB_USER:?API_DB_USER is required}" : "${API_DB_PASSWORD:?API_DB_PASSWORD is required}" : "${WORKER_DB_USER:?WORKER_DB_USER is required}" : "${WORKER_DB_PASSWORD:?WORKER_DB_PASSWORD is required}" : "${OUTBOX_DB_USER:?OUTBOX_DB_USER is required}" : "${OUTBOX_DB_PASSWORD:?OUTBOX_DB_PASSWORD is required}" psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" --set ON_ERROR_STOP=1 \ --set api_user="$API_DB_USER" --set api_password="$API_DB_PASSWORD" \ --set worker_user="$WORKER_DB_USER" --set worker_password="$WORKER_DB_PASSWORD" \ --set outbox_user="$OUTBOX_DB_USER" --set outbox_password="$OUTBOX_DB_PASSWORD" <<'SQL' SELECT format('CREATE ROLE %I LOGIN PASSWORD %L', :'api_user', :'api_password') \gexec SELECT format('CREATE ROLE %I LOGIN PASSWORD %L', :'worker_user', :'worker_password') \gexec SELECT format('CREATE ROLE %I LOGIN PASSWORD %L', :'outbox_user', :'outbox_password') \gexec SELECT format('GRANT CONNECT ON DATABASE %I TO %I', current_database(), :'api_user') \gexec SELECT format('GRANT CONNECT ON DATABASE %I TO %I', current_database(), :'worker_user') \gexec SELECT format('GRANT CONNECT ON DATABASE %I TO %I', current_database(), :'outbox_user') \gexec GRANT USAGE ON SCHEMA public TO :"api_user", :"worker_user", :"outbox_user"; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO :"api_user", :"worker_user"; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT USAGE, SELECT ON SEQUENCES TO :"api_user", :"worker_user"; SQL