1 files changed, 20 insertions, 0 deletions
diff --git a/modules/by-name/po/postgresql/module.nix b/modules/by-name/po/postgresql/module.nix
index 319c3ac5..ccc08b37 100644
--- a/modules/by-name/po/postgresql/module.nix
+++ b/modules/by-name/po/postgresql/module.nix
@@ -1,6 +1,7 @@
 {
   config,
   lib,
+  pkgs,
   ...
 }: let
   cfg = config.vhack.postgresql;
@@ -14,6 +15,25 @@ in {
       "/var/lib/postgresql"
     ];
 
+    vhack.services.backup = {
+      exclude = [
+        "/var/lib/postgresql" # included in the db dump
+      ];
+
+      backupPrepare.postgresql = ''
+        ${lib.getExe pkgs.sudo} -u postgres \
+            ${lib.getExe' "pg_dumpall" pkgs.postgresql} \
+              --clean \
+              --if-exists \
+              --quote-all-identifiers |
+            ${lib.getExe pkgs.xz} \
+              --compress \
+              -9 \
+              --extreme \
+              --threads=0 > /srv/db_backup.sql.xz
+      '';
+    };
+
     services.postgresql.enable = true;
   };
 }