Personal Homelab
krasovs.ky
1#!/usr/bin/env bash
2set -e
3
4psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
5 CREATE USER synapse WITH PASSWORD '${secrets.synapse_postgres_password}';
6 CREATE DATABASE synapse;
7 GRANT ALL PRIVILEGES ON DATABASE synapse TO synapse;
8
9 CREATE USER mas WITH PASSWORD '${secrets.matrix_authentication_service_postgres_password}';
10 CREATE DATABASE mas;
11 GRANT ALL PRIVILEGES ON DATABASE mas TO mas;
12EOSQL
13
14psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname synapse <<-EOSQL
15 GRANT ALL ON SCHEMA public TO synapse;
16EOSQL
17
18psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname mas <<-EOSQL
19 GRANT ALL ON SCHEMA public TO mas;
20EOSQL