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
same issue on upgrade to pg18 note that --enable-checksums is now default setting of initdb, so if you want to see your mails you need to use --no-enable-checksums
PS: enabling checksums on the postgres18 cluster after conversion works at least
Axel, (not that I know anything about Postgres) do you have any thoughts on what needs to be done in akonadi itself? looking in the source code, I see references to the program `pg_upgrade` but no hits for "--check" I'm guessing you need us to change the command line invocation of `pg_upgrade` but I don't know what exactly.
Hello Allen, (In reply to Allen Winter from comment #3) > (not that I know anything about Postgres) > do you have any thoughts on what needs to be done in akonadi itself? Actually, I'm not a postgres expert either, just finding my way around.. > looking in the source code, I see references to the program `pg_upgrade` but > no hits for "--check" > I'm guessing you need us to change the command line invocation of > `pg_upgrade` but I don't know what exactly. I'm not even sure that akonadi can do something on that. Except maybe adding a hint regarding the checksums to the wiki (User Pat1 added the checksums already in Nov 2023 ). (In that context, just noticed that my bugs.k.o user does not work in the wiki, but thats a different action)
ok, once we have the wiki updated we can resolve this bug.