↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Versions

Enable/Disable page checksums in an offline cluster

Recorded source states and original language descriptions. Missing version evidence stays unknown.

The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.

Backup, Restore, & Data Integrity

Description

Page checksums can be enabled or disabled in an offline PostgreSQL cluster via the pg_checksums command:

https://www.postgresql.org/docs/12/app-pgchecksums.html

Selected version: PostgreSQL 18

Yes

20191817161514131211109.69.59.49.39.29.19.08.48.38.28.18.07.4
UnknownUnknownYesYesYesYesYesYesYesNoNoNoNoNoNoNoNoNoNoNoNoNoUnknownUnknown

Compare versions

Original documentation links

Recorded legacy identifiers: 328

Complete source facts and provenance

yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd

{
  "Key": "enabledisable-page-checksums-in-an-offline-cluster",
  "SourceKind": "yaml",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix.yaml",
  "SourceKey": "Enable/Disable page checksums in an offline cluster",
  "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
  "Name": "Enable/Disable page checksums in an offline cluster",
  "NameLocale": "en",
  "GroupKey": "backup-restore-data-integrity",
  "GroupName": "Backup, Restore, \u0026 Data Integrity",
  "GroupLocale": "en",
  "Ordinal": 2,
  "GroupOrder": 10,
  "Facts": {
    "feature": {
      "description": "Page checksums can be enabled or disabled in an offline PostgreSQL cluster via the pg_checksums command:\r\n\r\nhttps://www.postgresql.org/docs/12/app-pgchecksums.html",
      "name": "Enable/Disable page checksums in an offline cluster",
      "versions": {
        "12": "Yes"
      }
    },
    "group": "Backup, Restore, \u0026 Data Integrity",
    "versions": {
      "max": 18,
      "min": 8.1
    }
  },
  "Cells": [
    {
      "Version": "10",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "11",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "12",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "12",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "13",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "12",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "14",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "12",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "15",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "12",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "16",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "12",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "17",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "12",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "18",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "12",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "8.1",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "8.2",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "8.3",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "8.4",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.0",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.1",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.2",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.3",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.4",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.5",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.6",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    }
  ],
  "Texts": [
    {
      "Locale": "en",
      "Title": "Enable/Disable page checksums in an offline cluster",
      "BodyHTML": "\u003cp\u003ePage checksums can be enabled or disabled in an offline PostgreSQL cluster via the pg_checksums command:\u003c/p\u003e\n\u003cp\u003ehttps://www.postgresql.org/docs/12/app-pgchecksums.html\u003c/p\u003e\n",
      "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
      "ContentHash": "c0c00fcf3bbee8e667c152ee115443138639a395406533c56b685514fd60da44",
      "Payload": {
        "description": "Page checksums can be enabled or disabled in an offline PostgreSQL cluster via the pg_checksums command:\r\n\r\nhttps://www.postgresql.org/docs/12/app-pgchecksums.html",
        "name": "Enable/Disable page checksums in an offline cluster",
        "versions": {
          "12": "Yes"
        }
      }
    },
    {
      "Locale": "zh-Hans",
      "Title": "在离线集簇中启用/禁用页面校验和",
      "BodyHTML": "\u003cp\u003e可以通过 pg_checksums 命令在离线 PostgreSQL 集簇中启用或禁用页面校验和:\u003c/p\u003e\n\u003cp\u003ehttps://www.postgresql.org/docs/12/app-pgchecksums.html\u003c/p\u003e\n",
      "SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
      "ContentHash": "86c2429acd78037978b98ec7bf289d37ed266232974b4b5f75ee4552e69a6540",
      "Payload": {
        "description": "可以通过 pg_checksums 命令在离线 PostgreSQL 集簇中启用或禁用页面校验和:\n\nhttps://www.postgresql.org/docs/12/app-pgchecksums.html",
        "name": "在离线集簇中启用/禁用页面校验和"
      }
    }
  ],
  "GroupTitles": {
    "en": "Backup, Restore, \u0026 Data Integrity",
    "zh-Hans": "备份、恢复和数据完整性"
  },
  "LegacyIDs": [
    "328"
  ]
}

Complete source data JSON