Skip to main content

Export database to another cluster Vertica 7.2.X

  • February 11, 2016
  • 7 replies
  • 23 views

Filipe
Forum|alt.badge.img
  • Participating Frequently

How can I back up a base and import the same basis as the other cluster, create embiente tests?

7 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • February 11, 2016

Hi,

 

    You can export database from one cluster to another using copycluster feature.Please visit the following URL for more information

 

 

http://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/CopyingTheDatabaseToAnotherCluster.htm%3FTocPath%3DAdministrator's%2520Guide%7CBacking%2520Up%2520and%2520Restoring%2520the%2520Database%7C_____19

 

 

Thank you,

 Sruthi


Filipe
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • February 11, 2016

Hi Sruthi,
My cluster is not accessible by the source host, which need to transfer to the destination?

 

Thank you for your help...


SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • February 11, 2016

Hi,

 

   In such a scenario, create full incremental backup and try to restore on the new cluster provided all prerequisistes are satisfied. Please visit the following URL on how to create it

 

 

http://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/CreatingFullAndIncrementalBackups.htm%3FTocPath%3DAdministrator's%2520Guide%7CBacking%2520Up%2520and%2520Restoring%2520the%2520Database%7C_____7

 

 

Sruthi


Filipe
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • February 11, 2016

Hi,
copied the source host for the backup directory to the destination and tried to apply the restore, most did not work?

print follows ...


SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • February 11, 2016

Hi,

 

      What value did you enter for restorePointLimit when creating ini file

 

 

Sruthi 


Filipe
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • February 11, 2016

Hi,
The problem was in the snapshot name was different from the source.
Now I could do.
Thanks a lot for the help...


SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • February 11, 2016

Hi,

 

      Good to know that you are able to complete restore successfully.

 

 

Sruthi