vbr[7.2]: Exclude Table from Backup
Usually when my backup job runs, it backs-up the whole cluster. this behaviour is great for regular DB backup.
Last week, I've de-archived old data and restored it to a seperate table. now I have mySchema.production_table and mySchema.de_archived_table(which is identical in structure to production_table).
When I try to create a vbr backup configuration, I can list the objects to include in the backup, but not the objects to exclude.
How can I exclude mySchema.de_archived_table table from the backup task?
- Move the table to a new schema, e.g. dont_backup_schema.de_archived_table, and list in the backup configuration only the schemas to backup( e.g. mySchema and public, am I missing any other schema?)
- Can the object list take a regex where I can catch only objects that NOT meet some criteria?
Any other ideas?
Thanks in advance,