backup meta - pgrecm/RECM GitHub Wiki

Home - Top

Create a backup set of database dump without data. This operation invoke the 'pg_dump' utility to create sql file. This action never export data. That's why the files can be stored in the PGDATA folder, subfolder 'recm_meta' by default.
By default, the dump files are generated for all existing databases.
Optionally, you can define environment variable 'RECM_METADIR' to place generated files in a different folder. If you define it, you have to specify the full path directory.
You may have to configure '.pgpass' file for pg_dump working properly.

Option/Qualifier

/db="..." Select databases to select or omit.
Example:
/db=”+DB1,+DB2” Will backup only DB1 and DB2 database.
/db=”-DB1” Will backup ALL databases except DB1.br>
/lock Exclude backup from the default policy (keep forever).
/tag="..." Change default TAG of the backup
/verbose Change log details.

Description

connection to a DEPOSIT is mandatory.

Example 

CLU12> backup meta /verbose 
recm-inf: Creating meta sql file '/Library/PostgreSQL/12/data/recm_meta/metadata_CLU12_demo.sql' for database 'demo'
recm-inf: Creating piece '/Volumes/pg_backups/000161dc556a35b81340_1_META.recm'
recm-inf: Creating meta sql file '/Library/PostgreSQL/12/data/recm_meta/metadata_CLU12_depo_prod.sql' for database 'depo_prod'
recm-inf: Creating meta sql file '/Library/PostgreSQL/12/data/recm_meta/metadata_CLU12_recmdb.sql' for database 'recmdb'
recm-inf: Creating meta sql file '/Library/PostgreSQL/12/data/recm_meta/metadata_CLU12_recmrepo.sql' for database 'recmrepo'
recm-inf: Backup Piece /Volumes/pg_backups/000161dc556a35b81340_1_META.recm FileSize=6151 (Compression ratio: 79.04%)
recm-inf: Backup UID : 000161dc556a35b81340
recm-inf: Total pieces ......... : 1       
recm-inf: Total files backuped.. : 4       
recm-inf: Total Backup size .... : 29344    (28 KB)

CLU12>
⚠️ **GitHub.com Fallback** ⚠️