Re: Akonadi-upgrade to postgres 17 fails

--nextPart3546280.LZWGnKmheA
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="utf-8"; protected-headers="v1"
From: Ingo =?UTF-8?B?S2zDtmNrZXI=?= <[email protected]>
To: [email protected]
Subject: Re: Akonadi-upgrade to postgres 17 fails
Date: Thu, 07 Aug 2025 11:09:36 +0200
Message-ID: <5705482.rdbgypaU67@daneel>
MIME-Version: 1.0

On Montag, 4. August 2025 07:39:11 Mitteleurop=C3=A4ische Sommerzeit Axel B=
raun=20
wrote:
> Good morning,
> I wanted to upgrade akonadi to pg 17, following
> https://userbase.kde.org/Akonadi/Postgres_update
>=20
> The first steps worked fine, the upgrade check fails:
>=20
> 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=C3=BChre Konsistenzpr=C3=BCf=
ungen durch
> -------------------------------
> Checking cluster versions                                     ok
>=20
> der alte Cluster verwendet keine Datenpr=C3=BCfsummen, aber der neue verw=
endet
> sie Fehlgeschlagen, Programm wird beendet
>=20
>=20
> Translation: The old cluster does not use checksums, the new one does.
>=20
> How can I work around this?

You need to remove the --data-checksums option from the initdb call to crea=
te=20
the new cluster without data checksums.

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

=46inally, if you want to use data checksums then you can enable data check=
sums=20
on the old cluster with the pg_checksums helper. Read the man page of=20
pg_checksums for details.

Regards,
Ingo

--nextPart3546280.LZWGnKmheA
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part.
Content-Transfer-Encoding: 7Bit

-----BEGIN PGP SIGNATURE-----

iHUEABYKAB0WIQTbjgIOMowwlCBgvyGxb1mVFkdKugUCaJRtUAAKCRCxb1mVFkdK
ukIGAQCI8YqFU3DySTnGvYjmg0vXm0llfdmC9DNliGWaGY3RYgD9F8zDzg8yFAyI
6v2WDB4dXj/KqWRiDjDdBrZOx4GR5gs=
=SOn+
-----END PGP SIGNATURE-----

--nextPart3546280.LZWGnKmheA--