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?
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@hotmail.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?