profiles/postgresql.nix


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

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