#!/usr/bin/env fish
set old_bin_dir /nix/store/qb1n72dfvwk2rjfqrqmw0ds5f9cfgr7y-postgresql-10.22/bin
set old_datadir ../.devenv/state/postgres
psql --version
pg_upgrade --version
devenv processes up --detach
devenv processes stop
pg_checksums --disable
pg_upgrade --old-bindir=$old_bin_dir \
  --old-datadir=$old_datadir \
  --new-datadir=.devenv/state/postgres
echo status was $status
pg_checksums --enable
devenv processes up --detach

# now running to recommended commands
vacuumdb --all --analyze-in-stages --missing-stats-only
vacuumdb --all --analyze-only