vbr.py backup utility and incremental backups.
+2Hi I just used the vbr.py backup utility and made my first backup and tested a restore. I then added just a very little bit of data to test out incremental backups and it did not appear to do an incremental backup but a full backup of all the data again. It did move the old data over into old_data directories but the new data is just as big as the old and if it was incremental it should of been a very small diff. Did I do something wrong. Is there some setting or parameter I need?
+2If I remember correctly, vbr.py only does full backup. The file system is setup in a way that a simple rsync on the database folder is enough to do an incremental backup.
+2What Vertica version you are using? from 5.1 on wards we have to use restorePointLimit config parameter which defines how many incremental backup you can do. you have to use this along with –archive vbr parameter. from the doc – “Each time you back up your database using the same snapshot name, vbr.py utility creates an incremental snapshot. However, previous snapshot states are not maintained unless you set the restorePointLimit parameter in the configuration file to a value greater than 1.” Please see our doc on this page “Creating Full and Incremental Snapshots (vbr.py)”, under “Backing Up and Restoring the Database” section of AdminGuide. Thanks, Ravi
+2Thank you I think that is what I needed.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
