Skip to main content

Restore done but no data

  • January 7, 2016
  • 3 replies
  • 25 views

Arvind2

Hi, 

I had Vertica 7.1.2.1 CE running on a Redhat box which had a database with data in it. I took a full backup of it using the vbr.py script to another box, where I installed Vertica 7.1.2.0 CE (Ubuntu). I created a database in the same name as my old one. The node name, dbadmin user, path all were the same. I stopped the database (via adminTools) and ran the vbr.py restore task.

 

The restore process ran without any errors, and completed successfully.

 

When I start the database (via adminTools) and check for tables, it says "No relations found." 

 

Any idea why this could be happening? Could it be the case that it takes some time to index the data? Is there any other step to do after running the restore task and starting database? Is it due to the version difference (7.1.2.1 -> 7.1.2.0). I can see that there are around 2.8GB of data, catalog.

 

Please help.

Thanks!

 

3 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • January 7, 2016

Hi Aravind,

 

     Is the IP address of new cluster same as that of the old cluster?

 

Thank you,

 Sruthi


Arvind2
  • Author
  • New Participant
  • January 8, 2016

Hi, 

No they are different boxes. Won't restore work on that? Should I use the copycluster task?


SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • January 8, 2016

Hi,

 

   Yes. Restore does not work if IP addresses are different. You need to use Copy Cluster

 

 

Sruthi