DB upgrade / Reinstall with backup
Hi,
As long as I knew, I wanted to make an upgrade from my oldest 7.1 version to newer 10.0.1, but reviewing all doc, i found that's impossible unless you make the way through all versions. So, tried to download all those oldie versions, but on community I just could get the newest one, so... Try to backup it all and reinstall? Well, thats what I though.
I had make my day using the vbr util to backup database... uninstall completely the management console, the python modules, the Vertica database itseft (deleting also the configuration directory for a fresh install); installed the 10.0.1 version with dependencies, recreated the database with only one difference I cant change from the older version: the IP, it gives me the machine one, cant change to the older 127.0.0.1; then, when I try to restore the database with vbr with same conf file I used, with same paths, etc. It says me:
Starting object restore of database .
Error: No restore points found in backup for snapshot vertica-backup.
Looking at back/restore docs, I have seen that I cant migrate a backup to another version; it just can restore same version, but can't get back the older version of Vertica (I have just uninstalled it, remember?); I don't know if this is about database id, but I only wanna get back my public schema objects (only tables) with their data inside (about 6.9 Gb). Tried so execute the --restore-objects=public command, no luck on it so... Any advice on how to archieve this?
Thank you so much in advance.
Answers
the only option you have is upgrade the 7.1 db to vertica 10 and if you want to create new cluster on different machines, you can either perform copy cluster or backup or restore.
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/CopyingTheDatabaseToAnotherCluster.htm
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/RestoringtoanAlternateCluster.htm