hosts/surtr/postgres.nix


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

{ pkgs, ... }:
{
  config = {
    services.postgresql = {
      enable = true;
      package = pkgs.postgresql_14;
      ensureDatabases = [
        "matrix-synapse"
      ];
      ensureUsers = [
        { name = "matrix-synapse";
          ensurePermissions = {
            "DATABASE \"matrix-synapse\"" = "ALL PRIVILEGES";
            "ALL TABLES IN SCHEMA public" = "ALL PRIVILEGES";
          };
        }
      ];
    };
  };
}