↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / 版本

同步复制的基于法定人数的提交

已记录的来源状态与原始语言说明;缺少版本证据时明确标为未知。

来源快照记录 PostgreSQL 8.1–18 的变化节点;历史矩阵独立记录 7.4–18 的状态。两者均未记录 PostgreSQL 19 或 20 的支持状态,较新版本明确保留为未知。这些来源声明与运行测量相互独立。

复制

说明

使用 synchronous_standby_names 配置参数,可以设置同步复制以允许任意数量的备库确认写入已提交,而不考虑其顺序。这也被称为“基于法定人数的提交”。

所选版本: PostgreSQL 18

支持

比较版本

原始文档链接

已记录旧标识: 296

完整来源事实与出处

yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd

{
  "Key": "quorum-commit-for-synchronous-replication",
  "SourceKind": "yaml",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix.yaml",
  "SourceKey": "Quorum commit for synchronous replication",
  "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
  "Name": "Quorum commit for synchronous replication",
  "NameLocale": "en",
  "GroupKey": "replication",
  "GroupName": "Replication",
  "GroupLocale": "en",
  "Ordinal": 19,
  "GroupOrder": 9,
  "Facts": {
    "feature": {
      "description": "Using the synchronous_standby_names configuration parameter, synchronous replication can be setup to allow for any number of standbys to confirm writes have been committed, irrespective of their ordering. This is also known as \"quorum commit.\"",
      "name": "Quorum commit for synchronous replication",
      "versions": {
        "10": "Yes"
      }
    },
    "group": "Replication",
    "versions": {
      "max": 18,
      "min": 8.1
    }
  },
  "Cells": [
    {
      "Version": "10",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "10",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "11",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "10",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "12",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "10",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "13",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "10",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "14",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "10",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "15",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "10",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "16",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "10",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "17",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "10",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "18",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "10",
      "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": "Quorum commit for synchronous replication",
      "BodyHTML": "\u003cp\u003eUsing the synchronous_standby_names configuration parameter, synchronous replication can be setup to allow for any number of standbys to confirm writes have been committed, irrespective of their ordering. This is also known as \u0026#34;quorum commit.\u0026#34;\u003c/p\u003e\n",
      "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
      "ContentHash": "d23313865c11f642fdbb8dd511de8fd5ef87482259757fc4ef092dcbdd7b1261",
      "Payload": {
        "description": "Using the synchronous_standby_names configuration parameter, synchronous replication can be setup to allow for any number of standbys to confirm writes have been committed, irrespective of their ordering. This is also known as \"quorum commit.\"",
        "name": "Quorum commit for synchronous replication",
        "versions": {
          "10": "Yes"
        }
      }
    },
    {
      "Locale": "zh-Hans",
      "Title": "同步复制的基于法定人数的提交",
      "BodyHTML": "\u003cp\u003e使用 synchronous_standby_names 配置参数,可以设置同步复制以允许任意数量的备库确认写入已提交,而不考虑其顺序。这也被称为“基于法定人数的提交”。\u003c/p\u003e\n",
      "SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
      "ContentHash": "1a38850cb75ef0065da8d3acddeaac61cd50f92780a72aaf3065cc223f2ecf37",
      "Payload": {
        "description": "使用 synchronous_standby_names 配置参数,可以设置同步复制以允许任意数量的备库确认写入已提交,而不考虑其顺序。这也被称为“基于法定人数的提交”。",
        "name": "同步复制的基于法定人数的提交"
      }
    }
  ],
  "GroupTitles": {
    "en": "Replication",
    "zh-Hans": "复制"
  },
  "LegacyIDs": [
    "296"
  ]
}

完整来源数据 JSON