From c78f92b2e9313f75bb29abb919171979393ec0c8 Mon Sep 17 00:00:00 2001
From: Franck Cuny <franck@fcuny.net>
Date: Fri, 23 Jan 2026 08:49:30 -0800
Subject: enable postgresql + backups

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

(limited to 'profiles/postgresql.nix')

diff --git a/profiles/postgresql.nix b/profiles/postgresql.nix
new file mode 100644
index 0000000..6e473ad
--- /dev/null
+++ b/profiles/postgresql.nix
@@ -0,0 +1,20 @@
+{ ... }:
+{
+  services.postgresql = {
+    enable = true;
+    authentication = ''
+      local all all peer map=mapping
+    '';
+    identMap = ''
+      mapping fcuny    postgres
+      mapping root     postgres
+      mapping postgres postgres
+      mapping /^(.*)$  \1
+    '';
+  };
+
+  services.postgresqlBackup = {
+    enable = true;
+    compression = "zstd";
+  };
+}
-- 
cgit v1.2.3