On Donnerstag, 1. November 2018 19:52:20 CET Sandro Knauß wrote: > Hey, > > > PostgreSQL 11 recently appeared in unstable. I upgraded from 10 to 11 an > > afterwards removed 10. And thereby rendered Akonadi unusable. Simply > > reinstalling version 10 fixed things for the time being. > > > > This left me wondering about the proper way to change an existing Akonadi > > DB to a newer PostgreSQL version. Is this meant to happen automatically > > or am I supposed to do it manually (some invocation of > > pg_upgradecluster)? > you have to run pg_ugprade manually after major upgrade.
Thanks for pointing this out. However, it's not as easy as *just* running pg_upgrade. Before that, the new cluster must be created with initdb Here's what I did in ~/.local/share/akonadi $ /usr/lib/postgresql/11/bin/initdb --data-checksums --locale=en_US.UTF-8 db_data $ /usr/lib/postgresql/11/bin/pg_upgrade --old-datadir db_data.old/ --new- datadir db_data/ --old-bindir /usr/lib/postgresql/10/bin --new-bindir /usr/ lib/postgresql/11/bin The options to initdb I found through trial and error, after a plain initdb did not create a suitable cluster, i.e. pg_upgrade complained about configuration mismatches between the old and the new cluster. Michael -- Michael Schuerig mailto:[email protected] http://www.schuerig.de/michael/
