Akonadi-upgrade to postgres 17 fails

[Ingo Klöcker]

On Montag, 4. August 2025 07:39:11 Mitteleuropäische Sommerzeit Axel Braun 
wrote:
> Good morning,
> I wanted to upgrade akonadi to pg 17, following
> https://userbase.kde.org/Akonadi/Postgres_update
> 
> The first steps worked fine, the upgrade check fails:
> 
> axel at southpole:~> /usr/lib/postgresql17/bin/pg_upgrade -b
> /usr/lib/postgresql16/bin -B /usr/lib/postgresql17/bin -d
> $HOME/.local/share/akonadi/db_data_old -D
> $HOME/.local/share/akonadi/db_data --check Führe Konsistenzprüfungen durch
> -------------------------------
> Checking cluster versions                                     ok
> 
> der alte Cluster verwendet keine Datenprüfsummen, aber der neue verwendet
> sie Fehlgeschlagen, Programm wird beendet
> 
> 
> Translation: The old cluster does not use checksums, the new one does.
> 
> How can I work around this?

You need to remove the --data-checksums option from the initdb call to create 
the new cluster without data checksums.

Alternatively, disable data checksums in the already created new cluster with
/usr/lib/postgresql17/bin/pg_checksums -d -D $HOME/.local/share/akonadi/
db_data

Finally, if you want to use data checksums then you can enable data checksums 
on the old cluster with the pg_checksums helper. Read the man page of 
pg_checksums for details.

Regards,
Ingo
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20250807/d921608a/attachment.sig>