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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx>, 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 

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux