list restore point - pgrecm/RECM GitHub Wiki

Home - Top

This command display a list of defined restore point. By default, the restore point of the current connected cluster is listed. By adding a qualifier, you may filter the restore point to display.

Option/Qualifier

/before="DATE" (filter)List all restore point prior the date.

/after="DATE" (filter)List all restore point after the date.

/nocid (filter) list restore point from all registered clusters.

/cid="CID" (filter)List restore point from an other cluster by it's ID.

/before="DATE"	(filter)List all restore point prior the date.
/after="DATE"	(filter)List all restore point after the date.
/nocid	(filter) list restore point from all registered clusters.
/cid="CID"	(filter)List restore point from an other cluster by it's ID.

Description

You can use multiple options to filter the list. The date format is defined by the configuration item '/date_format'. The default is 'YYYY-MM-DD-HH'. (See 'set config' command for more details) The order is always the creation date.

Example

RECM> list restore point; 
List restore point of cluster 'CLU12' (CID=1)
Name                 Date                 Type       LSN             TL     WALfile
-------------------- -------------------- ---------- --------------- ------ ------------------------
before_upgrade       2022-01-12 13:01:11  PERMANENT  1F/90000C8      35     000000230000001F00000009 (AVAILABLE)
before_change        2022-01-12 14:00:28  TEMPORARY  1F/A000090      35     000000230000001F0000000A (AVAILABLE)
RECM>