1 files changed, 50 insertions, 0 deletions

diff --git a/systems/zoldene/database.nix b/systems/zoldene/database.nix
new file mode 100644
index 0000000..2eb6cd9
--- /dev/null
+++ b/systems/zoldene/database.nix
@@ -0,0 +1,50 @@
+{ pkgs, config, lib, nodes, ... }:
+let
+  psqlVersion = pkgs.postgresql_16.psqlSchema;
+in
+{
+  disko.devices.zpool.zfast.datasets."root/persist/var/lib/postgresql" =
+    { type = "zfs_fs"; mountpoint = "/persist/zfast/var/lib/postgresql"; options.mountpoint = "legacy"; };
+  disko.devices.zpool.zfast.datasets."root/persist/var/lib/postgresql/${psqlVersion}" =
+    { type = "zfs_fs"; mountpoint = "/persist/zfast/var/lib/postgresql/${psqlVersion}"; options.mountpoint = "legacy"; };
+  environment.persistence."/persist/zfast".directories = [
+    {
+      directory = "/var/lib/postgresql";
+      user = config.users.users.postgres.name;
+      group = config.users.users.postgres.group;
+      mode = "0755";
+    }
+    {
+      directory = "/var/lib/postgresql/${psqlVersion}";
+      user = config.users.users.postgres.name;
+      group = config.users.users.postgres.group;
+      mode = "0755";
+    }
+  ];
+  systemd.services.postgresql.after = [
+    "var-lib-postgresql.mount"
+    "var-lib-postgresql-16.mount"
+    "persist-zfast-var-lib-postgresql.mount"
+    "persist-zfast-var-lib-postgresql-16.mount"
+  ];
+  systemd.services.postgresql.unitConfig = {
+    BindsTo = [
+      "var-lib-postgresql.mount"
+      "var-lib-postgresql-16.mount"
+      "persist-zfast-var-lib-postgresql.mount"
+      "persist-zfast-var-lib-postgresql-16.mount"
+    ];
+  };
+
+  services.postgresql = {
+    enable = true;
+    package = pkgs.postgresql_16;
+    settings.listen_addresses = lib.mkForce (builtins.concatStringsSep "," [
+      "localhost"
+      config.hostEnv.wireguard.ip
+    ]);
+    authentication = ''
+      host   replication   postgres   ${nodes.backup-2.config.hostEnv.wireguard.ip}/32   ident
+    '';
+  };
+}