Yes. It is possible to backup objects from one database and restore it on another database as long as the Vertica version is same for both backup and restore operations. For more information on performing object-level backup, please take a look at URL
As long as version, node names, IP addresses and number of nodes are same you can restore object level backup to a different cluster. please make sure that location of the backup is not changed.
Comments
Hi,
Yes. It is possible to backup objects from one database and restore it on another database as long as the Vertica version is same for both backup and restore operations. For more information on performing object-level backup, please take a look at URL
https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/CreatingObjectLevelBackups.htm%3FTocPath%3DAdministrator's%2520Guide%7CBacking%2520Up%2520and%2520Restoring%2520the%2520Database%7C_____9
For more information on performing object-level restore, please take a look at URL
https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/RestoringObjectLevelBackups.htm%3FTocPath%3DAdministrator's%2520Guide%7CBacking%2520Up%2520and%2520Restoring%2520the%2520Database%7C_____14
-Regards,
Sruthi
Hi Sruthi,
Does the destination database have to have the same name as the source database?
Just to clarify - I want the objects from db1 back up so that I can restore the same objects on db2 using that config file produced from db1.
HI,
Is db2 present in the same cluster? or is it present in different cluster?
-Regards,
Sruthi
Different cluster
Hi,
As long as version, node names, IP addresses and number of nodes are same you can restore object level backup to a different cluster. please make sure that location of the backup is not changed.
-Regards,
Sruthi
You can do this if you are running Vertica 7.2.X or after (see my reply here: https://community.dev.hpe.com/t5/Vertica-Forum/how-to-synchronize-tables-between-clusters/m-p/233924#M11334).
I believe this is not the case here. Prior to 7.2.X you can restore backups to the same database, attempting to restore to another database will fail.