restore meta - pgrecm/RECM GitHub Wiki
This command restore METADATA file.
/verbose Display more details. /overwrite When restoring, overwrite exiting file. /file="..." Using syntax like 'regexpr', search for file to restore /uid="UID" Backup UID to use for restore. /directory="PATH" Restore files on a different location than original one. /tag="..." Filter backups on a keyword from the tag
Connection to a DEPOSIT is mandatory.
RECM> list backup List backups of cluster 'CLU12' (CID=1) UID Date Type Status TL Size Tag ---------------------- -------------------- ------ ------------ ---- ---------- ------------------------- 000161d302f43b9474e8 2022-01-03 15:06:45 META AVAILABLE 35 28 KB plus besoin 000161d71d7c36a4a1d8 2022-01-06 17:49:01 CFG AVAILABLE 35 7 KB plus besoin 000161d71d7f2bbbd0e8 2022-01-06 17:49:03 CFG AVAILABLE 35 7 KB plus besoin 000161dc0a8438656c78 2022-01-10 11:29:24 CFG AVAILABLE 35 7 KB 20220110_CLU12_CFG 000161dc556a35b81340 2022-01-10 16:49:00 META AVAILABLE 35 28 KB 20220110_CLU12_META 000161de69df0a5e24f0 2022-01-12 06:40:47 FULL INCOMPLETE 35 164 MB 20220112_CLU12_FULL 000161def0750e5fb3e8 2022-01-12 16:15:01 FULL AVAILABLE 35 159 MB Important_to_keep 000161def08515340a20 2022-01-12 16:15:17 WAL AVAILABLE 35 32 MB Important_to_keep 000161defc2c24ab4888 2022-01-12 17:05:00 FULL AVAILABLE 35 159 MB FULL_daily 000161defc3c29d18548 2022-01-12 17:05:16 WAL AVAILABLE 35 64 MB FULL_daily 000161defca42995d7f0 2022-01-12 17:07:00 WAL AVAILABLE 35 16 MB WAL_cron1 000161defce110d87830 2022-01-12 17:08:01 WAL AVAILABLE 35 16 MB WAL_cron1 000161defd1d0f87a5a0 2022-01-12 17:09:01 WAL AVAILABLE 35 16 MB WAL_cron1 000161defd5833b388e0 2022-01-12 17:10:00 WAL AVAILABLE 35 16 MB WAL_cron1 000161defd59226e6c30 2022-01-12 17:10:01 FULL AVAILABLE 35 159 MB FULL_daily 000161defd69227b6868 2022-01-12 17:10:17 WAL AVAILABLE 35 32 MB FULL_daily 000161defd950020f968 2022-01-12 17:11:01 WAL AVAILABLE 35 64 MB WAL_cron1 000161defdd1144112e8 2022-01-12 17:12:01 WAL AVAILABLE 35 16 MB WAL_cron1 RECM> restore meta /uid=000161dc556a35b81340 /dir="/tmp/mydir2"/verbose recm-inf: Found backup UID '000161dc556a35b81340', piece '/Volumes/pg_backups/000161dc556a35b81340_1_META.recm' of date '2022-01-10 16:49:00' recm-inf: Restoring file '/tmp/mydir2/metadata_CLU12_demo.sql'. recm-inf: Restoring file '/tmp/mydir2/metadata_CLU12_depo_prod.sql'. recm-inf: Restoring file '/tmp/mydir2/metadata_CLU12_recmdb.sql'. recm-inf: Restoring file '/tmp/mydir2/metadata_CLU12_recmrepo.sql'. RECM>