{"Entry":{"collection":"func","key":"pg-stop-backup","name":"pg_stop_backup","aliases":[],"metadata":{"changed_in":["9.4","9.6","10"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"7.4","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"8.0"},{"descriptions_changed":true,"doc_overhaul":false,"from":"9.0","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"9.1"},{"descriptions_changed":false,"doc_overhaul":false,"from":"9.3","group_changed":null,"signatures":{"added":["pg_stop_backup ( ) → pg_lsn"],"removed":["pg_stop_backup ( ) → text"]},"status":"changed","to":"9.4"},{"descriptions_changed":true,"doc_overhaul":false,"from":"9.5","group_changed":null,"signatures":{"added":["pg_stop_backup ( exclusive boolean ) → setof record"],"removed":[]},"status":"changed","to":"9.6"},{"descriptions_changed":false,"doc_overhaul":false,"from":"9.6","group_changed":null,"signatures":{"added":["pg_stop_backup ( exclusive boolean [, wait_for_archive boolean ] ) → setof record"],"removed":["pg_stop_backup ( exclusive boolean ) → setof record"]},"status":"changed","to":"10"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":false,"doc_overhaul":false,"from":"14","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"removed","to":"15"}],"content_hash":"bb9a269d8fe0c1cc049a91aaef428ccda930821c3f7e85d74ae155ab028388aa","first_version":"8.0","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.67126+08:00","last_version":"14","name":"pg_stop_backup","name_key":"pg_stop_backup","position":29101,"present_in":["8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14"],"signature":"pg_stop_backup ( exclusive boolean [, wait_for_archive boolean ] ) → setof record ( lsn pg_lsn, labelfile text, spcmapfile text )","signature_count":2,"slug":"pg-stop-backup","source_rev":"b7bd9cda","summary":"Finishes performing an exclusive or non-exclusive on-line backup.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-stop-backup","SourceDatabase":"center","Version":"14","SourceTable":"func","SourceKey":"pg-stop-backup","SourceRevision":"b7bd9cda","Facts":{"description":"Finishes performing an exclusive or non-exclusive on-line backup. The exclusive parameter must match the previous pg_start_backup call. In an exclusive backup, pg_stop_backup removes the backup label file and, if it exists, the tablespace map file created by pg_start_backup. In a non-exclusive backup, the desired contents of these files are returned as part of the result of the function, and should be written to files in the backup area (not in the data directory).","description_html":"Finishes performing an exclusive or non-exclusive on-line backup. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eexclusive\u003c/code\u003e\u003c/em\u003e parameter must match the previous \u003ccode class=\"function\"\u003epg_start_backup\u003c/code\u003e call. In an exclusive backup, \u003ccode class=\"function\"\u003epg_stop_backup\u003c/code\u003e removes the backup label file and, if it exists, the tablespace map file created by \u003ccode class=\"function\"\u003epg_start_backup\u003c/code\u003e. In a non-exclusive backup, the desired contents of these files are returned as part of the result of the function, and should be written to files in the backup area (not in the data directory).","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-ADMIN-BACKUP-TABLE","file":"functions-admin.html","slug":"14"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-new","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Finishes performing an exclusive or non-exclusive on-line backup. The exclusive parameter must match the previous pg_start_backup call. In an exclusive backup, pg_stop_backup removes the backup label file and, if it exists, the tablespace map file created by pg_start_backup. In a non-exclusive backup, the desired contents of these files are returned as part of the result of the function, and should be written to files in the backup area (not in the data directory).","description_html":"Finishes performing an exclusive or non-exclusive on-line backup. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eexclusive\u003c/code\u003e\u003c/em\u003e parameter must match the previous \u003ccode class=\"function\"\u003epg_start_backup\u003c/code\u003e call. In an exclusive backup, \u003ccode class=\"function\"\u003epg_stop_backup\u003c/code\u003e removes the backup label file and, if it exists, the tablespace map file created by \u003ccode class=\"function\"\u003epg_start_backup\u003c/code\u003e. In a non-exclusive backup, the desired contents of these files are returned as part of the result of the function, and should be written to files in the backup area (not in the data directory).","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_stop_backup\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eexclusive\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ewait_for_archive\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003elsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003elabelfile\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003espcmapfile\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"setof record","text":"pg_stop_backup ( exclusive boolean [, wait_for_archive boolean ] ) → setof record ( lsn pg_lsn, labelfile text, spcmapfile text )","zh_from":""},{"description":"Finishes performing an exclusive on-line backup. This simplified version is equivalent to pg_stop_backup(true, true), except that it only returns the pg_lsn result.","description_html":"Finishes performing an exclusive on-line backup. This simplified version is equivalent to \u003ccode class=\"literal\"\u003epg_stop_backup(true, true)\u003c/code\u003e, except that it only returns the \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e result.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_stop_backup\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_stop_backup () → pg_lsn","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ADMIN-BACKUP-TABLE","file":"functions-admin.html","slug":"14"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-stop-backup","SourceDatabase":"pgweb","Version":"14","Locale":"zh-Hans","Title":"pg_stop_backup","Summary":"结束排他或非排他的在线备份。exclusive 参数必须与先前调用 pg_start_backup 时的值一致。在排他备份中，pg_stop_backup 会移除由 pg_start_backup 创建的备份标签文件，以及表空间映射文件（如果存在）。在非排他备份中，这些文件所需的内容作为函数结果的一部分返回，应将其写入备份区域中的文件（而不是数据目录）。","BodyHTML":"结束排他或非排他的在线备份。\u003cem\u003e\u003ccode\u003eexclusive\u003c/code\u003e\u003c/em\u003e 参数必须与先前调用 \u003ccode\u003epg_start_backup\u003c/code\u003e 时的值一致。在排他备份中，\u003ccode\u003epg_stop_backup\u003c/code\u003e 会移除由 \u003ccode\u003epg_start_backup\u003c/code\u003e 创建的备份标签文件，以及表空间映射文件（如果存在）。在非排他备份中，这些文件所需的内容作为函数结果的一部分返回，应将其写入备份区域中的文件（而不是数据目录）。\u003cpre\u003epg_stop_backup ( exclusive boolean [, wait_for_archive boolean ] ) → setof record ( lsn pg_lsn, labelfile text, spcmapfile text )\u003c/pre\u003e结束排他或非排他的在线备份。\u003cem\u003e\u003ccode\u003eexclusive\u003c/code\u003e\u003c/em\u003e 参数必须与先前调用 \u003ccode\u003epg_start_backup\u003c/code\u003e 时的值一致。在排他备份中，\u003ccode\u003epg_stop_backup\u003c/code\u003e 会移除由 \u003ccode\u003epg_start_backup\u003c/code\u003e 创建的备份标签文件，以及表空间映射文件（如果存在）。在非排他备份中，这些文件所需的内容作为函数结果的一部分返回，应将其写入备份区域中的文件（而不是数据目录）。\u003cpre\u003epg_stop_backup () → pg_lsn\u003c/pre\u003e结束排他在线备份。这个简化版本等价于 \u003ccode\u003epg_stop_backup(true, true)\u003c/code\u003e，但只返回 \u003ccode\u003epg_lsn\u003c/code\u003e 结果。","SourceRevision":"ca936764","ContentHash":"68bc5f3286d769550ce00328079e71736c4382cef996e9417faa62e15d4e4267","Payload":{"description_zh":"结束排他或非排他的在线备份。exclusive 参数必须与先前调用 pg_start_backup 时的值一致。在排他备份中，pg_stop_backup 会移除由 pg_start_backup 创建的备份标签文件，以及表空间映射文件（如果存在）。在非排他备份中，这些文件所需的内容作为函数结果的一部分返回，应将其写入备份区域中的文件（而不是数据目录）。","description_zh_html":"结束排他或非排他的在线备份。\u003cem class=\"parameter\"\u003e\u003ccode\u003eexclusive\u003c/code\u003e\u003c/em\u003e 参数必须与先前调用 \u003ccode class=\"function\"\u003epg_start_backup\u003c/code\u003e 时的值一致。在排他备份中，\u003ccode class=\"function\"\u003epg_stop_backup\u003c/code\u003e 会移除由 \u003ccode class=\"function\"\u003epg_start_backup\u003c/code\u003e 创建的备份标签文件，以及表空间映射文件（如果存在）。在非排他备份中，这些文件所需的内容作为函数结果的一部分返回，应将其写入备份区域中的文件（而不是数据目录）。","signatures":[{"description_zh":"结束排他或非排他的在线备份。exclusive 参数必须与先前调用 pg_start_backup 时的值一致。在排他备份中，pg_stop_backup 会移除由 pg_start_backup 创建的备份标签文件，以及表空间映射文件（如果存在）。在非排他备份中，这些文件所需的内容作为函数结果的一部分返回，应将其写入备份区域中的文件（而不是数据目录）。","description_zh_html":"结束排他或非排他的在线备份。\u003cem class=\"parameter\"\u003e\u003ccode\u003eexclusive\u003c/code\u003e\u003c/em\u003e 参数必须与先前调用 \u003ccode class=\"function\"\u003epg_start_backup\u003c/code\u003e 时的值一致。在排他备份中，\u003ccode class=\"function\"\u003epg_stop_backup\u003c/code\u003e 会移除由 \u003ccode class=\"function\"\u003epg_start_backup\u003c/code\u003e 创建的备份标签文件，以及表空间映射文件（如果存在）。在非排他备份中，这些文件所需的内容作为函数结果的一部分返回，应将其写入备份区域中的文件（而不是数据目录）。","returns":"setof record","text":"pg_stop_backup ( exclusive boolean [, wait_for_archive boolean ] ) → setof record ( lsn pg_lsn, labelfile text, spcmapfile text )","zh_from":"doc"},{"description_zh":"结束排他在线备份。这个简化版本等价于 pg_stop_backup(true, true)，但只返回 pg_lsn 结果。","description_zh_html":"结束排他在线备份。这个简化版本等价于 \u003ccode class=\"literal\"\u003epg_stop_backup(true, true)\u003c/code\u003e，但只返回 \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e 结果。","returns":"pg_lsn","text":"pg_stop_backup () → pg_lsn","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"14","Ordinal":0,"Hash":"ea85c179700cdc8f5fa861b0bc55f6dab23b1ddf974e13c65835b56af25c69a0","Text":"pg_stop_backup ( exclusive boolean [, wait_for_archive boolean ] ) → setof record ( lsn pg_lsn, labelfile text, spcmapfile text )","Returns":"setof record","Payload":{"description":"Finishes performing an exclusive or non-exclusive on-line backup. The exclusive parameter must match the previous pg_start_backup call. In an exclusive backup, pg_stop_backup removes the backup label file and, if it exists, the tablespace map file created by pg_start_backup. In a non-exclusive backup, the desired contents of these files are returned as part of the result of the function, and should be written to files in the backup area (not in the data directory).","description_html":"Finishes performing an exclusive or non-exclusive on-line backup. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eexclusive\u003c/code\u003e\u003c/em\u003e parameter must match the previous \u003ccode class=\"function\"\u003epg_start_backup\u003c/code\u003e call. In an exclusive backup, \u003ccode class=\"function\"\u003epg_stop_backup\u003c/code\u003e removes the backup label file and, if it exists, the tablespace map file created by \u003ccode class=\"function\"\u003epg_start_backup\u003c/code\u003e. In a non-exclusive backup, the desired contents of these files are returned as part of the result of the function, and should be written to files in the backup area (not in the data directory).","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_stop_backup\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eexclusive\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ewait_for_archive\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003elsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003elabelfile\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003espcmapfile\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"setof record","text":"pg_stop_backup ( exclusive boolean [, wait_for_archive boolean ] ) → setof record ( lsn pg_lsn, labelfile text, spcmapfile text )","zh_from":""}},{"Version":"14","Ordinal":1,"Hash":"823ea3ffe01fb2efcb8161fe95da8be0ee3f36178892d5d2745b3abf357e8e85","Text":"pg_stop_backup () → pg_lsn","Returns":"pg_lsn","Payload":{"description":"Finishes performing an exclusive on-line backup. This simplified version is equivalent to pg_stop_backup(true, true), except that it only returns the pg_lsn result.","description_html":"Finishes performing an exclusive on-line backup. This simplified version is equivalent to \u003ccode class=\"literal\"\u003epg_stop_backup(true, true)\u003c/code\u003e, except that it only returns the \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e result.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_stop_backup\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_stop_backup () → pg_lsn","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}