All Projects → credativ → pg_checksums

credativ / pg_checksums

Licence: other
Activate/deactivate/verify checksums in offline Postgres clusters

Programming Languages

perl
6916 projects
c
50402 projects - #5 most used programming language
Makefile
30231 projects

pg_checksums_ext - Activate/deactivate/verify checksums in PostgreSQL clusters

pg_checksums_ext is based on the pg_verify_checksums and pg_checksums programs available in PostgreSQL version 11 and from 12, respectively. It can verify, activate or deactivate checksums. Activating requires all database blocks to be read and all page headers to be updated, so can take a long time on a large database.

The database cluster needs to be shutdown cleanly in the case of checksum activation or deactivation, while checksum verification can be performed online, contrary to PostgreSQL's pg_checksums.

Other changes include the possibility to toggle progress reporting via the SIGUSR1 signal, more fine-grained progress reporting and I/O rate limiting.

PostgreSQL versions since 9.3 are supported, the November 8th 2018 PostgreSQL point release is required.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].