{"Entry":{"collection":"func","key":"pg-sync-replication-slots","name":"pg_sync_replication_slots","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"16","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"17"},{"descriptions_changed":true,"doc_overhaul":false,"from":"18","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"19"}],"content_hash":"23917f7833865e77eb1f87fa656ec7f597b070abd1f0db4e9df97339e94ae228","first_version":"17","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.680192+08:00","last_version":"20","name":"pg_sync_replication_slots","name_key":"pg_sync_replication_slots","position":29104,"present_in":["17","18","19","20"],"signature":"pg_sync_replication_slots () → void","signature_count":1,"slug":"pg-sync-replication-slots","source_rev":"b7bd9cda","summary":"Synchronize the logical failover replication slots from the primary server to the standby server.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-sync-replication-slots","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-sync-replication-slots","SourceRevision":"b7bd9cda","Facts":{"description":"Synchronize the logical failover replication slots from the primary server to the standby server. This function can only be executed on the standby server. Temporary synced slots, if any, cannot be used for logical decoding and must be dropped after promotion. See Section 47.2.3 for details. Note that this function is primarily intended for testing and debugging purposes and should be used with caution. Additionally, this function cannot be executed if sync_replication_slots is enabled and the slotsync worker is already running to perform the synchronization of slots.","description_html":"Synchronize the logical failover replication slots from the primary server to the standby server. This function can only be executed on the standby server. Temporary synced slots, if any, cannot be used for logical decoding and must be dropped after promotion. See \u003ca href=\"/docs/18/logicaldecoding-explanation.html#LOGICALDECODING-REPLICATION-SLOTS-SYNCHRONIZATION\" title=\"47.2.3. Replication Slot Synchronization\"\u003eSection 47.2.3\u003c/a\u003e for details. Note that this function is primarily intended for testing and debugging purposes and should be used with caution. Additionally, this function cannot be executed if \u003ca href=\"/docs/18/runtime-config-replication.html#GUC-SYNC-REPLICATION-SLOTS\"\u003e\u003ccode class=\"varname\"\u003esync_replication_slots\u003c/code\u003e\u003c/a\u003e is enabled and the slotsync worker is already running to perform the synchronization of slots.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-REPLICATION-TABLE","file":"functions-admin.html","slug":"18"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-new","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Synchronize the logical failover replication slots from the primary server to the standby server. This function can only be executed on the standby server. Temporary synced slots, if any, cannot be used for logical decoding and must be dropped after promotion. See Section 47.2.3 for details. Note that this function is primarily intended for testing and debugging purposes and should be used with caution. Additionally, this function cannot be executed if sync_replication_slots is enabled and the slotsync worker is already running to perform the synchronization of slots.","description_html":"Synchronize the logical failover replication slots from the primary server to the standby server. This function can only be executed on the standby server. Temporary synced slots, if any, cannot be used for logical decoding and must be dropped after promotion. See \u003ca href=\"/docs/18/logicaldecoding-explanation.html#LOGICALDECODING-REPLICATION-SLOTS-SYNCHRONIZATION\" title=\"47.2.3. Replication Slot Synchronization\"\u003eSection 47.2.3\u003c/a\u003e for details. Note that this function is primarily intended for testing and debugging purposes and should be used with caution. Additionally, this function cannot be executed if \u003ca href=\"/docs/18/runtime-config-replication.html#GUC-SYNC-REPLICATION-SLOTS\"\u003e\u003ccode class=\"varname\"\u003esync_replication_slots\u003c/code\u003e\u003c/a\u003e is enabled and the slotsync worker is already running to perform the synchronization of slots.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_sync_replication_slots\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003evoid\u003c/code\u003e","returns":"void","text":"pg_sync_replication_slots () → void","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-REPLICATION-TABLE","file":"functions-admin.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-sync-replication-slots","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_sync_replication_slots","Summary":"将逻辑故障切换复制槽从主库同步到备库。此函数只能在备库上执行。临时同步的槽（如果有）不能用于逻辑解码，必须在提升后删除。详见第 47.2.3 节。请注意，此函数主要用于测试和调试目的，应谨慎使用。此外，如果sync_replication_slots已启用且slotsync工作进程已在运行以执行槽同步，则无法执行此函数。","BodyHTML":"将逻辑故障切换复制槽从主库同步到备库。此函数只能在备库上执行。临时同步的槽（如果有）不能用于逻辑解码，必须在提升后删除。详见\u003ca href=\"/docs/18/logicaldecoding-explanation.html#LOGICALDECODING-REPLICATION-SLOTS-SYNCHRONIZATION\" rel=\"nofollow\"\u003e第 47.2.3 节\u003c/a\u003e。请注意，此函数主要用于测试和调试目的，应谨慎使用。此外，如果\u003ca href=\"/docs/18/runtime-config-replication.html#GUC-SYNC-REPLICATION-SLOTS\" rel=\"nofollow\"\u003e\u003ccode\u003esync_replication_slots\u003c/code\u003e\u003c/a\u003e已启用且slotsync工作进程已在运行以执行槽同步，则无法执行此函数。\u003cpre\u003epg_sync_replication_slots () → void\u003c/pre\u003e将逻辑故障切换复制槽从主库同步到备库。此函数只能在备库上执行。临时同步的槽（如果有）不能用于逻辑解码，必须在提升后删除。详见\u003ca href=\"/docs/18/logicaldecoding-explanation.html#LOGICALDECODING-REPLICATION-SLOTS-SYNCHRONIZATION\" rel=\"nofollow\"\u003e第 47.2.3 节\u003c/a\u003e。请注意，此函数主要用于测试和调试目的，应谨慎使用。此外，如果\u003ca href=\"/docs/18/runtime-config-replication.html#GUC-SYNC-REPLICATION-SLOTS\" rel=\"nofollow\"\u003e\u003ccode\u003esync_replication_slots\u003c/code\u003e\u003c/a\u003e已启用且slotsync工作进程已在运行以执行槽同步，则无法执行此函数。","SourceRevision":"1b5ca64c","ContentHash":"dbca277b6ee4801d4fcca4859908b659b147b5c805dab8550887fc5f672fe7b4","Payload":{"description_zh":"将逻辑故障切换复制槽从主库同步到备库。此函数只能在备库上执行。临时同步的槽（如果有）不能用于逻辑解码，必须在提升后删除。详见第 47.2.3 节。请注意，此函数主要用于测试和调试目的，应谨慎使用。此外，如果sync_replication_slots已启用且slotsync工作进程已在运行以执行槽同步，则无法执行此函数。","description_zh_html":"将逻辑故障切换复制槽从主库同步到备库。此函数只能在备库上执行。临时同步的槽（如果有）不能用于逻辑解码，必须在提升后删除。详见\u003ca href=\"/docs/18/logicaldecoding-explanation.html#LOGICALDECODING-REPLICATION-SLOTS-SYNCHRONIZATION\" title=\"47.2.3. 复制槽同步\"\u003e第 47.2.3 节\u003c/a\u003e。请注意，此函数主要用于测试和调试目的，应谨慎使用。此外，如果\u003ca href=\"/docs/18/runtime-config-replication.html#GUC-SYNC-REPLICATION-SLOTS\"\u003e\u003ccode class=\"varname\"\u003esync_replication_slots\u003c/code\u003e\u003c/a\u003e已启用且slotsync工作进程已在运行以执行槽同步，则无法执行此函数。","signatures":[{"description_zh":"将逻辑故障切换复制槽从主库同步到备库。此函数只能在备库上执行。临时同步的槽（如果有）不能用于逻辑解码，必须在提升后删除。详见第 47.2.3 节。请注意，此函数主要用于测试和调试目的，应谨慎使用。此外，如果sync_replication_slots已启用且slotsync工作进程已在运行以执行槽同步，则无法执行此函数。","description_zh_html":"将逻辑故障切换复制槽从主库同步到备库。此函数只能在备库上执行。临时同步的槽（如果有）不能用于逻辑解码，必须在提升后删除。详见\u003ca href=\"/docs/18/logicaldecoding-explanation.html#LOGICALDECODING-REPLICATION-SLOTS-SYNCHRONIZATION\" title=\"47.2.3. 复制槽同步\"\u003e第 47.2.3 节\u003c/a\u003e。请注意，此函数主要用于测试和调试目的，应谨慎使用。此外，如果\u003ca href=\"/docs/18/runtime-config-replication.html#GUC-SYNC-REPLICATION-SLOTS\"\u003e\u003ccode class=\"varname\"\u003esync_replication_slots\u003c/code\u003e\u003c/a\u003e已启用且slotsync工作进程已在运行以执行槽同步，则无法执行此函数。","returns":"void","text":"pg_sync_replication_slots () → void","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"6486ae3b0fa62b623a2f45cd01261d213013a572c2aeb620ca2db3b90e9366a3","Text":"pg_sync_replication_slots () → void","Returns":"void","Payload":{"description":"Synchronize the logical failover replication slots from the primary server to the standby server. This function can only be executed on the standby server. Temporary synced slots, if any, cannot be used for logical decoding and must be dropped after promotion. See Section 47.2.3 for details. Note that this function is primarily intended for testing and debugging purposes and should be used with caution. Additionally, this function cannot be executed if sync_replication_slots is enabled and the slotsync worker is already running to perform the synchronization of slots.","description_html":"Synchronize the logical failover replication slots from the primary server to the standby server. This function can only be executed on the standby server. Temporary synced slots, if any, cannot be used for logical decoding and must be dropped after promotion. See \u003ca href=\"/docs/18/logicaldecoding-explanation.html#LOGICALDECODING-REPLICATION-SLOTS-SYNCHRONIZATION\" title=\"47.2.3. Replication Slot Synchronization\"\u003eSection 47.2.3\u003c/a\u003e for details. Note that this function is primarily intended for testing and debugging purposes and should be used with caution. Additionally, this function cannot be executed if \u003ca href=\"/docs/18/runtime-config-replication.html#GUC-SYNC-REPLICATION-SLOTS\"\u003e\u003ccode class=\"varname\"\u003esync_replication_slots\u003c/code\u003e\u003c/a\u003e is enabled and the slotsync worker is already running to perform the synchronization of slots.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_sync_replication_slots\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003evoid\u003c/code\u003e","returns":"void","text":"pg_sync_replication_slots () → void","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}