Mailinglist Archive: opensuse-factory (339 mails)

< Previous Next >
[opensuse-factory] Postgres 13 as akonadi backend with Tumbleweed snapshot 20201024
  • From: Hans-Peter Jansen <hpj@xxxxxxxxx>
  • Date: Mon, 26 Oct 2020 17:16:49 +0100
  • Message-id: <34129102.Qiulii1yfz@xrated>
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@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse-factory+owner@xxxxxxxxxxxx

< Previous Next >