{"Entry":{"collection":"func","key":"pg-create-restore-point","name":"pg_create_restore_point","aliases":[],"metadata":{"changed_in":["9.4"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.0","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.1"},{"descriptions_changed":false,"doc_overhaul":false,"from":"9.3","group_changed":null,"signatures":{"added":["pg_create_restore_point ( name text ) → pg_lsn"],"removed":["pg_create_restore_point ( name text ) → text"]},"status":"changed","to":"9.4"},{"descriptions_changed":true,"doc_overhaul":false,"from":"9.5","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"9.6"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"5a8b1d00ab327e8b858d5c7ff3b70cc05ba29d1b2a3321295e15c50a86885c99","first_version":"9.1","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.481215+08:00","last_version":"20","name":"pg_create_restore_point","name_key":"pg_create_restore_point","position":29027,"present_in":["9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"signature":"pg_create_restore_point ( name text ) → pg_lsn","signature_count":1,"slug":"pg-create-restore-point","source_rev":"b7bd9cda","summary":"Creates a named marker record in the write-ahead log that can later be used as a recovery target, and returns the corresponding write-ahead log location.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-create-restore-point","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-create-restore-point","SourceRevision":"b7bd9cda","Facts":{"description":"Creates a named marker record in the write-ahead log that can later be used as a recovery target, and returns the corresponding write-ahead log location. The given name can then be used with recovery_target_name to specify the point up to which recovery will proceed. Avoid creating multiple restore points with the same name, since recovery will stop at the first one whose name matches the recovery target.","description_html":"Creates a named marker record in the write-ahead log that can later be used as a recovery target, and returns the corresponding write-ahead log location. The given name can then be used with \u003ca href=\"/docs/18/runtime-config-wal.html#GUC-RECOVERY-TARGET-NAME\"\u003erecovery_target_name\u003c/a\u003e to specify the point up to which recovery will proceed. Avoid creating multiple restore points with the same name, since recovery will stop at the first one whose name matches the recovery target.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-ADMIN-BACKUP-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":"Creates a named marker record in the write-ahead log that can later be used as a recovery target, and returns the corresponding write-ahead log location. The given name can then be used with recovery_target_name to specify the point up to which recovery will proceed. Avoid creating multiple restore points with the same name, since recovery will stop at the first one whose name matches the recovery target.","description_html":"Creates a named marker record in the write-ahead log that can later be used as a recovery target, and returns the corresponding write-ahead log location. The given name can then be used with \u003ca href=\"/docs/18/runtime-config-wal.html#GUC-RECOVERY-TARGET-NAME\"\u003erecovery_target_name\u003c/a\u003e to specify the point up to which recovery will proceed. Avoid creating multiple restore points with the same name, since recovery will stop at the first one whose name matches the recovery target.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_create_restore_point\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_create_restore_point ( name text ) → pg_lsn","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ADMIN-BACKUP-TABLE","file":"functions-admin.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-create-restore-point","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_create_restore_point","Summary":"在预写式日志中创建一条命名标记记录，供以后用作恢复目标，并返回相应的预写式日志位置。随后可以在recovery_target_name中使用给定名称，指定恢复到哪一点。应避免创建多个同名恢复点，因为恢复会在第一个名称匹配恢复目标的恢复点停止。","BodyHTML":"在预写式日志中创建一条命名标记记录，供以后用作恢复目标，并返回相应的预写式日志位置。随后可以在\u003ca href=\"/docs/18/runtime-config-wal.html#GUC-RECOVERY-TARGET-NAME\" rel=\"nofollow\"\u003erecovery_target_name\u003c/a\u003e中使用给定名称，指定恢复到哪一点。应避免创建多个同名恢复点，因为恢复会在第一个名称匹配恢复目标的恢复点停止。\u003cpre\u003epg_create_restore_point ( name text ) → pg_lsn\u003c/pre\u003e在预写式日志中创建一条命名标记记录，供以后用作恢复目标，并返回相应的预写式日志位置。随后可以在\u003ca href=\"/docs/18/runtime-config-wal.html#GUC-RECOVERY-TARGET-NAME\" rel=\"nofollow\"\u003erecovery_target_name\u003c/a\u003e中使用给定名称，指定恢复到哪一点。应避免创建多个同名恢复点，因为恢复会在第一个名称匹配恢复目标的恢复点停止。","SourceRevision":"ca936764","ContentHash":"2ab4a60a3479aaf0955d614a095013adc4eb8d83a09c45910888cb464e6b57fd","Payload":{"description_zh":"在预写式日志中创建一条命名标记记录，供以后用作恢复目标，并返回相应的预写式日志位置。随后可以在recovery_target_name中使用给定名称，指定恢复到哪一点。应避免创建多个同名恢复点，因为恢复会在第一个名称匹配恢复目标的恢复点停止。","description_zh_html":"在预写式日志中创建一条命名标记记录，供以后用作恢复目标，并返回相应的预写式日志位置。随后可以在\u003ca href=\"/docs/18/runtime-config-wal.html#GUC-RECOVERY-TARGET-NAME\"\u003erecovery_target_name\u003c/a\u003e中使用给定名称，指定恢复到哪一点。应避免创建多个同名恢复点，因为恢复会在第一个名称匹配恢复目标的恢复点停止。","signatures":[{"description_zh":"在预写式日志中创建一条命名标记记录，供以后用作恢复目标，并返回相应的预写式日志位置。随后可以在recovery_target_name中使用给定名称，指定恢复到哪一点。应避免创建多个同名恢复点，因为恢复会在第一个名称匹配恢复目标的恢复点停止。","description_zh_html":"在预写式日志中创建一条命名标记记录，供以后用作恢复目标，并返回相应的预写式日志位置。随后可以在\u003ca href=\"/docs/18/runtime-config-wal.html#GUC-RECOVERY-TARGET-NAME\"\u003erecovery_target_name\u003c/a\u003e中使用给定名称，指定恢复到哪一点。应避免创建多个同名恢复点，因为恢复会在第一个名称匹配恢复目标的恢复点停止。","returns":"pg_lsn","text":"pg_create_restore_point ( name text ) → pg_lsn","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"61ffb16b68c2e0a0a9b1ee35561a6ae1775fd0f955f6a4a92b18e8edc10f1df8","Text":"pg_create_restore_point ( name text ) → pg_lsn","Returns":"pg_lsn","Payload":{"description":"Creates a named marker record in the write-ahead log that can later be used as a recovery target, and returns the corresponding write-ahead log location. The given name can then be used with recovery_target_name to specify the point up to which recovery will proceed. Avoid creating multiple restore points with the same name, since recovery will stop at the first one whose name matches the recovery target.","description_html":"Creates a named marker record in the write-ahead log that can later be used as a recovery target, and returns the corresponding write-ahead log location. The given name can then be used with \u003ca href=\"/docs/18/runtime-config-wal.html#GUC-RECOVERY-TARGET-NAME\"\u003erecovery_target_name\u003c/a\u003e to specify the point up to which recovery will proceed. Avoid creating multiple restore points with the same name, since recovery will stop at the first one whose name matches the recovery target.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_create_restore_point\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_create_restore_point ( name text ) → pg_lsn","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}