Changed IP addresses of cluster, unable to start database

Ryan_Fitch_1

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 

eli_revach

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 

Adrian_Oprea_1

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.

 

martijnz

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:

 

• Remove old host from the cluster:
  

  # /opt/vertica/sbin/update_vertica --remove-hosts IP-ADDRESS

• Add new host to the cluster
  

  # /opt/vertica/sbin/update_vertica --add-hosts IP-ADDRESS

   
  Changing IPs in the config file makes Vertica unable to start, because it's looking for an IP address that is not available. I don't think it's possbile to restore your database data to a new cluster. You can read more about restoring databases here:
  
  https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/BackingUpAndRestoringTheDatabase.htm
  
  I hope this helps.