list backup - pgrecm/RECM GitHub Wiki

Home - Top

This command display a list of all created backups. By default, the backup of the current connected cluster is listed.
By adding a qualifier/option, you may filter the backups to display.

Option/Qualifier

/cfg (filter)List configuration backups.

/nocfg (filter) Exclude configuration backups

/full (filter)List FULL backups.

/nofull (filter) Exclude FULL backups

/meta (filter)List METADATA backups.

/nometa (filter) Exclude METADATA backups.

/wal (filter)List WAL backups.

/nowal (filter) Exclude WAL backups.

/available (filter) List ony AVAILABLE backups

/obsolete (filter) List ony OBSOLETE backups

/incomplete (filter) List ony INCOMPLETE backups

/tag="..." (filter) List backups where tag contain ''

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

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

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

/verbose Display more details about backups

/cfg	(filter)List configuration backups.
/nocfg	(filter) Exclude configuration backups
/full	(filter)List FULL backups.
/nofull	(filter) Exclude FULL backups
/meta	(filter)List METADATA backups.
/nometa	(filter) Exclude METADATA backups.
/wal	(filter)List WAL backups.
/nowal	(filter) Exclude WAL backups.
/available	(filter) List ony AVAILABLE backups
/obsolete	(filter) List ony OBSOLETE backups
/incomplete	(filter) List ony INCOMPLETE backups
/tag="..."	(filter) List backups where tag contain ''
/before="DATE"	(filter)List all backups prior the date.
/after="DATE"	(filter)List all backups after the date.
/cid="CID"	(filter)List backups from an other cluster by it's ID.
/verbose	Display more details about backups

Description

This command display backups. You can use multiple options to filter on. 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 backup date.

Backup options are :

Code Description

C Compressed backup

L Locked. Backup is removed from the retention policy( see modify backup)

I Backup FULL is created with '/noindex' option.

E Backup FULL is created with '/exclusive' option.

Code	Description
C	Compressed backup
L	Locked. Backup is removed from the retention policy( see modify backup)
I	Backup FULL is created with '/noindex' option.
E	Backup FULL is created with '/exclusive' option.

Example

RECM> list backup/verb /full 
List backups of cluster 'CLU12' (CID=1)
UID                    Date                 Type   Status       TL   Opts   Cnt        Size  Elaps(Sec) Tag
---------------------- -------------------- ------ ------------ ---- ---- -----   ---------- ---------- -------------------------
000161ddb1b43a207288   2022-01-11 17:35:01  FULL   AVAILABLE    35   CI__    14       159 MB        14s FULL_daily
000161ddb8bc08421ed8   2022-01-11 18:05:00  FULL   AVAILABLE    35   CI__    14       159 MB        15s FULL_daily

RECM> list backup/verb /cfg 
List backups of cluster 'CLU12' (CID=1)
UID                    Date                 Type   Status       TL   Opts   Cnt        Size  Elaps(Sec) Tag
---------------------- -------------------- ------ ------------ ---- ---- -----   ---------- ---------- -------------------------
000161d71d7c36a4a1d8   2022-01-06 17:49:01  CFG    AVAILABLE    35   C__L     1         7 KB         0s plus besoin
000161d71d7f2bbbd0e8   2022-01-06 17:49:03  CFG    AVAILABLE    35   C___     1         7 KB         0s plus besoin
000161dc0a8438656c78   2022-01-10 11:29:24  CFG    AVAILABLE    35   C___     1         7 KB         0s 20220110_CLU12_CFG
RECM>