1 files changed, 20 insertions, 0 deletions
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";
+  };
+}