Am Sonntag, 25. Oktober 2020, 21:01:06 CET schrieb Dominique Leuenberger:
postgresql (12.0.1 -> 13) postgresql13 (12.4 -> 13.0)
FYI, anybody using PG as akonadi backend, automatic migration failed here. My notes, that I follow to migrate manually: export OLD=12 export NEW=13 zyp in postgresql$NEW-contrib # stop akonadi akonadictl stop # move away old db mv $HOME/.local/share/akonadi/db_data $HOME/.local/share/akonadi/db_data_$OLD # create new db /usr/lib/postgresql$NEW/bin/initdb --pgdata=$HOME/.local/share/akonadi/db_data --locale=en_US.UTF-8 # check upgrade /usr/lib/postgresql$NEW/bin/pg_upgrade -b /usr/lib/postgresql$OLD/bin -B /usr/lib/postgresql$NEW/bin -d $HOME/.local/share/akonadi/db_data_$OLD -D $HOME/.local/share/akonadi/db_data --check # perform upgrade, if no issues /usr/lib/postgresql$NEW/bin/pg_upgrade -b /usr/lib/postgresql$OLD/bin -B /usr/lib/postgresql$NEW/bin -d $HOME/.local/share/akonadi/db_data_$OLD -D $HOME/.local/share/akonadi/db_data # start akonadi akonadictl start # check consistency akonadictl fsck # optionally run vacuum # fetch host/socket grep Host $HOME/.config/akonadi/akonadiserverrc /usr/lib/postgresql$NEW/bin/vacuumdb -h HOST --all --analyze # remove old database rm -r .local/share/akonadi/db_data_$OLD # finally clean up (unused) migration scripts rm analyze_new_cluster.sh delete_old_cluster.sh Hth anybody, Pete -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org