tower: set up postgres

1 files changed, 0 insertions, 50 deletions

diff --git a/hosts/tower/web/mediadb.nix b/hosts/tower/web/mediadb.nix
deleted file mode 100644
index 67c9fdd..0000000
--- a/hosts/tower/web/mediadb.nix
+++ /dev/null
@@ -1,50 +0,0 @@
-{
-  pkgs,
-  lib,
-  config,
-  ...
-}:
-let
-  newPostgres = pkgs.postgresql_18_jit;
-  cfg = config.services.postgresql;
-  upgrade-pg-cluster = pkgs.writeScriptBin "upgrade-pg-cluster" ''
-    set -eux
-    systemctl stop postgresql
-
-    export NEWDATA="/var/lib/postgresql/${newPostgres.psqlSchema}"
-    export NEWBIN="${newPostgres}/bin"
-
-    export OLDDATA="${cfg.dataDir}"
-    export OLDBIN="${cfg.finalPackage}/bin"
-
-    install -d -m 0700 -o postgres -g postgres "$NEWDATA"
-    cd "$NEWDATA"
-    sudo -u postgres "$NEWBIN/initdb" -D "$NEWDATA" ${lib.escapeShellArgs cfg.initdbArgs}
-
-    sudo -u postgres "$NEWBIN/pg_upgrade" \
-      --old-datadir "$OLDDATA" --new-datadir "$NEWDATA" \
-      --old-bindir "$OLDBIN" --new-bindir "$NEWBIN" \
-      "$@"
-  '';
-in
-{
-  services.postgresql = {
-    enable = true;
-    package = pkgs.postgresql_18_jit;
-    enableTCPIP = true;
-    enableJIT = true;
-
-    settings = {
-      password_encryption = "scram-sha-256";
-    };
-
-    authentication = ''
-      # TYPE  DATABASE  USER        ADDRESS  METHOD
-      local   all       all                  peer
-      host    all       postgres    all      reject
-      host    all       all         all      scram-sha-256
-    '';
-  }; # end of services.postgreslq
-
-  environment.systemPackages = [ upgrade-pg-cluster ];
-}