How To Install Pg_checksums On Debian, Ubuntu And Kali?

How To Install Pg_checksums On Debian, Ubuntu And Kali?

pg_checksums

Activate/deactivate/verify PostgreSQL data checksums

Maintainer: Debian PostgreSQL Maintainers



Section: database

Install pg_checksums

  • Debian apt-get install postgresql-11-pg-checksums Click to copy
  • Ubuntu apt-get install postgresql-11-pg-checksums Click to copy
  • Kali Linux apt-get install postgresql-11-pg-checksums Click to copy

postgresql-11-pg-checksums

Activate/deactivate/verify PostgreSQL data checksums

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 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 can verify the checksums in an offline cluster.

postgresql-10-pg-checksums

Activate/deactivate/verify PostgreSQL data checksums
Installing pg_checksums command is simple. just copy one of the above commands for your operating system and paste it into terminal. This command is available for Debian, Ubuntu and Kali operating systems. Once you run the command it will install the latest version of pg_checksums 2023 package in your OS.