Object backup to another database

ssheikh

Is it possible to do an object backup on one database and restore these objects on another?

 

Thanks.

SruthiA

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

ssheikh

Hi Sruthi,

 

Does the destination database have to have the same name as the source database?

ssheikh

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. 

SruthiA

HI,

 

  Is db2 present in the same cluster? or is it present in different cluster?

 

 

-Regards,

 Sruthi

ssheikh

Different cluster

SruthiA

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

tharanga

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.