↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Versions

同步复制

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.

No translation of this description is recorded. The original Chinese description is shown. The source label is retained in Chinese; no translated label is recorded.

备份、恢复、数据完整性和复制

Description

允许主服务器在确认提交之前等待备用服务器将事务信息写入磁盘。通过 synchronous_standby_names 设置控制,一次可以有一个备用服务器担任同步备用服务器的角色。可以使用 synchronous_commit 设置按事务启用或禁用同步复制。

Selected version: PostgreSQL 18

No

20191817161514131211109.69.59.49.39.29.19.08.48.38.28.18.07.4
UnknownUnknownNoNoNoNoNoYesYesYesYesYesYesYesYesYesYesNoNoNoNoNoNoNo

Compare versions

Original documentation links

Related source snapshot entry · The original source supplies this relationship; each matrix retains its own states.

Complete source facts and provenance

legacy · center · d2075133a82fcc93b00bb726e89738c449a25760314ebcd02e69623dd7e0a363

{
  "Key": "205",
  "SourceKind": "legacy",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix_feature",
  "SourceKey": "205",
  "SourceHash": "d2075133a82fcc93b00bb726e89738c449a25760314ebcd02e69623dd7e0a363",
  "Name": "同步复制",
  "NameLocale": "zh-Hans",
  "GroupKey": "16",
  "GroupName": "备份、恢复、数据完整性和复制",
  "GroupLocale": "zh-Hans",
  "Ordinal": 0,
  "GroupOrder": 14,
  "Facts": {
    "featuredescription": "允许主服务器在确认提交之前等待备用服务器将事务信息写入磁盘。通过 synchronous_standby_names 设置控制,一次可以有一个备用服务器担任同步备用服务器的角色。可以使用 synchronous_commit 设置按事务启用或禁用同步复制。",
    "featurename": "同步复制",
    "group_id": 16,
    "id": 205,
    "v10": 1,
    "v11": 1,
    "v12": 1,
    "v13": 1,
    "v14": 0,
    "v15": 0,
    "v16": 0,
    "v17": 0,
    "v18": 0,
    "v74": 0,
    "v80": 0,
    "v81": 0,
    "v82": 0,
    "v83": 0,
    "v84": 0,
    "v90": 0,
    "v91": 1,
    "v92": 1,
    "v93": 1,
    "v94": 1,
    "v95": 1,
    "v96": 1
  },
  "Cells": [
    {
      "Version": "10",
      "State": "yes",
      "EvidenceKind": "legacy-database:v10",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "11",
      "State": "yes",
      "EvidenceKind": "legacy-database:v11",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "12",
      "State": "yes",
      "EvidenceKind": "legacy-database:v12",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "13",
      "State": "yes",
      "EvidenceKind": "legacy-database:v13",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "14",
      "State": "no",
      "EvidenceKind": "legacy-database:v14",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "15",
      "State": "no",
      "EvidenceKind": "legacy-database:v15",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "16",
      "State": "no",
      "EvidenceKind": "legacy-database:v16",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "17",
      "State": "no",
      "EvidenceKind": "legacy-database:v17",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "18",
      "State": "no",
      "EvidenceKind": "legacy-database:v18",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "7.4",
      "State": "no",
      "EvidenceKind": "legacy-database:v74",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.0",
      "State": "no",
      "EvidenceKind": "legacy-database:v80",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.1",
      "State": "no",
      "EvidenceKind": "legacy-database:v81",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.2",
      "State": "no",
      "EvidenceKind": "legacy-database:v82",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.3",
      "State": "no",
      "EvidenceKind": "legacy-database:v83",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.4",
      "State": "no",
      "EvidenceKind": "legacy-database:v84",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "9.0",
      "State": "no",
      "EvidenceKind": "legacy-database:v90",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "9.1",
      "State": "yes",
      "EvidenceKind": "legacy-database:v91",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.2",
      "State": "yes",
      "EvidenceKind": "legacy-database:v92",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.3",
      "State": "yes",
      "EvidenceKind": "legacy-database:v93",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.4",
      "State": "yes",
      "EvidenceKind": "legacy-database:v94",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.5",
      "State": "yes",
      "EvidenceKind": "legacy-database:v95",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.6",
      "State": "yes",
      "EvidenceKind": "legacy-database:v96",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    }
  ],
  "Texts": [
    {
      "Locale": "zh-Hans",
      "Title": "同步复制",
      "BodyHTML": "\u003cp\u003e允许主服务器在确认提交之前等待备用服务器将事务信息写入磁盘。通过 synchronous_standby_names 设置控制,一次可以有一个备用服务器担任同步备用服务器的角色。可以使用 synchronous_commit 设置按事务启用或禁用同步复制。\u003c/p\u003e\n",
      "SourceHash": "d2075133a82fcc93b00bb726e89738c449a25760314ebcd02e69623dd7e0a363",
      "ContentHash": "020cda8071bac219b9a366f63c52825d37248ed5fa804cae1801b2f02684215c",
      "Payload": {
        "description": "允许主服务器在确认提交之前等待备用服务器将事务信息写入磁盘。通过 synchronous_standby_names 设置控制,一次可以有一个备用服务器担任同步备用服务器的角色。可以使用 synchronous_commit 设置按事务启用或禁用同步复制。",
        "name": "同步复制"
      }
    }
  ],
  "GroupTitles": {
    "zh-Hans": "备份、恢复、数据完整性和复制"
  },
  "RelatedKey": "synchronous-replication"
}

Complete source data JSON