postgresql-15-pg-checksums

Activate/deactivate/verify PostgreSQL data checksums

Description

Data checksums allow the PostgreSQL database server to identify I/O failures when reading data from storage. The checksums stored in the page header of each data page are compared to the computed checksum of the read data.

Data checksums need to be activated at instance creation time, all current versions of PostgreSQL including v11 do not allow activating (or deactivating) checksums afterwards.

pg_checksums_ext can activate or deactivate data checksums as long at the database cluster is shutdown cleanly. Activating checksums requires all database blocks to be read and all page headers to be updated, so can take a long time on a large database. Deactivating checksums only requires the cluster control file to be updated so is quick.

In addition, pg_checksums_ext can verify the checksums in an online cluster.

Upload more screenshots

Please help extend the collection of screenshots. Just make a screenshot and upload it here. You don't need to register or anything.

Upload a screenshot

Hint: upload an image here from your clipboard with Ctrl-V


Homepage

https://github.com/credativ/pg_checksums


Install this software package

If the package is available for the distribution you are currently using on your computer then install the software by clicking on…

Install postgresql-15-pg-checksums