Backup up objects in all schemas except one

Moderator: NorbertKrupa

Post Reply
User avatar
Julie
Master
Master
Posts: 221
Joined: Thu Apr 19, 2012 9:29 pm

Backup up objects in all schemas except one

Post by Julie » Fri Feb 07, 2014 2:02 pm

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?
Thanks,
Juliette

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Backup up objects in all schemas except one

Post by NorbertKrupa » Fri Feb 07, 2014 3:23 pm

Can you post a link to this vbr.py utility?
Checkout vertica.tips for more Vertica resources.

User avatar
Julie
Master
Master
Posts: 221
Joined: Thu Apr 19, 2012 9:29 pm

Re: Backup up objects in all schemas except one

Post by Julie » Fri Feb 07, 2014 5:51 pm

Hi,

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

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

Post Reply

Return to “Vertica Backup & Recovery”