Page 1 of 1

Backup up objects in all schemas except one

Posted: Fri Feb 07, 2014 2:02 pm
by Julie
Hi,

Does anyone know if there is an option in the MISC section of the .ini file for the vbr.py utility that I can use to indicate that I want to back up objects in every schema except for one?

As an example, I want to backup objects in schemas schema_a, schema_b, schema_c, schema_e and schema_f, but I don't want to backup objects in schema_d.

So instead of this:

[Misc]
snapshotName = almost_all_objects
verticaConfig = True
restorePointLimit = 7
objects = schema_a,schema_b,schema_c,schema_e,schema_f

I'd like something like this:

[Misc]
snapshotName = almost_all_objects
verticaConfig = True
restorePointLimit = 7
objects <> schema_d

The reason I am asking is because I don't want to have to edit the ini file every time I add a new schema.

Does that make sense?

Re: Backup up objects in all schemas except one

Posted: Fri Feb 07, 2014 3:23 pm
by NorbertKrupa
Can you post a link to this vbr.py utility?

Re: Backup up objects in all schemas except one

Posted: Fri Feb 07, 2014 5:51 pm
by Julie
Hi,

vbr.py is Vertica's Backup and Recovery Tool...

https://my.vertica.com/docs/7.0.x/HTML/ ... ase|_____0