The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
I had two tables partitioned by month which I backed up to disk using vbr.py utility. Backup run for ~6 hours. I then decided to check if my backup worked by renaming original two table names by appending _orig suffix to them and then run a restore using vbr.py with the same config file which I used to make a backup. My expectation was that restore will run for 6 hours or more and two new tables with old names will be added to the database and I will have both renamed tables and restored tables with the old names in the database. Instead, restore took less then a minute and tables with _orig suffix has been renamed back to their original names. No new two tables have appeared. It appears that simple tables rename will not be sufficient to validate a table restored from a backup. Essentially, I want to be able to have duplicate tables (one original and same table restored from a backup) side by side to validate that my backup worked properly. How can I accomplish this? I do not plan to do this kind of validation all the time, but since I am still learning about Vertica, I want to be able not to lose data while discovering how it works.