Unable to use pg_verify_checksums

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.

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.

Thank you Guillaume!

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