modules/by-name/po/postgresql/module.nix


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

{
  config,
  lib,
  pkgs,
  ...
}: let
  cfg = config.vhack.postgresql;
in {
  options.vhack.postgresql = {
    enable = lib.mkEnableOption "postgresql";
  };

  config = lib.mkIf cfg.enable {
    vhack.persist.directories = [
      "/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;
  };
}