跳转到主要内容

pg_checksums

Activate/deactivate/verify checksums in offline Postgres clusters

pg_checksums : Activate/deactivate/verify checksums in offline Postgres clusters

Overview

ID Extension Package Version Category License Language
5110 pg_checksums pg_checksums 1.3 ADMIN BSD-2-Clause C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s---r No Yes No No yes no
Relationships
See Also amcheck pg_catcheck pg_orphaned pg_pathcheck pg_isok pg_surgery pageinspect pg_repack adminpack

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT PGDG 1.3 18 17 16 15 14 pg_checksums -
RPM PGDG 1.3 18 17 16 15 14 pg_checksums_$v -
DEB PGDG 1.3 18 17 16 15 14 postgresql-$v-pg-checksums -
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
el8.aarch64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
el9.x86_64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
el9.aarch64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
el10.x86_64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
el10.aarch64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
d12.x86_64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
d12.aarch64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
d13.x86_64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
d13.aarch64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
u22.x86_64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
u22.aarch64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
u24.x86_64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
u24.aarch64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
u26.x86_64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
u26.aarch64 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3 PGDG 1.3
Package Version OS ORG SIZE File URL
pg_checksums_18 1.3 el8.x86_64 pgdg 47.3 KiB pg_checksums_18-1.3-1PGDG.rhel8.x86_64.rpm
pg_checksums_18 1.3 el8.aarch64 pgdg 46.8 KiB pg_checksums_18-1.3-1PGDG.rhel8.aarch64.rpm
pg_checksums_18 1.3 el9.x86_64 pgdg 32.4 KiB pg_checksums_18-1.3-1PGDG.rhel9.8.x86_64.rpm
pg_checksums_18 1.3 el9.x86_64 pgdg 32.4 KiB pg_checksums_18-1.3-1PGDG.rhel9.x86_64.rpm
pg_checksums_18 1.3 el9.aarch64 pgdg 39.8 KiB pg_checksums_18-1.3-1PGDG.rhel9.8.aarch64.rpm
pg_checksums_18 1.3 el9.aarch64 pgdg 39.8 KiB pg_checksums_18-1.3-1PGDG.rhel9.aarch64.rpm
pg_checksums_18 1.3 el10.x86_64 pgdg 32.9 KiB pg_checksums_18-1.3-1PGDG.rhel10.2.x86_64.rpm
pg_checksums_18 1.3 el10.x86_64 pgdg 33.2 KiB pg_checksums_18-1.3-1PGDG.rhel10.x86_64.rpm
pg_checksums_18 1.3 el10.aarch64 pgdg 40.3 KiB pg_checksums_18-1.3-1PGDG.rhel10.2.aarch64.rpm
pg_checksums_18 1.3 el10.aarch64 pgdg 40.6 KiB pg_checksums_18-1.3-1PGDG.rhel10.aarch64.rpm
postgresql-18-pg-checksums 1.3 d12.x86_64 pgdg 36.8 KiB postgresql-18-pg-checksums_1.3-2.pgdg12+1_amd64.deb
postgresql-18-pg-checksums 1.3 d12.aarch64 pgdg 35.5 KiB postgresql-18-pg-checksums_1.3-2.pgdg12+1_arm64.deb
postgresql-18-pg-checksums 1.3 d13.x86_64 pgdg 37.1 KiB postgresql-18-pg-checksums_1.3-2.pgdg13+1_amd64.deb
postgresql-18-pg-checksums 1.3 d13.aarch64 pgdg 35.9 KiB postgresql-18-pg-checksums_1.3-2.pgdg13+1_arm64.deb
postgresql-18-pg-checksums 1.3 u22.x86_64 pgdg 37.9 KiB postgresql-18-pg-checksums_1.3-2.pgdg22.04+1_amd64.deb
postgresql-18-pg-checksums 1.3 u22.aarch64 pgdg 36.3 KiB postgresql-18-pg-checksums_1.3-2.pgdg22.04+1_arm64.deb
postgresql-18-pg-checksums 1.3 u24.x86_64 pgdg 36.8 KiB postgresql-18-pg-checksums_1.3-2.pgdg24.04+1_amd64.deb
postgresql-18-pg-checksums 1.3 u24.aarch64 pgdg 35.8 KiB postgresql-18-pg-checksums_1.3-2.pgdg24.04+1_arm64.deb
postgresql-18-pg-checksums 1.3 u26.x86_64 pgdg 37.3 KiB postgresql-18-pg-checksums_1.3-2.pgdg26.04+1_amd64.deb
postgresql-18-pg-checksums 1.3 u26.aarch64 pgdg 36.2 KiB postgresql-18-pg-checksums_1.3-2.pgdg26.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_checksums_17 1.3 el8.x86_64 pgdg 47.4 KiB pg_checksums_17-1.3-1PGDG.rhel8.x86_64.rpm
pg_checksums_17 1.3 el8.aarch64 pgdg 47.0 KiB pg_checksums_17-1.3-1PGDG.rhel8.aarch64.rpm
pg_checksums_17 1.3 el9.x86_64 pgdg 31.8 KiB pg_checksums_17-1.3-1PGDG.rhel9.8.x86_64.rpm
pg_checksums_17 1.3 el9.x86_64 pgdg 31.8 KiB pg_checksums_17-1.3-1PGDG.rhel9.x86_64.rpm
pg_checksums_17 1.3 el9.aarch64 pgdg 40.1 KiB pg_checksums_17-1.3-1PGDG.rhel9.8.aarch64.rpm
pg_checksums_17 1.3 el9.aarch64 pgdg 40.1 KiB pg_checksums_17-1.3-1PGDG.rhel9.aarch64.rpm
pg_checksums_17 1.3 el10.x86_64 pgdg 31.9 KiB pg_checksums_17-1.3-1PGDG.rhel10.2.x86_64.rpm
pg_checksums_17 1.3 el10.x86_64 pgdg 32.2 KiB pg_checksums_17-1.3-1PGDG.rhel10.x86_64.rpm
pg_checksums_17 1.3 el10.aarch64 pgdg 40.5 KiB pg_checksums_17-1.3-1PGDG.rhel10.2.aarch64.rpm
pg_checksums_17 1.3 el10.aarch64 pgdg 40.9 KiB pg_checksums_17-1.3-1PGDG.rhel10.aarch64.rpm
postgresql-17-pg-checksums 1.3 d12.x86_64 pgdg 36.4 KiB postgresql-17-pg-checksums_1.3-2.pgdg12+1_amd64.deb
postgresql-17-pg-checksums 1.3 d12.aarch64 pgdg 35.7 KiB postgresql-17-pg-checksums_1.3-2.pgdg12+1_arm64.deb
postgresql-17-pg-checksums 1.3 d13.x86_64 pgdg 36.7 KiB postgresql-17-pg-checksums_1.3-2.pgdg13+1_amd64.deb
postgresql-17-pg-checksums 1.3 d13.aarch64 pgdg 36.2 KiB postgresql-17-pg-checksums_1.3-2.pgdg13+1_arm64.deb
postgresql-17-pg-checksums 1.3 u22.x86_64 pgdg 37.5 KiB postgresql-17-pg-checksums_1.3-2.pgdg22.04+1_amd64.deb
postgresql-17-pg-checksums 1.3 u22.aarch64 pgdg 36.5 KiB postgresql-17-pg-checksums_1.3-2.pgdg22.04+1_arm64.deb
postgresql-17-pg-checksums 1.3 u24.x86_64 pgdg 36.4 KiB postgresql-17-pg-checksums_1.3-2.pgdg24.04+1_amd64.deb
postgresql-17-pg-checksums 1.3 u24.aarch64 pgdg 36.1 KiB postgresql-17-pg-checksums_1.3-2.pgdg24.04+1_arm64.deb
postgresql-17-pg-checksums 1.3 u26.x86_64 pgdg 37.0 KiB postgresql-17-pg-checksums_1.3-2.pgdg26.04+1_amd64.deb
postgresql-17-pg-checksums 1.3 u26.aarch64 pgdg 36.2 KiB postgresql-17-pg-checksums_1.3-2.pgdg26.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_checksums_16 1.3 el8.x86_64 pgdg 45.2 KiB pg_checksums_16-1.3-1PGDG.rhel8.x86_64.rpm
pg_checksums_16 1.1 el8.x86_64 pgdg 45.5 KiB pg_checksums_16-1.1-3PGDG.rhel8.x86_64.rpm
pg_checksums_16 1.3 el8.aarch64 pgdg 44.7 KiB pg_checksums_16-1.3-1PGDG.rhel8.aarch64.rpm
pg_checksums_16 1.1 el8.aarch64 pgdg 45.1 KiB pg_checksums_16-1.1-3PGDG.rhel8.aarch64.rpm
pg_checksums_16 1.3 el9.x86_64 pgdg 31.1 KiB pg_checksums_16-1.3-1PGDG.rhel9.8.x86_64.rpm
pg_checksums_16 1.3 el9.x86_64 pgdg 31.1 KiB pg_checksums_16-1.3-1PGDG.rhel9.x86_64.rpm
pg_checksums_16 1.1 el9.x86_64 pgdg 31.2 KiB pg_checksums_16-1.1-3PGDG.rhel9.x86_64.rpm
pg_checksums_16 1.3 el9.aarch64 pgdg 39.5 KiB pg_checksums_16-1.3-1PGDG.rhel9.8.aarch64.rpm
pg_checksums_16 1.3 el9.aarch64 pgdg 39.4 KiB pg_checksums_16-1.3-1PGDG.rhel9.aarch64.rpm
pg_checksums_16 1.1 el9.aarch64 pgdg 39.7 KiB pg_checksums_16-1.1-3PGDG.rhel9.aarch64.rpm
pg_checksums_16 1.3 el10.x86_64 pgdg 31.3 KiB pg_checksums_16-1.3-1PGDG.rhel10.2.x86_64.rpm
pg_checksums_16 1.3 el10.x86_64 pgdg 31.6 KiB pg_checksums_16-1.3-1PGDG.rhel10.x86_64.rpm
pg_checksums_16 1.2 el10.x86_64 pgdg 31.6 KiB pg_checksums_16-1.2-1PGDG.rhel10.x86_64.rpm
pg_checksums_16 1.3 el10.aarch64 pgdg 39.9 KiB pg_checksums_16-1.3-1PGDG.rhel10.2.aarch64.rpm
pg_checksums_16 1.3 el10.aarch64 pgdg 40.2 KiB pg_checksums_16-1.3-1PGDG.rhel10.aarch64.rpm
pg_checksums_16 1.2 el10.aarch64 pgdg 40.3 KiB pg_checksums_16-1.2-1PGDG.rhel10.aarch64.rpm
postgresql-16-pg-checksums 1.3 d12.x86_64 pgdg 34.3 KiB postgresql-16-pg-checksums_1.3-2.pgdg12+1_amd64.deb
postgresql-16-pg-checksums 1.3 d12.aarch64 pgdg 33.7 KiB postgresql-16-pg-checksums_1.3-2.pgdg12+1_arm64.deb
postgresql-16-pg-checksums 1.3 d13.x86_64 pgdg 34.7 KiB postgresql-16-pg-checksums_1.3-2.pgdg13+1_amd64.deb
postgresql-16-pg-checksums 1.3 d13.aarch64 pgdg 34.2 KiB postgresql-16-pg-checksums_1.3-2.pgdg13+1_arm64.deb
postgresql-16-pg-checksums 1.3 u22.x86_64 pgdg 35.6 KiB postgresql-16-pg-checksums_1.3-2.pgdg22.04+1_amd64.deb
postgresql-16-pg-checksums 1.3 u22.aarch64 pgdg 34.6 KiB postgresql-16-pg-checksums_1.3-2.pgdg22.04+1_arm64.deb
postgresql-16-pg-checksums 1.3 u24.x86_64 pgdg 34.5 KiB postgresql-16-pg-checksums_1.3-2.pgdg24.04+1_amd64.deb
postgresql-16-pg-checksums 1.3 u24.aarch64 pgdg 34.1 KiB postgresql-16-pg-checksums_1.3-2.pgdg24.04+1_arm64.deb
postgresql-16-pg-checksums 1.3 u26.x86_64 pgdg 35.1 KiB postgresql-16-pg-checksums_1.3-2.pgdg26.04+1_amd64.deb
postgresql-16-pg-checksums 1.3 u26.aarch64 pgdg 34.4 KiB postgresql-16-pg-checksums_1.3-2.pgdg26.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_checksums_15 1.3 el8.x86_64 pgdg 44.8 KiB pg_checksums_15-1.3-1PGDG.rhel8.x86_64.rpm
pg_checksums_15 1.1 el8.x86_64 pgdg 45.1 KiB pg_checksums_15-1.1-3PGDG.rhel8.x86_64.rpm
pg_checksums_15 1.1 el8.x86_64 pgdg 45.0 KiB pg_checksums_15-1.1-1.rhel8.x86_64.rpm
pg_checksums_15 1.3 el8.aarch64 pgdg 44.3 KiB pg_checksums_15-1.3-1PGDG.rhel8.aarch64.rpm
pg_checksums_15 1.1 el8.aarch64 pgdg 44.7 KiB pg_checksums_15-1.1-3PGDG.rhel8.aarch64.rpm
pg_checksums_15 1.1 el8.aarch64 pgdg 44.5 KiB pg_checksums_15-1.1-1.rhel8.aarch64.rpm
pg_checksums_15 1.3 el9.x86_64 pgdg 31.2 KiB pg_checksums_15-1.3-1PGDG.rhel9.8.x86_64.rpm
pg_checksums_15 1.3 el9.x86_64 pgdg 31.2 KiB pg_checksums_15-1.3-1PGDG.rhel9.x86_64.rpm
pg_checksums_15 1.1 el9.x86_64 pgdg 31.4 KiB pg_checksums_15-1.1-3PGDG.rhel9.x86_64.rpm
pg_checksums_15 1.1 el9.x86_64 pgdg 31.8 KiB pg_checksums_15-1.1-1.rhel9.x86_64.rpm
pg_checksums_15 1.3 el9.aarch64 pgdg 39.8 KiB pg_checksums_15-1.3-1PGDG.rhel9.8.aarch64.rpm
pg_checksums_15 1.3 el9.aarch64 pgdg 39.8 KiB pg_checksums_15-1.3-1PGDG.rhel9.aarch64.rpm
pg_checksums_15 1.1 el9.aarch64 pgdg 40.0 KiB pg_checksums_15-1.1-3PGDG.rhel9.aarch64.rpm
pg_checksums_15 1.1 el9.aarch64 pgdg 40.4 KiB pg_checksums_15-1.1-1.rhel9.aarch64.rpm
pg_checksums_15 1.3 el10.x86_64 pgdg 31.6 KiB pg_checksums_15-1.3-1PGDG.rhel10.2.x86_64.rpm
pg_checksums_15 1.3 el10.x86_64 pgdg 31.8 KiB pg_checksums_15-1.3-1PGDG.rhel10.x86_64.rpm
pg_checksums_15 1.2 el10.x86_64 pgdg 31.9 KiB pg_checksums_15-1.2-1PGDG.rhel10.x86_64.rpm
pg_checksums_15 1.3 el10.aarch64 pgdg 40.3 KiB pg_checksums_15-1.3-1PGDG.rhel10.2.aarch64.rpm
pg_checksums_15 1.3 el10.aarch64 pgdg 40.7 KiB pg_checksums_15-1.3-1PGDG.rhel10.aarch64.rpm
pg_checksums_15 1.2 el10.aarch64 pgdg 40.7 KiB pg_checksums_15-1.2-1PGDG.rhel10.aarch64.rpm
postgresql-15-pg-checksums 1.3 d12.x86_64 pgdg 34.0 KiB postgresql-15-pg-checksums_1.3-2.pgdg12+1_amd64.deb
postgresql-15-pg-checksums 1.3 d12.aarch64 pgdg 33.4 KiB postgresql-15-pg-checksums_1.3-2.pgdg12+1_arm64.deb
postgresql-15-pg-checksums 1.3 d13.x86_64 pgdg 34.4 KiB postgresql-15-pg-checksums_1.3-2.pgdg13+1_amd64.deb
postgresql-15-pg-checksums 1.3 d13.aarch64 pgdg 34.0 KiB postgresql-15-pg-checksums_1.3-2.pgdg13+1_arm64.deb
postgresql-15-pg-checksums 1.3 u22.x86_64 pgdg 35.2 KiB postgresql-15-pg-checksums_1.3-2.pgdg22.04+1_amd64.deb
postgresql-15-pg-checksums 1.3 u22.aarch64 pgdg 34.3 KiB postgresql-15-pg-checksums_1.3-2.pgdg22.04+1_arm64.deb
postgresql-15-pg-checksums 1.3 u24.x86_64 pgdg 34.2 KiB postgresql-15-pg-checksums_1.3-2.pgdg24.04+1_amd64.deb
postgresql-15-pg-checksums 1.3 u24.aarch64 pgdg 33.7 KiB postgresql-15-pg-checksums_1.3-2.pgdg24.04+1_arm64.deb
postgresql-15-pg-checksums 1.3 u26.x86_64 pgdg 34.8 KiB postgresql-15-pg-checksums_1.3-2.pgdg26.04+1_amd64.deb
postgresql-15-pg-checksums 1.3 u26.aarch64 pgdg 34.2 KiB postgresql-15-pg-checksums_1.3-2.pgdg26.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_checksums_14 1.3 el8.x86_64 pgdg 43.4 KiB pg_checksums_14-1.3-1PGDG.rhel8.x86_64.rpm
pg_checksums_14 1.1 el8.x86_64 pgdg 43.6 KiB pg_checksums_14-1.1-3PGDG.rhel8.x86_64.rpm
pg_checksums_14 1.1 el8.x86_64 pgdg 43.5 KiB pg_checksums_14-1.1-1.rhel8.x86_64.rpm
pg_checksums_14 1.3 el8.aarch64 pgdg 43.1 KiB pg_checksums_14-1.3-1PGDG.rhel8.aarch64.rpm
pg_checksums_14 1.1 el8.aarch64 pgdg 43.4 KiB pg_checksums_14-1.1-3PGDG.rhel8.aarch64.rpm
pg_checksums_14 1.1 el8.aarch64 pgdg 43.2 KiB pg_checksums_14-1.1-1.rhel8.aarch64.rpm
pg_checksums_14 1.3 el9.x86_64 pgdg 30.9 KiB pg_checksums_14-1.3-1PGDG.rhel9.8.x86_64.rpm
pg_checksums_14 1.3 el9.x86_64 pgdg 30.8 KiB pg_checksums_14-1.3-1PGDG.rhel9.x86_64.rpm
pg_checksums_14 1.1 el9.x86_64 pgdg 31.0 KiB pg_checksums_14-1.1-3PGDG.rhel9.x86_64.rpm
pg_checksums_14 1.1 el9.x86_64 pgdg 31.3 KiB pg_checksums_14-1.1-1.rhel9.x86_64.rpm
pg_checksums_14 1.3 el9.aarch64 pgdg 39.5 KiB pg_checksums_14-1.3-1PGDG.rhel9.8.aarch64.rpm
pg_checksums_14 1.3 el9.aarch64 pgdg 39.5 KiB pg_checksums_14-1.3-1PGDG.rhel9.aarch64.rpm
pg_checksums_14 1.1 el9.aarch64 pgdg 39.7 KiB pg_checksums_14-1.1-3PGDG.rhel9.aarch64.rpm
pg_checksums_14 1.1 el9.aarch64 pgdg 40.1 KiB pg_checksums_14-1.1-1.rhel9.aarch64.rpm
pg_checksums_14 1.3 el10.x86_64 pgdg 31.2 KiB pg_checksums_14-1.3-1PGDG.rhel10.2.x86_64.rpm
pg_checksums_14 1.3 el10.x86_64 pgdg 31.6 KiB pg_checksums_14-1.3-1PGDG.rhel10.x86_64.rpm
pg_checksums_14 1.2 el10.x86_64 pgdg 31.5 KiB pg_checksums_14-1.2-1PGDG.rhel10.x86_64.rpm
pg_checksums_14 1.3 el10.aarch64 pgdg 40.0 KiB pg_checksums_14-1.3-1PGDG.rhel10.2.aarch64.rpm
pg_checksums_14 1.3 el10.aarch64 pgdg 40.3 KiB pg_checksums_14-1.3-1PGDG.rhel10.aarch64.rpm
pg_checksums_14 1.2 el10.aarch64 pgdg 40.4 KiB pg_checksums_14-1.2-1PGDG.rhel10.aarch64.rpm
postgresql-14-pg-checksums 1.3 d12.x86_64 pgdg 33.9 KiB postgresql-14-pg-checksums_1.3-2.pgdg12+1_amd64.deb
postgresql-14-pg-checksums 1.3 d12.aarch64 pgdg 33.3 KiB postgresql-14-pg-checksums_1.3-2.pgdg12+1_arm64.deb
postgresql-14-pg-checksums 1.3 d13.x86_64 pgdg 34.1 KiB postgresql-14-pg-checksums_1.3-2.pgdg13+1_amd64.deb
postgresql-14-pg-checksums 1.3 d13.aarch64 pgdg 33.7 KiB postgresql-14-pg-checksums_1.3-2.pgdg13+1_arm64.deb
postgresql-14-pg-checksums 1.3 u22.x86_64 pgdg 34.8 KiB postgresql-14-pg-checksums_1.3-2.pgdg22.04+1_amd64.deb
postgresql-14-pg-checksums 1.3 u22.aarch64 pgdg 33.9 KiB postgresql-14-pg-checksums_1.3-2.pgdg22.04+1_arm64.deb
postgresql-14-pg-checksums 1.3 u24.x86_64 pgdg 34.1 KiB postgresql-14-pg-checksums_1.3-2.pgdg24.04+1_amd64.deb
postgresql-14-pg-checksums 1.3 u24.aarch64 pgdg 33.7 KiB postgresql-14-pg-checksums_1.3-2.pgdg24.04+1_arm64.deb
postgresql-14-pg-checksums 1.3 u26.x86_64 pgdg 34.6 KiB postgresql-14-pg-checksums_1.3-2.pgdg26.04+1_amd64.deb
postgresql-14-pg-checksums 1.3 u26.aarch64 pgdg 34.0 KiB postgresql-14-pg-checksums_1.3-2.pgdg26.04+1_arm64.deb

Source

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

pig install pg_checksums;		# install via package name, for the active PG version

pig install pg_checksums -v 18;   # install for PG 18
pig install pg_checksums -v 17;   # install for PG 17
pig install pg_checksums -v 16;   # install for PG 16
pig install pg_checksums -v 15;   # install for PG 15
pig install pg_checksums -v 14;   # install for PG 14

This extension does not need CREATE EXTENSION DDL command

Usage

pg_checksums: Activate/deactivate/verify checksums in offline Postgres clusters

pg_checksums_ext is a command-line tool (based on PostgreSQL’s built-in pg_checksums) that can verify, activate, or deactivate page-level checksums for a PostgreSQL cluster. It extends the built-in tool with online verification, SIGUSR1 progress toggling, fine-grained progress reporting, and I/O rate limiting.

Verify Checksums (can be done online) 

pg_checksums_ext -D /path/to/data --check

Enable Checksums (requires clean shutdown) 

pg_checksums_ext -D /path/to/data --enable

Disable Checksums (requires clean shutdown) 

pg_checksums_ext -D /path/to/data --disable

Additional Options

  • -D, --pgdata – data directory path
  • --check / --enable / --disable – operation mode
  • --progress – show progress reporting
  • --filenode – check only a specific filenode
  • --no-sync – skip fsync
  • --verbose – verbose output
  • --debug – debug output
  • Send SIGUSR1 to toggle progress reporting during operation