modules/postgresql/default.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

{ config, lib, pkgs, ... }:

{
  services.postgresql = {
    enable = true;
    ensureDatabases = [ "quassel" "pdns" ];
    ensureUsers = [
      {
        name = "quassel";
        ensurePermissions = { "DATABASE quassel" = "ALL PRIVILEGES"; };
      }
      {
        name = "pdns";
        ensurePermissions = { "DATABASE pdns" = "ALL PRIVILEGES"; };
      }
      {
        name = "audron";
        ensureClauses.superuser = true;
      }
      {
        name = "d3fus";
        ensureClauses.superuser = true;
      }
    ];
    authentication = pkgs.lib.mkOverride 10 ''
      #type database DBuser origin-address auth-method
      local all      all     trust
    '';
  };
}