Well, I’ve answered my own question with the documentation for postgres 12.
Additionally, PostgreSQL 12 can now enable or disable page checksums in an offline cluster using the pg_checksums command. Previously page checksums, a feature to help verify the integrity of data stored to disk, could only be enabled at the time a PostgreSQL cluster was initialized with initdb.
On Feb 27, 2020, 8:38 AM -0700, Hotmail <crajac66(at)hotmail(dot)com>, wrote:
> All,
>
> We are investigating the use of —data-checksums with initdb.
>
> My question is if a Postgres database is created with —data-checksums flag enabled with initdb is it possible to subsequently disable the checksums by shutting the database down and running disable with pg_checksums?
>
> Thanks,
>
> Craig Jackson