From 5754980e3456e036add38f516115971c6411e93b Mon Sep 17 00:00:00 2001
From: Mathias Magnusson <mathias@magnusson.space>
Date: Sun, 23 Nov 2025 22:41:12 +0100
Subject: add immich

---
 postgresql.nix | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 postgresql.nix

(limited to 'postgresql.nix')

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" ];
+}
-- 
cgit v1.2.3