#!/usr/bin/env bash
# PostgreSQL init script for sourcehut databases
# This runs automatically on first postgres container start
set -e

psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
    CREATE USER metasrht WITH PASSWORD 'metasrht';
    CREATE DATABASE metasrht OWNER metasrht;

    CREATE USER gitsrht WITH PASSWORD 'gitsrht';
    CREATE DATABASE gitsrht OWNER gitsrht;

    CREATE USER todosrht WITH PASSWORD 'todosrht';
    CREATE DATABASE todosrht OWNER todosrht;

    CREATE USER hubsrht WITH PASSWORD 'hubsrht';
    CREATE DATABASE hubsrht OWNER hubsrht;
EOSQL

echo "Databases metasrht, gitsrht, todosrht and hubsrht created."