aboutsummaryrefslogtreecommitdiff
path: root/hosts/sagittarius/web/mediadb.nix
diff options
context:
space:
mode:
Diffstat (limited to 'hosts/sagittarius/web/mediadb.nix')
-rw-r--r--hosts/sagittarius/web/mediadb.nix34
1 files changed, 17 insertions, 17 deletions
diff --git a/hosts/sagittarius/web/mediadb.nix b/hosts/sagittarius/web/mediadb.nix
index 67c9fdd..6627e50 100644
--- a/hosts/sagittarius/web/mediadb.nix
+++ b/hosts/sagittarius/web/mediadb.nix
@@ -7,29 +7,29 @@
let
newPostgres = pkgs.postgresql_18_jit;
cfg = config.services.postgresql;
- upgrade-pg-cluster = pkgs.writeScriptBin "upgrade-pg-cluster" ''
- set -eux
- systemctl stop 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 NEWDATA="/var/lib/postgresql/${newPostgres.psqlSchema}"
+ # export NEWBIN="${newPostgres}/bin"
- export OLDDATA="${cfg.dataDir}"
- export OLDBIN="${cfg.finalPackage}/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}
+ # 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" \
- "$@"
- '';
+ # sudo -u postgres "$NEWBIN/pg_upgrade" \
+ # --old-datadir "$OLDDATA" --new-datadir "$NEWDATA" \
+ # --old-bindir "$OLDBIN" --new-bindir "$NEWBIN" \
+ # "$@"
+ # '';
in
{
services.postgresql = {
- enable = true;
+ enable = false;
package = pkgs.postgresql_18_jit;
enableTCPIP = true;
enableJIT = true;
@@ -46,5 +46,5 @@ in
'';
}; # end of services.postgreslq
- environment.systemPackages = [ upgrade-pg-cluster ];
+ # environment.systemPackages = [ upgrade-pg-cluster ];
}