Thread: Can pg_checksums disable checksums enabled by initdb—data-checksums
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
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?Thanks,Craig Jackson