Feature request: Check for data checksums in old postgres cluster

[zukka77]

I had to redo (cleaning up everithing leftover) the upgrade because my old postgres (version 16) used data checksums

------------------------------------
New database initialisation complete
------------------------------------
---------------------------------------
Running pg_upgrade command, from /var/lib/postgresql/data
---------------------------------------
Performing Consistency Checks
-----------------------------
Checking cluster versions                                     ok

old cluster uses data checksums but the new one does not
Failure, exiting

Starting pgautoupgrade with -e POSTGRES_INITDB_ARGS=-k solved the problem.

It would be great if the script could check if data checksums is enabled on the old cluster and use the correct parameter (-k) in the initdb command.

You can check if data checksum is on using show data_checksums

postgres=# show data_checksums ;
 data_checksums 
----------------
 on
(1 row)

[justinclift]

Oh, that's a very good idea. We should definitely do that.

Thanks for the suggestion @zukka77. 😄 Sorry for you having to redo your upgrade. 😦