postgresql.nix

{ modulesPath, pkgs, lib, config, ... }:
let
  db_name = "<name>";
  db_user = "<user>";
in
{
  services.postgresql =
    {
      enable = true;
      package = pkgs.postgresql_13;
      ensureDatabases = [ db_name ];
      authentication = pkgs.lib.mkOverride 10 ''
        local all all trust
        host all all 127.0.0.1/32 trust
        host all all ::1/128 trust
      '';
      ensureUsers = [
        {
          name = db_user;
          ensurePermissions = { "DATABASE ${db_name}" = "ALL PRIVILEGES"; };
        }
      ];
    };
}