#!/bin/sh
set -eu
psql --username "$POSTGRES_USER" --dbname postgres --set ON_ERROR_STOP=1 <<'SQL'
\getenv registry_password PLATFORM_DB_PASSWORD
CREATE ROLE platform LOGIN NOSUPERUSER NOCREATEDB NOCREATEROLE PASSWORD :'registry_password';
CREATE DATABASE platform OWNER platform;
REVOKE CONNECT ON DATABASE platform FROM PUBLIC;
SQL