Postgres Pro
Downloads
Home   >   mailing lists

Re: Unable to use pg_verify_checksums - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Unable to use pg_verify_checksums
Date
Msg-id CAECtzeXJt=tU-zYeC4rmEC6Payvhm52G=E=JZGmWHVyy6Eoqdw@mail.gmail.com
Whole thread Raw
In response to Unable to use pg_verify_checksums  (shashidhar Reddy <shashidharreddy001@gmail.com>)
Responses Re: Unable to use pg_verify_checksums  (shashidhar Reddy <shashidharreddy001@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: ganggewang(王刚)
Date:
Subject: How to avoid intstantiating multiple JVM instances across different sessions to use FDW?
Next
From: Laurenz Albe
Date:
Subject: Re: autovacuum hung on simple tables