0x697004 / Lucy (@void)

bash script ; indirect advice

@root
frequently dumping our db and re-init a new one cause this one here fucks around on a beta branch

in your case: would disable the database service and prepare all folders and adjust the script accordingly

#!/usr/bin/env bash
set -euo pipefail

old_db_home=/usr/bin/postgres17/
new_db_home=/usr/bin/postgres18/

old_db=/var/lib/postgres/17
new_db=/var/lib/postgres/18

sudo -u postgres ${old_db_home}/bin/pg_ctl start -D $old_db -o "-p 5433 -k /tmp" -l /tmp/old-pg.log
sudo -u postgres ${old_db_home}/bin/pg_dumpall -D $old_db -p 5433 -h /tmp > /tmp/all.sql
sudo -u postgres ${old_db_home}/bin/pg_ctl -D $old_db stop

sudo -u postgres ${new_db_home}/bin/initdb -D $new_db
sudo -u postgres ${new_db_home}/bin/pg_ctl start -D $new_db -o "-p 5432 -k /tmp" -l /tmp/new-pg.log
sudo -u postgres ${new_db_home}/bin/psql -p 5432 -f /tmp/all.sql postgres
sudo -u postgres ${new_db_home}/bin/vacuumdb -h /tmp -p 5432 --all --analyze-in-stages
sudo -u postgres ${new_db_home}/bin/pg_ctl -D $old_db stop

this is just a vague imagination of this one here on how it'd probably look on fedora

pg_repack exists for both 17, 18 and even 19
github.com/reorg/pg_repack/blob/master/doc/pg_repack.rst#requirements