The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Changed IP addresses of cluster, unable to start database

I have a 3 node POC cluster that was migrated to a different network. The IP addresses were changed and I can't bring up my old database. I am able to start a brand new one, but I would like to restore my old one if possible. I've changed every IP address I can find, but the database fails startup checks. I verified keyless ssh works, and can't find any references to the old ip's using recursive grep. Is there anything I can do to restore my old DB? Maybe import it into my new one?

 

7.2.1 Community Edition

Redhat 6 

Comments

  • Hi ,

    The IP address is embedded into the Vertica catalog files which are located on each one of the Vertica  nodes .

     

    in order to change the IP's you need to edit this catalog files , the way to do that is by executing  the Vertica executable with  -D parameter, the procedure of update this catalog files is very delicate and you need to know what you doing otherwise you will corrupted the database . 

     

    I advice you to take it with support 

     

    I hope you will find it useful .

     

    Thanks 

  • Hi, 

    I guess that before you made any change to the *.conf file you have made a copy of the old ones ! right ? 

    If this is true then restore your old config files and start your hosts using the old ipaddress. 

     

    After the DB is up, backup the database, 

    Install new cluster.

    Create database. 

    Restore the database.

     

  • The best thing you could do is to restore the old config file so you are able to start the Vertica Cluster again. Once you started the vertica cluster do the following:

     

     

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.