From b4293d801ec6d4d3e92f67afb95fc919bdbf9a2e Mon Sep 17 00:00:00 2001
From: Gregor Kleen <gkleen@yggdrasil.li>
Date: Fri, 25 Feb 2022 13:42:02 +0100
Subject: surtr: matrix: ma1sd

---
 hosts/surtr/postgresql.nix | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'hosts/surtr/postgresql.nix')

diff --git a/hosts/surtr/postgresql.nix b/hosts/surtr/postgresql.nix
index a34bc675..88430823 100644
--- a/hosts/surtr/postgresql.nix
+++ b/hosts/surtr/postgresql.nix
@@ -9,6 +9,11 @@
         CREATE USER "matrix-synapse";
         GRANT ALL PRIVILEGES ON DATABASE "matrix-synapse" TO "matrix-synapse";
         GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "matrix-synapse";
+
+        CREATE DATABASE "ma1sd" WITH TEMPLATE "template0" ENCODING "UTF8" LOCALE "C";
+        CREATE USER "ma1sd";
+        GRANT ALL PRIVILEGES ON DATABASE "ma1sd" TO "ma1sd";
+        GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "ma1sd";
       '';
     };
   };
-- 
cgit v1.2.3