Add given password for hosts/mermet/knot/autogeree.net/lebureau.conf to store.

[sourcephile-nix.git] / hosts / mermet / postgresql.nix

diff --git a/hosts/mermet/postgresql.nix b/hosts/mermet/postgresql.nix
index 6d596f969db6657e9e05a140f5f634a59277fc92..2891c52c04abf6ebdcd6dfa34d6e4e9a75cdaa30 100644 (file)
--- a/hosts/mermet/postgresql.nix
+++ b/hosts/mermet/postgresql.nix
@@ -25,7 +25,7 @@ in
   ];
   services.postgresql = {
     enable = true;
-    package = pkgs.postgresql_12;
+    package = pkgs.postgresql_13;
     enableTCPIP = false;
     # zfs set recordsize=16k
     # zfs set sync=disabled
@@ -101,12 +101,21 @@ in
   services.sanoid.datasets = {
     "rpool/var/lib/postgresql" = {
       use_template = [ "snap" ];
+      monthly = 1;
       daily = 31;
-      hourly = 24;
+      hourly = 0;
       recursive = true;
     };
   };
   systemd.services.postgresql = {
+    serviceConfig = {
+      CPUAccounting = true;
+      #CPUWeight = "idle";
+      CPUQuota = "75%";
+      MemoryAccounting = true;
+      MemoryHigh = "500M";
+      MemoryMax = "600M";
+    };
     # DOC: https://wiki.postgresql.org/wiki/Shared_Database_Hosting
     postStart = ''
       set -eux