aboutsummaryrefslogtreecommitdiff
path: root/hosts/tower/web
diff options
context:
space:
mode:
Diffstat (limited to 'hosts/tower/web')
-rw-r--r--hosts/tower/web/default.nix1
-rw-r--r--hosts/tower/web/mediadb.nix50
2 files changed, 0 insertions, 51 deletions
diff --git a/hosts/tower/web/default.nix b/hosts/tower/web/default.nix
index 9a68dc8..13ec615 100644
--- a/hosts/tower/web/default.nix
+++ b/hosts/tower/web/default.nix
@@ -2,7 +2,6 @@
{
imports = [
# ./blog.nix
- # ./mediadb.nix
./git.nix
# ./static.nix
# ./navidrome.nix
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 ];
-}