Re: Unable to use pg_verify_checksums

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Unable to use pg_verify_checksums
Дата
Msg-id CAECtzeXJt=tU-zYeC4rmEC6Payvhm52G=E=JZGmWHVyy6Eoqdw@mail.gmail.com
обсуждение исходный текст
Ответ на Unable to use pg_verify_checksums  (shashidhar Reddy <shashidharreddy001@gmail.com>)
Ответы Re: Unable to use pg_verify_checksums  (shashidhar Reddy <shashidharreddy001@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi,

Le ven. 4 nov. 2022 à 07:12, shashidhar Reddy <shashidharreddy001@gmail.com> a écrit :
Hello,

I am using postgres version 11, in the process of upgrade using pg_upgrade I am trying to run checksums on version 11 but getting error

pg_verify_checksums: data checksums are not enabled in cluster

when trying to enable /pg_verify_checksums: unrecognized option '--enable'


Yeah, that's why it's called pg_verify_checksums: it only does a check of checksums, it can't enable checksums.


I need help on this.


Well, on v11, you need to initdb to enable checksums. So dump your databases, initdb with checksums, and then restore your databases.

Regards.


--
Guillaume.

В списке pgsql-general по дате отправления:

Предыдущее
От: ganggewang(王刚)
Дата:
Сообщение: How to avoid intstantiating multiple JVM instances across different sessions to use FDW?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: autovacuum hung on simple tables