{"Entry":{"collection":"func","key":"pg-copy-physical-replication-slot","name":"pg_copy_physical_replication_slot","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"11","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"12"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":true,"doc_overhaul":false,"from":"15","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"16"},{"descriptions_changed":true,"doc_overhaul":false,"from":"18","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"19"}],"content_hash":"7c86aa3509c52937b90e3d8aaa26121b25b42d0d67a9113ee26a4834a1ec0ec5","derived_content_hash":"e29bba9fe835bcc429e00564cd615186b8b5ea87f953b9e8768be9c3ccb8a64c","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:49c7030041e13836c2e8c0e93bfdae9c6a56ab28388a4944c3f6e01252c6fbfe","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"12","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.469946+08:00","last_version":"20","name":"pg_copy_physical_replication_slot","name_key":"pg_copy_physical_replication_slot","position":29024,"present_in":["12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"3a51f95503112f2ca0a314027cd1f884d447e6064213e9ba6574b0502182cde5","repair":"wiki-repair-20261023"},"signature":"pg_copy_physical_replication_slot ( src_slot_name name, dst_slot_name name [, temporary boolean ] ) → record ( slot_name name, lsn pg_lsn )","signature_count":1,"slug":"pg-copy-physical-replication-slot","source_rev":"wiki-repair-20261023:49c7030041e13836c2e8c0e93bfdae9c6a56ab28388a4944c3f6e01252c6fbfe","summary":"Copies an existing physical replication slot named src_slot_name to a physical replication slot named dst_slot_name.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-copy-physical-replication-slot","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-copy-physical-replication-slot","SourceRevision":"wiki-repair-20261023:49c7030041e13836c2e8c0e93bfdae9c6a56ab28388a4944c3f6e01252c6fbfe","Facts":{"description":"Copies an existing physical replication slot named src_slot_name to a physical replication slot named dst_slot_name. The copied physical slot starts to reserve WAL from the same LSN as the source slot. temporary is optional. If temporary is omitted, the same value as the source slot is used. Copy of an invalidated slot is not allowed.","description_html":"Copies an existing physical replication slot named \u003cem class=\"parameter\"\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e to a physical replication slot named \u003cem class=\"parameter\"\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e. The copied physical slot starts to reserve WAL from the same LSN as the source slot. \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e is optional. If \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e is omitted, the same value as the source slot is used. Copy of an invalidated slot is not allowed.","description_zh":"将一个名为 src_slot_name 的现有物理复制槽复制到一个名为 dst_slot_name 的物理复制槽。复制后的物理槽从与源槽相同的 LSN 开始保留 WAL。temporary 是可选的。如果省略了 temporary，则使用与源槽相同的值。不能复制已失效的槽。","description_zh_html":"将一个名为 \u003cem class=\"parameter\"\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e 的现有物理复制槽复制到一个名为 \u003cem class=\"parameter\"\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e 的物理复制槽。复制后的物理槽从与源槽相同的 LSN 开始保留 WAL。\u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e 是可选的。如果省略了 \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e，则使用与源槽相同的值。不能复制已失效的槽。","doc":{"anchor":"FUNCTIONS-REPLICATION-TABLE","file":"functions-admin.html","sha256":"885561d57facd49c33b44a50e320a002197d700d118784cc87d6410efadbd1f6","slug":"18"},"documentation_revision":{"inputs":[{"file":"functions-admin.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"885561d57facd49c33b44a50e320a002197d700d118784cc87d6410efadbd1f6","version":"18.7"},{"file":"functions-admin.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"830e894d29fec30b7c350c915fcaed4a63b24d57f2c96150bf25fa07fb43849c","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"group":"admin","group_label":"系统管理函数","lang":"en","layout":"table-new","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Copies an existing physical replication slot named src_slot_name to a physical replication slot named dst_slot_name. The copied physical slot starts to reserve WAL from the same LSN as the source slot. temporary is optional. If temporary is omitted, the same value as the source slot is used. Copy of an invalidated slot is not allowed.","description_html":"Copies an existing physical replication slot named \u003cem class=\"parameter\"\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e to a physical replication slot named \u003cem class=\"parameter\"\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e. The copied physical slot starts to reserve WAL from the same LSN as the source slot. \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e is optional. If \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e is omitted, the same value as the source slot is used. Copy of an invalidated slot is not allowed.","description_zh":"将一个名为 src_slot_name 的现有物理复制槽复制到一个名为 dst_slot_name 的物理复制槽。复制后的物理槽从与源槽相同的 LSN 开始保留 WAL。temporary 是可选的。如果省略了 temporary，则使用与源槽相同的值。不能复制已失效的槽。","description_zh_html":"将一个名为 \u003cem class=\"parameter\"\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e 的现有物理复制槽复制到一个名为 \u003cem class=\"parameter\"\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e 的物理复制槽。复制后的物理槽从与源槽相同的 LSN 开始保留 WAL。\u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e 是可选的。如果省略了 \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e，则使用与源槽相同的值。不能复制已失效的槽。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_copy_physical_replication_slot\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003erecord\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eslot_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003elsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e )","returns":"record","text":"pg_copy_physical_replication_slot ( src_slot_name name, dst_slot_name name [, temporary boolean] ) → record ( slot_name name, lsn pg_lsn )","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-admin.html","sha256":"b4fab9daceb7883fd75b32b6eb5398f2bbbfbbed5c83d1b2bf99cc8d842cdaf7"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-REPLICATION-TABLE","file":"functions-admin.html","sha256":"885561d57facd49c33b44a50e320a002197d700d118784cc87d6410efadbd1f6","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-copy-physical-replication-slot","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_copy_physical_replication_slot","Summary":"Copies an existing physical replication slot named src_slot_name to a physical replication slot named dst_slot_name. The copied physical slot starts to reserve WAL from the same LSN as the source slot. temporary is optional. If temporary is omitted, the same value as the source slot is used. Copy of an invalidated slot is not allowed.","BodyHTML":"Copies an existing physical replication slot named \u003cem\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e to a physical replication slot named \u003cem\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e. The copied physical slot starts to reserve WAL from the same LSN as the source slot. \u003cem\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e is optional. If \u003cem\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e is omitted, the same value as the source slot is used. Copy of an invalidated slot is not allowed.","SourceRevision":"wiki-repair-20261023:49c7030041e13836c2e8c0e93bfdae9c6a56ab28388a4944c3f6e01252c6fbfe","ContentHash":"af6f990fb2b4e9a9092d7b54bab5844d9c59fbdf4990e1710e515e4c1e68d679","Payload":{"description":"Copies an existing physical replication slot named src_slot_name to a physical replication slot named dst_slot_name. The copied physical slot starts to reserve WAL from the same LSN as the source slot. temporary is optional. If temporary is omitted, the same value as the source slot is used. Copy of an invalidated slot is not allowed.","description_html":"Copies an existing physical replication slot named \u003cem class=\"parameter\"\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e to a physical replication slot named \u003cem class=\"parameter\"\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e. The copied physical slot starts to reserve WAL from the same LSN as the source slot. \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e is optional. If \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e is omitted, the same value as the source slot is used. Copy of an invalidated slot is not allowed.","signatures":[{"description":"Copies an existing physical replication slot named src_slot_name to a physical replication slot named dst_slot_name. The copied physical slot starts to reserve WAL from the same LSN as the source slot. temporary is optional. If temporary is omitted, the same value as the source slot is used. Copy of an invalidated slot is not allowed.","description_html":"Copies an existing physical replication slot named \u003cem class=\"parameter\"\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e to a physical replication slot named \u003cem class=\"parameter\"\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e. The copied physical slot starts to reserve WAL from the same LSN as the source slot. \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e is optional. If \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e is omitted, the same value as the source slot is used. Copy of an invalidated slot is not allowed.","description_zh":"将一个名为 src_slot_name 的现有物理复制槽复制到一个名为 dst_slot_name 的物理复制槽。复制后的物理槽从与源槽相同的 LSN 开始保留 WAL。temporary 是可选的。如果省略了 temporary，则使用与源槽相同的值。不能复制已失效的槽。","description_zh_html":"将一个名为 \u003cem class=\"parameter\"\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e 的现有物理复制槽复制到一个名为 \u003cem class=\"parameter\"\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e 的物理复制槽。复制后的物理槽从与源槽相同的 LSN 开始保留 WAL。\u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e 是可选的。如果省略了 \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e，则使用与源槽相同的值。不能复制已失效的槽。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_copy_physical_replication_slot\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003erecord\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eslot_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003elsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e )","returns":"record","text":"pg_copy_physical_replication_slot ( src_slot_name name, dst_slot_name name [, temporary boolean] ) → record ( slot_name name, lsn pg_lsn )","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"ef3dd0feda23fae199d929e40770255ce5df7380d751329789d6e20bcc8ea21d","Text":"pg_copy_physical_replication_slot ( src_slot_name name, dst_slot_name name [, temporary boolean] ) → record ( slot_name name, lsn pg_lsn )","Returns":"record","Payload":{"description":"Copies an existing physical replication slot named src_slot_name to a physical replication slot named dst_slot_name. The copied physical slot starts to reserve WAL from the same LSN as the source slot. temporary is optional. If temporary is omitted, the same value as the source slot is used. Copy of an invalidated slot is not allowed.","description_html":"Copies an existing physical replication slot named \u003cem class=\"parameter\"\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e to a physical replication slot named \u003cem class=\"parameter\"\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e. The copied physical slot starts to reserve WAL from the same LSN as the source slot. \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e is optional. If \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e is omitted, the same value as the source slot is used. Copy of an invalidated slot is not allowed.","description_zh":"将一个名为 src_slot_name 的现有物理复制槽复制到一个名为 dst_slot_name 的物理复制槽。复制后的物理槽从与源槽相同的 LSN 开始保留 WAL。temporary 是可选的。如果省略了 temporary，则使用与源槽相同的值。不能复制已失效的槽。","description_zh_html":"将一个名为 \u003cem class=\"parameter\"\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e 的现有物理复制槽复制到一个名为 \u003cem class=\"parameter\"\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e 的物理复制槽。复制后的物理槽从与源槽相同的 LSN 开始保留 WAL。\u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e 是可选的。如果省略了 \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e，则使用与源槽相同的值。不能复制已失效的槽。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_copy_physical_replication_slot\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003esrc_slot_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003edst_slot_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003etemporary\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003erecord\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eslot_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003elsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e )","returns":"record","text":"pg_copy_physical_replication_slot ( src_slot_name name, dst_slot_name name [, temporary boolean] ) → record ( slot_name name, lsn pg_lsn )","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}