pg_subscription

字段

PostgreSQL 18 的 18 个字段，按定义顺序排列。说明默认用本站手册的译文，没有译文的按英文原文显示。

演化历史

相邻两个大版本之间的差异，新的在前。版本号链到该版的字段表。

1. PostgreSQL 19 ← 18 结构变更

   +subretaindeadtuples+submaxretention+subretentionactive+subserver+subwalrcvtimeout subconninfo：非空 → 可空

   2 处描述更新

   • subconninfo Connection string to the upstream database Connection string to the upstream database. NULL if subserver is nonzero.
   • subskiplsn Finish LSN of the transaction whose changes are to be skipped, if a valid LSN; otherwise 0/0. Finish LSN of the transaction whose changes are to be skipped, if a valid LSN; otherwise 0/0000000.

2. PostgreSQL 18 ← 17 仅描述更新

   1 处描述更新

   • subfailover If true, the associated replication slots (i.e. the main slot and the table sync slots) in the upstream database are enabled to be synchronized to the standbys If true, the associated replication slots (i.e. the main slot and the table synchronization slots) in the upstream database are enabled to be synchronized to the standbys

3. PostgreSQL 17 ← 16 结构变更

   +subfailover 关系说明更新

   2 处描述更新

   • subpublications Array of subscribed publication names. These reference publications defined in the upstream database. For more on publications see Section 31.1. Array of subscribed publication names. These reference publications defined in the upstream database. For more on publications see Section 29.1.
   • substream Controls how to handle the streaming of in-progress transactions: f = disallow streaming of in-progress transactions, t = spill the changes of in-progress transactions to disk and apply at once after the transaction is committed on the publisher and received by the subscriber, p = apply changes directly using a parallel apply worker if available (same as 't' if no worker is available) Controls how to handle the streaming of in-progress transactions: f = disallow streaming of in-progress transactions, t = spill the changes of in-progress transactions to disk and apply at once after the transaction is committed on the publisher and received by the subscriber, p = apply changes directly using a parallel apply worker if available (same as t if no worker is available)

4. PostgreSQL 16 ← 15 结构变更

   +subpasswordrequired+subrunasowner+suborigin substream：boolean → "char"

   1 处描述更新

   • substream If true, the subscription will allow streaming of in-progress transactions Controls how to handle the streaming of in-progress transactions: f = disallow streaming of in-progress transactions, t = spill the changes of in-progress transactions to disk and apply at once after the transaction is committed on the publisher and received by the subscriber, p = apply changes directly using a parallel apply worker if available (same as 't' if no worker is available)

5. PostgreSQL 15 ← 14 结构变更

   +subskiplsn+subtwophasestate+subdisableonerr

6. PostgreSQL 14 ← 13 结构变更

   +subbinary+substream 关系说明更新

   4 处描述更新

   • subdbid OID of the database which the subscription resides in OID of the database that the subscription resides in
   • subenabled If true, the subscription is enabled and should be replicating. If true, the subscription is enabled and should be replicating
   • subpublications Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 30.1. Array of subscribed publication names. These reference publications defined in the upstream database. For more on publications see Section 31.1.
   • subsynccommit Contains the value of the synchronous_commit setting for the subscription workers. The synchronous_commit setting for the subscription's workers to use

7. PostgreSQL 13 ← 12 结构变更

   subslotname：非空 → 可空

8. PostgreSQL 12 ← 11 结构变更

   oid：隐式列 → 常规列 关系说明更新

   2 处描述更新

   • oid Row identifier (hidden attribute; must be explicitly selected) Row identifier
   • subpublications Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 31.1. Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 30.1.

9. PostgreSQL 11 ← 10 仅描述更新

   关系说明更新

10. PostgreSQL 10 ← 9.6 新增此关系

    共 9 个字段

字段矩阵

每个字段在 11 个收录版本里的存在情况；方格指向该版的字段表。「有变」指类型、可空、隐式或数组维数与上一版不同。

存在 有变 已移除 不存在

系统列

同类关系