1 files changed, 28 insertions, 0 deletions
diff --git a/postgresql.nix b/postgresql.nix
new file mode 100644
index 0000000..b11c832
--- /dev/null
+++ b/postgresql.nix
@@ -0,0 +1,28 @@
+{ config, ... }:
+let
+  dataDir = "/media/draupner/postgresql/${config.services.postgresql.package.psqlSchema}";
+in
+{
+  services.postgresql = {
+    enable = true;
+    enableJIT = true;
+    inherit dataDir;
+    ensureUsers = [
+      {
+        name = "mathias";
+        ensureClauses.superuser = true;
+        ensureClauses.login = true;
+      }
+    ];
+    authentication = ''
+      local all postgres peer
+      local all all      peer map=m
+    '';
+    identMap = ''
+      m mathias all
+      m /^(.*)$ \1
+    '';
+  };
+
+  systemd.tmpfiles.rules = [ "d ${dataDir} 750 postgres postgres" ];
+}