1 files changed, 15 insertions, 0 deletions

diff --git a/hosts/surtr/postgresql.nix b/hosts/surtr/postgresql.nix
new file mode 100644
index 00000000..f0cb155b
--- /dev/null
+++ b/hosts/surtr/postgresql.nix
@@ -0,0 +1,15 @@
+{ pkgs, ... }:
+{
+  config = {
+    services.postgresql = {
+      enable = true;
+      package = pkgs.postgresql_14;
+      initalScript = pkgs.writeText "schema.sql" ''
+        CREATE DATABASE "matrix-synapse" WITH ENCODING "UTF8" LOCALE "C";
+        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";
+      '';
+    };
+  };
+}