From 46651ce6fe013220ed397add242004d764fc0153 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:15:05 +0200 Subject: Adding upstream version 14.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/checksums.html | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) create mode 100644 doc/src/sgml/html/checksums.html (limited to 'doc/src/sgml/html/checksums.html') diff --git a/doc/src/sgml/html/checksums.html b/doc/src/sgml/html/checksums.html new file mode 100644 index 0000000..1aabbde --- /dev/null +++ b/doc/src/sgml/html/checksums.html @@ -0,0 +1,25 @@ + +30.2. Data Checksums
30.2. Data Checksums
Prev UpChapter 30. Reliability and the Write-Ahead LogHome Next

30.2. Data Checksums

30.2.1. Off-line Enabling of Checksums

+ By default, data pages are not protected by checksums, but this can + optionally be enabled for a cluster. When enabled, each data page includes + a checksum that is updated when the page is written and verified each time + the page is read. Only data pages are protected by checksums; internal data + structures and temporary files are not. +

+ Checksums are normally enabled when the cluster is initialized using initdb. + They can also be enabled or disabled at a later time as an offline + operation. Data checksums are enabled or disabled at the full cluster + level, and cannot be specified individually for databases or tables. +

+ The current state of checksums in the cluster can be verified by viewing the + value of the read-only configuration variable data_checksums by issuing the command SHOW + data_checksums. +

+ When attempting to recover from page corruptions, it may be necessary to + bypass the checksum protection. To do this, temporarily set the + configuration parameter ignore_checksum_failure. +

30.2.1. Off-line Enabling of Checksums

+ The pg_checksums + application can be used to enable or disable data checksums, as well as + verify checksums, on an offline cluster. +

Prev Up Next
30.1. Reliability Home 30.3. Write-Ahead Logging (WAL)
\ No newline at end of file -- cgit v1.2.3