path: root/profiles/postgresql.nix

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

  environment.persistence."/persist/save".directories = [
    config.services.postgresqlBackup.location
  ];
}