{"Entry":{"collection":"catalog","key":"pg_subscription","name":"pg_subscription","aliases":[],"metadata":{"changed_in":["12","13","14","15","16","17","19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.6","order":false,"removed":[],"status":"added","to":"10","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"10","listing":[],"order":false,"removed":[],"status":"reworded","to":"11","types":[],"unlisted":[]},{"added":[],"attributes":[{"attribute":"hidden","from":true,"name":"oid","to":false}],"description_changed":true,"descriptions":[{"from":"Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 31.1.","name":"subpublications","to":"Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 30.1."}],"from":"11","listing":[],"order":false,"removed":[],"status":"changed","to":"12","types":[],"unlisted":[]},{"added":[],"attributes":[{"attribute":"not_null","from":true,"name":"subslotname","to":false}],"description_changed":false,"descriptions":[],"from":"12","listing":[],"order":false,"removed":[],"status":"changed","to":"13","types":[],"unlisted":[]},{"added":["subbinary","substream"],"attributes":[],"description_changed":true,"descriptions":[{"from":"OID of the database which the subscription resides in","name":"subdbid","to":"OID of the database that the subscription resides in"},{"from":"If true, the subscription is enabled and should be replicating.","name":"subenabled","to":"If true, the subscription is enabled and should be replicating"},{"from":"Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 30.1.","name":"subpublications","to":"Array of subscribed publication names. These reference publications defined in the upstream database. For more on publications see Section 31.1."},{"from":"Contains the value of the synchronous_commit setting for the subscription workers.","name":"subsynccommit","to":"The synchronous_commit setting for the subscription's workers to use"}],"from":"13","listing":[],"order":false,"removed":[],"status":"changed","to":"14","types":[],"unlisted":[]},{"added":["subskiplsn","subtwophasestate","subdisableonerr"],"attributes":[],"description_changed":false,"descriptions":[],"from":"14","listing":[],"order":false,"removed":[],"status":"changed","to":"15","types":[],"unlisted":[]},{"added":["subpasswordrequired","subrunasowner","suborigin"],"attributes":[],"description_changed":false,"descriptions":[{"from":"If true, the subscription will allow streaming of in-progress transactions","name":"substream","to":"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)"}],"from":"15","listing":[],"order":false,"removed":[],"status":"changed","to":"16","types":[{"from":"bool","name":"substream","to":"char"}],"unlisted":[]},{"added":["subfailover"],"attributes":[],"description_changed":true,"descriptions":[{"from":"Array of subscribed publication names. These reference publications defined in the upstream database. For more on publications see Section 31.1.","name":"subpublications","to":"Array of subscribed publication names. These reference publications defined in the upstream database. For more on publications see Section 29.1."},{"from":"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)","name":"substream","to":"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)"}],"from":"16","listing":[],"order":false,"removed":[],"status":"changed","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"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","name":"subfailover","to":"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"}],"from":"17","listing":[],"order":false,"removed":[],"status":"reworded","to":"18","types":[],"unlisted":[]},{"added":["subretaindeadtuples","submaxretention","subretentionactive","subserver","subwalrcvtimeout"],"attributes":[{"attribute":"not_null","from":true,"name":"subconninfo","to":false}],"description_changed":false,"descriptions":[{"from":"Connection string to the upstream database","name":"subconninfo","to":"Connection string to the upstream database. NULL if subserver is nonzero."},{"from":"Finish LSN of the transaction whose changes are to be skipped, if a valid LSN; otherwise 0/0.","name":"subskiplsn","to":"Finish LSN of the transaction whose changes are to be skipped, if a valid LSN; otherwise 0/0000000."}],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":23,"content_hash":"75c77f12d655112c8e114ddbd82cf3826e08e971a1245e104a8756ed046ebc7d","first_version":"10","imported_at":"2026-09-30T00:40:56.243167+08:00","kind":"catalog","last_version":"20","name":"pg_subscription","position":136,"present_in":["10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"english-manuals:5bf6d75fca32033525aed44878dbc2d0c6499b6d9845e3f8abe929a7a84b5b0b","summary":"The catalog pg_subscription contains all existing logical replication subscriptions.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_subscription","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_subscription","SourceRevision":"english-manuals:5bf6d75fca32033525aed44878dbc2d0c6499b6d9845e3f8abe929a7a84b5b0b","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"OID of the database that the subscription resides in","description_zh":"","documented":true,"documented_name":"subdbid","hidden":false,"name":"subdbid","not_null":true,"references":"pg_database.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":3,"description":"Finish LSN of the transaction whose changes are to be skipped, if a valid LSN; otherwise 0/0.","description_zh":"","documented":true,"documented_name":"subskiplsn","hidden":false,"name":"subskiplsn","not_null":true,"references":"","type":"pg_lsn","type_modifier":-1,"type_oid":3220},{"array_dimensions":0,"attnum":4,"description":"Name of the subscription","description_zh":"","documented":true,"documented_name":"subname","hidden":false,"name":"subname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":5,"description":"Owner of the subscription","description_zh":"","documented":true,"documented_name":"subowner","hidden":false,"name":"subowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":6,"description":"If true, the subscription is enabled and should be replicating","description_zh":"","documented":true,"documented_name":"subenabled","hidden":false,"name":"subenabled","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":7,"description":"If true, the subscription will request that the publisher send data in binary format","description_zh":"","documented":true,"documented_name":"subbinary","hidden":false,"name":"subbinary","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":8,"description":"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)","description_zh":"","documented":true,"documented_name":"substream","hidden":false,"name":"substream","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18},{"array_dimensions":0,"attnum":9,"description":"State codes for two-phase mode: d = disabled, p = pending enablement, e = enabled","description_zh":"","documented":true,"documented_name":"subtwophasestate","hidden":false,"name":"subtwophasestate","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18},{"array_dimensions":0,"attnum":10,"description":"If true, the subscription will be disabled if one of its workers detects an error","description_zh":"","documented":true,"documented_name":"subdisableonerr","hidden":false,"name":"subdisableonerr","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":11,"description":"If true, the subscription will be required to specify a password for authentication","description_zh":"","documented":true,"documented_name":"subpasswordrequired","hidden":false,"name":"subpasswordrequired","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":12,"description":"If true, the subscription will be run with the permissions of the subscription owner","description_zh":"","documented":true,"documented_name":"subrunasowner","hidden":false,"name":"subrunasowner","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":13,"description":"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","description_zh":"","documented":true,"documented_name":"subfailover","hidden":false,"name":"subfailover","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":14,"description":"Connection string to the upstream database","description_zh":"","documented":true,"documented_name":"subconninfo","hidden":false,"name":"subconninfo","not_null":true,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":15,"description":"Name of the replication slot in the upstream database (also used for the local replication origin name); null represents NONE","description_zh":"","documented":true,"documented_name":"subslotname","hidden":false,"name":"subslotname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":16,"description":"The synchronous_commit setting for the subscription's workers to use","description_zh":"","documented":true,"documented_name":"subsynccommit","hidden":false,"name":"subsynccommit","not_null":true,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":1,"attnum":17,"description":"Array of subscribed publication names. These reference publications defined in the upstream database. For more on publications see Section 29.1.","description_zh":"","documented":true,"documented_name":"subpublications","hidden":false,"name":"subpublications","not_null":true,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009},{"array_dimensions":0,"attnum":18,"description":"The origin value must be either none or any. The default is any. If none, the subscription will request the publisher to only send changes that don't have an origin. If any, the publisher sends changes regardless of their origin.","description_zh":"","documented":true,"documented_name":"suborigin","hidden":false,"name":"suborigin","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25}],"description":"The catalog pg_subscription contains all existing logical replication subscriptions. For more information about logical replication see Chapter 29.\n\nUnlike most system catalogs, pg_subscription is shared across all databases of a cluster: there is only one copy of pg_subscription per cluster, not one per database.\n\nAccess to the column subconninfo is revoked from normal users, because it could contain plain-text passwords.","description_zh":"","doc":{"anchor":"id-1.10.4.56.6","file":"catalog-pg-subscription.html","lang":"en","sha256":"2733677e87e12f64ee998189e742aef4c048ed43e5a19d70f88270a786069780","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","subdbid","subskiplsn","subname","subowner","subenabled","subbinary","substream","subtwophasestate","subdisableonerr","subpasswordrequired","subrunasowner","subfailover","subconninfo","subslotname","subsynccommit","subpublications","suborigin"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.56.6","file":"catalog-pg-subscription.html","lang":"en","sha256":"2733677e87e12f64ee998189e742aef4c048ed43e5a19d70f88270a786069780","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","subdbid","subskiplsn","subname","subowner","subenabled","subbinary","substream","subtwophasestate","subdisableonerr","subpasswordrequired","subrunasowner","subfailover","subconninfo","subslotname","subsynccommit","subpublications","suborigin"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_subscription","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_subscription","Summary":"目录pg_subscription包含所有现有的逻辑复制订阅。更多有关逻辑复制的信息请见第 29 章。\n\n和大部分系统目录不同，pg_subscription在集簇的所有数据库之间共享：每个集簇只有一份pg_subscription拷贝，而不是每个数据库一份。\n\n对列subconninfo的访问被从普通用户那里收回，因为该列可能含有明文密码。","BodyHTML":"\u003cp\u003e目录pg_subscription包含所有现有的逻辑复制订阅。更多有关逻辑复制的信息请见第 29 章。\n\n和大部分系统目录不同，pg_subscription在集簇的所有数据库之间共享：每个集簇只有一份pg_subscription拷贝，而不是每个数据库一份。\n\n对列subconninfo的访问被从普通用户那里收回，因为该列可能含有明文密码。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"022f03c1cdced09c3ef599429c3f2ba5dbf568306d32d01ab06f51565ccca590","Payload":{"columns":[{"description_zh":"行标识符","name":"oid","type":"oid","zh_from":"doc"},{"description_zh":"订阅所在的数据库的OID","name":"subdbid","type":"oid","zh_from":"doc"},{"description_zh":"若为有效 LSN，则表示要跳过其更改的事务的完成 LSN；否则为 0/0。","name":"subskiplsn","type":"pg_lsn","zh_from":"doc"},{"description_zh":"订阅的名称","name":"subname","type":"name","zh_from":"doc"},{"description_zh":"订阅的拥有者","name":"subowner","type":"oid","zh_from":"doc"},{"description_zh":"如果为真，则订阅已启用，并且应该正在进行复制。","name":"subenabled","type":"boolean","zh_from":"doc"},{"description_zh":"如果为真，订阅将请求发布者以二进制格式发送数据。","name":"subbinary","type":"boolean","zh_from":"doc"},{"description_zh":"控制如何处理进行中事务的流式传输：f = 不允许对进行中事务进行流式传输，t = 将进行中事务的更改溢写到磁盘，并在事务在发布者端提交且被订阅者接收后一次性应用，p = 如果可用，则直接使用并行应用工作进程应用更改（如果没有工作进程，则与 t 相同）","name":"substream","type":"\"char\"","zh_from":"doc"},{"description_zh":"两阶段模式的状态代码：d = 禁用，p = 待启用，e = 已启用","name":"subtwophasestate","type":"\"char\"","zh_from":"doc"},{"description_zh":"如果为真，则当该订阅的某个工作进程检测到错误时，该订阅将被禁用","name":"subdisableonerr","type":"boolean","zh_from":"doc"},{"description_zh":"如果为真，则订阅必须指定用于认证的密码","name":"subpasswordrequired","type":"boolean","zh_from":"doc"},{"description_zh":"如果为真，则订阅将按订阅所有者的权限运行","name":"subrunasowner","type":"boolean","zh_from":"doc"},{"description_zh":"如果为真，则已为上游数据库中的相关复制槽（即主槽和表同步槽）启用向备库同步的功能","name":"subfailover","type":"boolean","zh_from":"doc"},{"description_zh":"到上游数据库的连接字符串","name":"subconninfo","type":"text","zh_from":"doc"},{"description_zh":"上游数据库中复制槽的名称（也用于本地复制源名称）；NULL 表示 NONE","name":"subslotname","type":"name","zh_from":"doc"},{"description_zh":"用于订阅工作者的synchronous_commit设置。","name":"subsynccommit","type":"text","zh_from":"doc"},{"description_zh":"被订阅的发布名称数组。它们引用的是上游数据库中定义的发布。关于发布的更多信息见第 29.1 节。","name":"subpublications","type":"text[]","zh_from":"doc"},{"description_zh":"复制源值必须是 none 或 any 之一。默认值是 any。如果为 none，订阅会请求发布者只发送没有复制源的更改。如果为 any，发布者会发送更改，而不管其复制源如何。","name":"suborigin","type":"text","zh_from":"doc"}],"description_zh":"目录pg_subscription包含所有现有的逻辑复制订阅。更多有关逻辑复制的信息请见第 29 章。\n\n和大部分系统目录不同，pg_subscription在集簇的所有数据库之间共享：每个集簇只有一份pg_subscription拷贝，而不是每个数据库一份。\n\n对列subconninfo的访问被从普通用户那里收回，因为该列可能含有明文密码。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}