Bug 507899

Summary: Akonadi-upgrade to postgres 17 fails
Product: [Frameworks and Libraries] Akonadi Reporter: Axel Braun <axel.braun>
Component: serverAssignee: kdepim bugs <kdepim-bugs>
Status: REPORTED ---    
Severity: normal CC: carl
Priority: NOR    
Version First Reported In: 6.4.3   
Target Milestone: ---   
Platform: Other   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description Axel Braun 2025-08-05 13:48:32 UTC
updating akonadi from postgresql 16 to 17 fails, as according to the new description in 
https://userbase.kde.org/Akonadi/Postgres_update
 the parameter --data-checksums is now set:

axel@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.
Aborted

trying to change this:

axel@southpole:~> /usr/lib/postgresql16/bin/pg_checksums --verbose --enable --pgdata=$HOME/.local/share/akonadi/db_data_16_checksum
pg_checksums: error: cluster is not compatible with this version of pg_checksums

And now?

Operating System: openSUSE Leap 16.0
KDE Plasma Version: 6.3.4
KDE Frameworks Version: 6.13.0
Qt Version: 6.9.1