dots/hosts/luna/modules/services/postgresql.nix

{ config, pkgs, ... }:
let
  pg_dataDir_base = "/var/lib/postgresql";
in
{
  services.postgresqlBackup = {
    enable = true;
    location = "/var/backup/postgresql";
    backupAll = true;
  };

  services.postgresql = {
    enable = true;
    dataDir = "${pg_dataDir_base}/${config.services.postgresql.package.psqlSchema}";
    settings = {
      log_connections = true;
      log_disconnections = true;
      logging_collector = true;
      log_statement = "all";
    };
    ensureUsers = [
      {
        name = "root";
        ensureClauses.superuser = true;
      }
    ];
  };

  environment.systemPackages = [ pkgs.pgloader ];

  environment.persistence.save.directories = [
    {
      directory = "${pg_dataDir_base}";
      user = "postgres";
      group = "postgres";
    }
    {
      directory = config.services.postgresqlBackup.location;
      user = "postgres";
      group = "postgres";
    }
  ];
}