Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

vbr[7.2]: Exclude Table from Backup

Hi All,

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,



  • SruthiASruthiA Employee



          First option is the best choice. You can create a new schema and move that specific table to that schema. While specifying objects , list the schema names alone. You can get list of schema names in your database by issuing the following query


    select * from schemata;




Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.