Changed IP addresses of cluster, unable to start database

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:

• 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.