surtr: matrix: ma1sd

1 files changed, 5 insertions, 0 deletions

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";
       '';
     };
   };