-
Notifications
You must be signed in to change notification settings - Fork 0
list wal
pgrecm edited this page Jan 12, 2022
·
1 revision
This command display a list of WAL files. The sequence should never contain gap. This list help you to check you have all the WAL backuped.
/available (Filter) List only available WAL files /incomplete (Filter) List only incomplete WAL files /obsolete (Filter) List only obsolete WAL files /before="DATE" (filter)List all restore point prior the date. /after="DATE" (filter)List all restore point after the date. /source="STRING" (filter) list restore point of cluster by it's name /cid="CID" (filter)List restore point of cluster by it's ID.
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 WAL list can help you to detect GAP and Timeline changes.
RECM> list wal List WALs of cluster 'CLU12' (CID=1) Bck ID Status TL WAL Date ---------------------- ---------- ----- ------------------------- ------------------------------ 000161deef841f1cd030 AVAILABLE 35 000000230000001F00000074 2022-01-12 16:00:01 + - - - - --------> AVAILABLE 35 000000230000001F00000075 2022-01-12 16:01:00 + - - - - --------> AVAILABLE 35 000000230000001F00000076 2022-01-12 16:02:01 + - - - - --------> AVAILABLE 35 000000230000001F00000077 2022-01-12 16:03:00 000161deee2e2796c7e8 AVAILABLE 35 000000230000001F00000078 2022-01-12 16:04:00 + - - - - --------> AVAILABLE 35 000000230000001F00000079 2022-01-12 16:05:00 + - - - - --------> AVAILABLE 35 000000230000001F0000007A 2022-01-12 16:05:01 + - - - - --------> AVAILABLE 35 000000230000001F0000007B 2022-01-12 16:05:16 000161deee950ecc1600 AVAILABLE 35 000000230000001F0000007C 2022-01-12 16:06:00 000161deeed110adf178 AVAILABLE 35 000000230000001F0000007D 2022-01-12 16:07:01 000161deef0c337e7308 AVAILABLE 35 000000230000001F0000007E 2022-01-12 16:08:01 000161deef57384f67c0 AVAILABLE 35 000000230000001F0000007F 2022-01-12 16:09:00 + - - - - --------> AVAILABLE 35 000000230000001F00000080 2022-01-12 16:10:00 + - - - - --------> AVAILABLE 35 000000230000001F00000081 2022-01-12 16:10:01 + - - - - --------> AVAILABLE 35 000000230000001F00000082 2022-01-12 16:10:14 000161deefc10a4a1050 AVAILABLE 35 000000230000001F00000083 2022-01-12 16:11:00 000161deeffd0b6f7d80 AVAILABLE 35 000000230000001F00000084 2022-01-12 16:12:01 000161def03832790d10 AVAILABLE 35 000000230000001F00000085 2022-01-12 16:13:01 RECM>