1 files changed, 20 insertions, 0 deletions

diff --git a/hosts/surtr/postgres.nix b/hosts/surtr/postgres.nix
new file mode 100644
index 00000000..e8ea73be
--- /dev/null
+++ b/hosts/surtr/postgres.nix
@@ -0,0 +1,20 @@
+{ pkgs, ... }:
+{
+  config = {
+    services.postgresql = {
+      enable = true;
+      package = pkgs.postgresql_14;
+      ensureDatabases = [
+        "matrix-synapse"
+      ];
+      ensureUsers = [
+        { name = "matrix-synapse";
+          ensurePermissions = {
+            "DATABASE \"matrix-synapse\"" = "ALL PRIVILEGES";
+            "ALL TABLES IN SCHEMA public" = "ALL PRIVILEGES";
+          };
+        }
+      ];
+    };
+  };
+}