Restore done but no data


I had Vertica CE running on a Redhat box which had a database with data in it. I took a full backup of it using the script to another box, where I installed Vertica 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 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 ( -> I can see that there are around 2.8GB of data, catalog.


Please help.




  • SruthiASruthiA Vertica Employee Employee

    Hi Aravind,


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


    Thank you,


  • Hi, 

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

  • SruthiASruthiA Vertica Employee Employee



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




Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file