Functions / System Administration Functions

pg_create_restore_point

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.

Reading PG 18current·documented in 17 of 27 versions, 9.1 to 20

7.1 7.2 7.3 7.4 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 15 16 17 18 19 20

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

12 → 13 changed
9.5 → 9.6 changed
9.3 → 9.4 changed
9.0 → 9.1 added

Definition snapshot: b7bd9cda · English manual source