Options

Restore done but no data

Arvind2Arvind2
in General Discussion

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!

 

Comments

  • Options
    SruthiASruthiA Vertica Employee Administrator

    Hi Aravind,

     

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

     

    Thank you,

     Sruthi

  • Options
    Arvind2Arvind2

    Hi, 

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

  • Options
    SruthiASruthiA Vertica Employee Administrator

    Hi,

     

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

     

     

    Sruthi

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...