Re: Unable to use pg_verify_checksums

[shashidhar Reddy <shashidharreddy001@xxxxxxxxx>]

Thank you Guillaume!

On Fri, 4 Nov, 2022, 12:49 pm Guillaume Lelarge, <guillaume@xxxxxxxxxxxx> wrote:

Hi,

Le ven. 4 nov. 2022 à 07:12, shashidhar Reddy <shashidharreddy001@xxxxxxxxx> 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.

Look at https://www.postgresql.org/docs/11/pgverifychecksums.html, there's no --enable option.

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.