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,

Yarden

Comments

  • SruthiASruthiA Employee

    Hi,

     

          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;

     

     

    Sruthi

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
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.