{
    "api_version": "1",
    "kind": "dse_post",
    "self": "https://update.dsesecurity.com/api/v1/posts/coordinate-postgresql-checksum-changes-across-the-replication-set/",
    "item": {
        "id": "https://update.dsesecurity.com/updates/coordinate-postgresql-checksum-changes-across-the-replication-set/",
        "slug": "coordinate-postgresql-checksum-changes-across-the-replication-set",
        "url": "https://update.dsesecurity.com/updates/coordinate-postgresql-checksum-changes-across-the-replication-set/",
        "alternate_urls": {
            "markdown": "https://update.dsesecurity.com/updates/coordinate-postgresql-checksum-changes-across-the-replication-set.md",
            "json": "https://update.dsesecurity.com/api/v1/posts/coordinate-postgresql-checksum-changes-across-the-replication-set/"
        },
        "title": "Coordinate PostgreSQL checksum changes across the replication set",
        "summary": "Plan offline checksum changes as one coordinated operation across the PostgreSQL replication set.",
        "format": {
            "slug": "guide",
            "name": "Guide"
        },
        "priority": {
            "slug": "info",
            "name": "Information"
        },
        "featured": false,
        "image": {
            "theme": "continuity-recovery",
            "label": "Continuity & recovery",
            "alt": "Paired infrastructure paths converging on a stable recovered service.",
            "card_url": "https://update.dsesecurity.com/assets/editorial/continuity-recovery-card.webp?v=1.8.20",
            "hero_url": "https://update.dsesecurity.com/assets/editorial/continuity-recovery-hero.webp?v=1.8.20",
            "social_url": "https://update.dsesecurity.com/assets/editorial/continuity-recovery-social-v2.jpg?v=1.8.20",
            "width": 2400,
            "height": 1350
        },
        "topics": [
            {
                "slug": "business-continuity",
                "name": "Business Continuity",
                "url": "https://update.dsesecurity.com/topic/business-continuity/"
            },
            {
                "slug": "it",
                "name": "IT",
                "url": "https://update.dsesecurity.com/topic/it/"
            }
        ],
        "author": {
            "name": "DSE Security Editorial Team",
            "url": "https://update.dsesecurity.com/#editorial-team",
            "type": "Organization"
        },
        "publisher": {
            "name": "Detection Systems & Engineering",
            "url": "https://dsesecurity.com/"
        },
        "published_at": "2026-10-15T13:32:39+00:00",
        "modified_at": "2026-10-15T13:36:15+00:00",
        "reviewed_on": "2026-10-15",
        "reading_minutes": 2,
        "word_count": 246,
        "potentially_affected": "This applies to PostgreSQL 17 offline checksum administration. It concerns a cluster-wide storage-format decision, not the separate manifest checks performed by pg_verifybackup on backup artifacts.",
        "dse_recommendation": "DSE recommends planning checksum changes as a coordinated maintenance event with an explicit node inventory.",
        "primary_source": {
            "name": "PostgreSQL 17 — pg_checksums",
            "url": "https://www.postgresql.org/docs/17/app-pgchecksums.html",
            "published_on": null,
            "authority": "www.postgresql.org"
        },
        "publishing_principles": "https://update.dsesecurity.com/updates/dse-updates-editorial-methodology/",
        "usage_info": "https://update.dsesecurity.com/usage/",
        "copyright_notice": "Copyright © 2026 Detection Systems & Engineering. All rights reserved.",
        "content_html": "<p>Plan offline checksum changes as one coordinated operation across the PostgreSQL replication set.</p>\n<h2>Source facts</h2>\n<p>PostgreSQL 17 pg_checksums requires a server that has been cleanly shut down to check, enable, or disable data checksums. Enabling rewrites changed checksums in relation blocks; the cluster and other writers must remain stopped during that operation. For replication arrangements that directly copy relation blocks, such as pg_rewind, inconsistent checksum settings across nodes can lead to incorrect checksums. The documentation recommends changing all stopped clusters consistently or rebuilding standbys after changing the primary.</p>\n<p>Source: <a href=\"https://www.postgresql.org/docs/17/app-pgchecksums.html\">PostgreSQL 17 — pg_checksums</a>.</p>\n<h2>Applicability</h2>\n<p>This applies to PostgreSQL 17 offline checksum administration. It concerns a cluster-wide storage-format decision, not the separate manifest checks performed by pg_verifybackup on backup artifacts.</p>\n<h2>DSE recommendation</h2>\n<p>DSE recommends planning checksum changes as a coordinated maintenance event with an explicit node inventory. Record each node&#8217;s current setting, shutdown verification, the selected consistency strategy, and a restart order. Preserve the recovery prerequisites before modifying files. Assign one owner to confirm the entire replication set has reached the intended state, including any temporarily absent standby. Do not allow automation to restart a node while the offline operation or consistency checks remain incomplete.</p>\n<h2>Verification</h2>\n<p>Rehearse the selected strategy on disposable primary and standby clusters. Confirm clean shutdown, retain tool exit status and output, then verify settings and replication after restart or standby rebuild. Include a check that no unreviewed writer accessed the data directories during the offline work.</p>\n<h2>Official reference</h2>\n<p><a href=\"https://www.postgresql.org/docs/17/app-pgchecksums.html\">PostgreSQL 17 — pg_checksums</a>. Reviewed October 15, 2026.</p>",
        "content_text": "Plan offline checksum changes as one coordinated operation across the PostgreSQL replication set.\nSource facts\nPostgreSQL 17 pg_checksums requires a server that has been cleanly shut down to check, enable, or disable data checksums. Enabling rewrites changed checksums in relation blocks; the cluster and other writers must remain stopped during that operation. For replication arrangements that directly copy relation blocks, such as pg_rewind, inconsistent checksum settings across nodes can lead to incorrect checksums. The documentation recommends changing all stopped clusters consistently or rebuilding standbys after changing the primary.\nSource: PostgreSQL 17 — pg_checksums.\nApplicability\nThis applies to PostgreSQL 17 offline checksum administration. It concerns a cluster-wide storage-format decision, not the separate manifest checks performed by pg_verifybackup on backup artifacts.\nDSE recommendation\nDSE recommends planning checksum changes as a coordinated maintenance event with an explicit node inventory. Record each node’s current setting, shutdown verification, the selected consistency strategy, and a restart order. Preserve the recovery prerequisites before modifying files. Assign one owner to confirm the entire replication set has reached the intended state, including any temporarily absent standby. Do not allow automation to restart a node while the offline operation or consistency checks remain incomplete.\nVerification\nRehearse the selected strategy on disposable primary and standby clusters. Confirm clean shutdown, retain tool exit status and output, then verify settings and replication after restart or standby rebuild. Include a check that no unreviewed writer accessed the data directories during the offline work.\nOfficial reference\nPostgreSQL 17 — pg_checksums. Reviewed October 15, 2026.",
        "content_markdown": "Plan offline checksum changes as one coordinated operation across the PostgreSQL replication set.\n\n## Source facts\n\nPostgreSQL 17 pg_checksums requires a server that has been cleanly shut down to check, enable, or disable data checksums. Enabling rewrites changed checksums in relation blocks; the cluster and other writers must remain stopped during that operation. For replication arrangements that directly copy relation blocks, such as pg_rewind, inconsistent checksum settings across nodes can lead to incorrect checksums. The documentation recommends changing all stopped clusters consistently or rebuilding standbys after changing the primary.\n\nSource: [PostgreSQL 17 — pg_checksums](https://www.postgresql.org/docs/17/app-pgchecksums.html).\n\n## Applicability\n\nThis applies to PostgreSQL 17 offline checksum administration. It concerns a cluster-wide storage-format decision, not the separate manifest checks performed by pg_verifybackup on backup artifacts.\n\n## DSE recommendation\n\nDSE recommends planning checksum changes as a coordinated maintenance event with an explicit node inventory. Record each node’s current setting, shutdown verification, the selected consistency strategy, and a restart order. Preserve the recovery prerequisites before modifying files. Assign one owner to confirm the entire replication set has reached the intended state, including any temporarily absent standby. Do not allow automation to restart a node while the offline operation or consistency checks remain incomplete.\n\n## Verification\n\nRehearse the selected strategy on disposable primary and standby clusters. Confirm clean shutdown, retain tool exit status and output, then verify settings and replication after restart or standby rebuild. Include a check that no unreviewed writer accessed the data directories during the offline work.\n\n## Official reference\n\n[PostgreSQL 17 — pg_checksums](https://www.postgresql.org/docs/17/app-pgchecksums.html). Reviewed October 15, 2026."
    },
    "json_ld": {
        "@context": "https://schema.org",
        "@graph": [
            {
                "@type": "Organization",
                "@id": "https://dsesecurity.com/#organization",
                "name": "Detection Systems & Engineering",
                "alternateName": "DSE Security",
                "url": "https://dsesecurity.com/",
                "logo": {
                    "@type": "ImageObject",
                    "url": "https://update.dsesecurity.com/assets/dse-logo-20260812.png?v=1.8.20"
                }
            },
            {
                "@type": "Organization",
                "@id": "https://update.dsesecurity.com/#editorial-team",
                "name": "DSE Security Editorial Team",
                "url": "https://update.dsesecurity.com/",
                "parentOrganization": {
                    "@id": "https://dsesecurity.com/#organization"
                }
            },
            {
                "@type": "WebSite",
                "@id": "https://update.dsesecurity.com/#website",
                "name": "DSE Updates",
                "alternateName": "DSE Security Knowledge Hub",
                "url": "https://update.dsesecurity.com/",
                "inLanguage": "en-US",
                "publisher": {
                    "@id": "https://dsesecurity.com/#organization"
                },
                "potentialAction": {
                    "@type": "SearchAction",
                    "target": {
                        "@type": "EntryPoint",
                        "urlTemplate": "https://update.dsesecurity.com/?q={search_term_string}"
                    },
                    "query-input": "required name=search_term_string"
                }
            },
            {
                "@type": "WebPage",
                "@id": "https://update.dsesecurity.com/updates/coordinate-postgresql-checksum-changes-across-the-replication-set/",
                "url": "https://update.dsesecurity.com/updates/coordinate-postgresql-checksum-changes-across-the-replication-set/",
                "isPartOf": {
                    "@id": "https://update.dsesecurity.com/#website"
                },
                "lastReviewed": "2026-10-15"
            },
            {
                "@type": "BreadcrumbList",
                "@id": "https://update.dsesecurity.com/updates/coordinate-postgresql-checksum-changes-across-the-replication-set/#breadcrumbs",
                "itemListElement": [
                    {
                        "@type": "ListItem",
                        "position": 1,
                        "name": "DSE Updates",
                        "item": "https://update.dsesecurity.com/"
                    },
                    {
                        "@type": "ListItem",
                        "position": 2,
                        "name": "Coordinate PostgreSQL checksum changes across the replication set",
                        "item": "https://update.dsesecurity.com/updates/coordinate-postgresql-checksum-changes-across-the-replication-set/"
                    }
                ]
            },
            {
                "@type": [
                    "Article",
                    "TechArticle"
                ],
                "@id": "https://update.dsesecurity.com/updates/coordinate-postgresql-checksum-changes-across-the-replication-set/#article",
                "identifier": "https://update.dsesecurity.com/updates/coordinate-postgresql-checksum-changes-across-the-replication-set/",
                "url": "https://update.dsesecurity.com/updates/coordinate-postgresql-checksum-changes-across-the-replication-set/",
                "headline": "Coordinate PostgreSQL checksum changes across the replication set",
                "description": "Plan offline checksum changes as one coordinated operation across the PostgreSQL replication set.",
                "abstract": "Plan offline checksum changes as one coordinated operation across the PostgreSQL replication set.",
                "articleBody": "Plan offline checksum changes as one coordinated operation across the PostgreSQL replication set.\nSource facts\nPostgreSQL 17 pg_checksums requires a server that has been cleanly shut down to check, enable, or disable data checksums. Enabling rewrites changed checksums in relation blocks; the cluster and other writers must remain stopped during that operation. For replication arrangements that directly copy relation blocks, such as pg_rewind, inconsistent checksum settings across nodes can lead to incorrect checksums. The documentation recommends changing all stopped clusters consistently or rebuilding standbys after changing the primary.\nSource: PostgreSQL 17 — pg_checksums.\nApplicability\nThis applies to PostgreSQL 17 offline checksum administration. It concerns a cluster-wide storage-format decision, not the separate manifest checks performed by pg_verifybackup on backup artifacts.\nDSE recommendation\nDSE recommends planning checksum changes as a coordinated maintenance event with an explicit node inventory. Record each node’s current setting, shutdown verification, the selected consistency strategy, and a restart order. Preserve the recovery prerequisites before modifying files. Assign one owner to confirm the entire replication set has reached the intended state, including any temporarily absent standby. Do not allow automation to restart a node while the offline operation or consistency checks remain incomplete.\nVerification\nRehearse the selected strategy on disposable primary and standby clusters. Confirm clean shutdown, retain tool exit status and output, then verify settings and replication after restart or standby rebuild. Include a check that no unreviewed writer accessed the data directories during the offline work.\nOfficial reference\nPostgreSQL 17 — pg_checksums. Reviewed October 15, 2026.",
                "datePublished": "2026-10-15T13:32:39+00:00",
                "dateModified": "2026-10-15T13:36:15+00:00",
                "mainEntityOfPage": {
                    "@id": "https://update.dsesecurity.com/updates/coordinate-postgresql-checksum-changes-across-the-replication-set/"
                },
                "inLanguage": "en-US",
                "isAccessibleForFree": true,
                "author": {
                    "@type": "Organization",
                    "name": "DSE Security Editorial Team",
                    "url": "https://update.dsesecurity.com/#editorial-team"
                },
                "publisher": {
                    "@id": "https://dsesecurity.com/#organization"
                },
                "image": {
                    "@type": "ImageObject",
                    "@id": "https://update.dsesecurity.com/updates/coordinate-postgresql-checksum-changes-across-the-replication-set/#primaryimage",
                    "url": "https://update.dsesecurity.com/assets/editorial/continuity-recovery-social-v2.jpg?v=1.8.20",
                    "contentUrl": "https://update.dsesecurity.com/assets/editorial/continuity-recovery-social-v2.jpg?v=1.8.20",
                    "width": 1200,
                    "height": 630,
                    "caption": "Coordinate PostgreSQL checksum changes across the replication set"
                },
                "articleSection": [
                    "Business Continuity",
                    "IT"
                ],
                "keywords": [
                    "Business Continuity",
                    "IT",
                    "Guide",
                    "Information priority"
                ],
                "genre": "Guide",
                "about": [
                    {
                        "@type": "Thing",
                        "name": "Business Continuity",
                        "url": "https://update.dsesecurity.com/topic/business-continuity/"
                    },
                    {
                        "@type": "Thing",
                        "name": "IT",
                        "url": "https://update.dsesecurity.com/topic/it/"
                    }
                ],
                "wordCount": 246,
                "timeRequired": "PT2M",
                "publishingPrinciples": "https://update.dsesecurity.com/updates/dse-updates-editorial-methodology/",
                "usageInfo": "https://update.dsesecurity.com/usage/",
                "copyrightHolder": {
                    "@id": "https://dsesecurity.com/#organization"
                },
                "copyrightNotice": "Copyright © 2026 Detection Systems & Engineering. All rights reserved.",
                "citation": {
                    "@type": "CreativeWork",
                    "name": "PostgreSQL 17 — pg_checksums",
                    "url": "https://www.postgresql.org/docs/17/app-pgchecksums.html"
                }
            }
        ]
    }
}