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

Поиск
Список
Период
Сортировка
Искать
От
Hotmail
Тема
Re: Can pg_checksums disable checksums enabled by initdb—data-checksums
Дата
Msg-id
BYAPR06MB4023513D1FCAE0D05F51523CD7EB0@BYAPR06MB4023.namprd06.prod.outlook.com
Ответ на
Список
Дерево обсуждения
Can pg_checksums disable checksums enabled by initdb—data-checksums Hotmail <crajac66@hotmail.com>
Re: Can pg_checksums disable checksums enabled by initdb—data-checksums Hotmail <crajac66@hotmail.com>
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 
В списке pgsql-admin по дате отправления
От: S.Bob
Дата:
Сообщение: Re: pgbadger question
От: Madeline Cummins
Дата:
Сообщение: Re: test
FAQ