Object backup to another database

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.