Arch Linux

zoltix

Member

Registered: 2019-09-06

Posts: 22

[SOLVED] postgres: old cluster does not use data checksums but ....

Hello,

I’m upgrading PostgreSQL from 17 to 18 on Arch Linux.
I followed point 8.1 from the Arch Wiki page: https://wiki.archlinux.org/title/PostgreSQL
But

postgres@fhudbb-4-hel1-1 tmp]$ pg_upgrade -b /opt/pgsql-17/bin -B /usr/bin -d /var/lib/postgres/olddata -D /var/lib/postgres/data
Performing Consistency Checks
-----------------------------
Checking cluster versions                                     ok

old cluster does not use data checksums but the new one does
Failure, exiting
[postgres@fhudbb-4-hel1-1 tmp]$

Does anyone know the correct way to upgrade from PostgreSQL 17 → 18 on Arch Linux?

Thanks for any help.

Last edited by zoltix (2025-11-04 13:04:21)

ua4000

Member

Registered: 2015-10-14

Posts: 527

Re: [SOLVED] postgres: old cluster does not use data checksums but ....

https://www.postgresql.org/docs/current … ksums.html

To be safe, my proposal is to temporarily disable checksums on new db, then process the upgrade, then if all is ok, try to re-enable them on new db.
In case of fail, you have the old db untouched,

zoltix

Member

Registered: 2019-09-06

Posts: 22

Re: [SOLVED] postgres: old cluster does not use data checksums but ....

yes, I disabled it and .... big thanks
pg_checksums --disable --pgdata /var/lib/postgres/data