↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

FUNCTIONS / SYSTEM ADMINISTRATION FUNCTIONS

pg_create_restore_point

Read PG 18 manual ↗

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.

Signatures & examples

pg_create_restore_point ( name text ) → pg_lsn
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.
Version history 4
  1. PG 12 → 13changed
  2. PG 9.5 → 9.6changed
  3. PG 9.3 → 9.4changed
  4. PG 9.0 → 9.1added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source