Thread: Unable to use pg_verify_checksums
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'
I need help on this.
--
Shashidhar
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 errorpg_verify_checksums: data checksums are not enabled in clusterwhen 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:
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 errorpg_verify_checksums: data checksums are not enabled in clusterwhen 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.