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
25
26
27
28

{ config, ... }:
let
  dataDir = "/media/draupner/postgresql/${config.services.postgresql.package.psqlSchema}";
in
{
  services.postgresql = {
    enable = true;
    enableJIT = true;
    inherit dataDir;
    ensureUsers = [
      {
        name = "mathias";
        ensureClauses.superuser = true;
        ensureClauses.login = true;
      }
    ];
    authentication = ''
      local all postgres peer
      local all all      peer map=m
    '';
    identMap = ''
      m mathias all
      m /^(.*)$ \1
    '';
  };

  systemd.tmpfiles.rules = [ "d ${dataDir} 750 postgres postgres" ];
}