Re: Akonadi: upgrading to PostgreSQL 11
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:michael@schuerig.de
http://www.schuerig.de/michael/
Reply to: