profiles/postgresql.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

{ config, ... }:
{
  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";
  };

  environment.persistence."/persist/save".directories = [
    config.services.postgresqlBackup.location
  ];
}