Create Postgres roles and users in init from .env files variables

postregres_init_create_roles.sh

#!/bin/bash

set -e
set -u

function create_user_and_database() {
	if psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" -tXAc "SELECT 1 FROM pg_roles WHERE rolname='$POSTGRES_USER'"; then
		echo Roles already exist, skipping creation.
	else
		echo Running SQL commands
		psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
		CREATE USER $POSTGRES_USER WITH PASSWORD '$POSTGRES_PASSWORD';
		CREATE DATABASE $POSTGRES_DB;
		GRANT ALL PRIVILEGES ON DATABASE $POSTGRES_DB TO $POSTGRES_USER;
		EOSQL
		echo Done!
	fi
}

echo Creating DB roles...
create_user_and_database