Backup wiki research

1 files changed, 23 insertions, 15 deletions

diff --git a/dbms.nix b/dbms.nix
index 455125c..cf095f8 100644
--- a/dbms.nix
+++ b/dbms.nix
@@ -18,21 +18,29 @@
 
 { pkgs, ... }:
 {
-  services.postgresql = {
-    enable = true;
-    package = pkgs.postgresql_15;
-    settings = {
-      checkpoint_timeout = "5min";
-      effective_cache_size = "1GB";
-      effective_io_concurrency = 100;
-      maintenance_work_mem = "320MB";
-      max_parallel_maintenance_workers = 4;
-      max_parallel_workers_per_gather = 4;
-      max_wal_senders = 0;
-      random_page_cost = 1.25;
-      shared_buffers = "512MB";
-      wal_buffers = -1;
-      work_mem = "32MB";
+  services = {
+    postgresql = {
+      enable = true;
+      package = pkgs.postgresql_15;
+      settings = {
+        checkpoint_timeout = "5min";
+        effective_cache_size = "1GB";
+        effective_io_concurrency = 100;
+        maintenance_work_mem = "320MB";
+        max_parallel_maintenance_workers = 4;
+        max_parallel_workers_per_gather = 4;
+        max_wal_senders = 0;
+        random_page_cost = 1.25;
+        shared_buffers = "512MB";
+        wal_buffers = -1;
+        work_mem = "32MB";
+      };
+    };
+    postgresqlBackup = {
+      compression = "zstd";
+      compressionLevel = 19;
+      enable = true;
+      location = "/mnt/nas/backup/postgresql";
     };
   };
 }