Can pg_checksums disable checksums enabled by initdb —data-checksums

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Can pg_checksums disable checksums enabled by initdb —data-checksums

Hotmail
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 
Reply | Threaded
Open this post in threaded view
|

Re: Can pg_checksums disable checksums enabled by initdb —data-checksums

Hotmail
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 <[hidden email]>, 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