The Vertica Database Forums

Can i change IP address of any existing installation>what are the steps ,which files i need to change

Hi,

Do you have support from Vertica? If so, there is a way to do this, but let them assist you! Even a small mistake can often lead to a unstartable database!

This video (not provided by HPE) available on youtube will give you the gist:

https://www.youtube.com/watch?v=dHRFY6Ed4FY

Again, contact support!

hi,
but how to change the ip address for an one node vertica cluster.
there is an 'constraint' : the node must be done.
how to execute 'alter node' on an inactive (down) node ?

I wrote a script that is executed before starting the vertica server. It changes the old ip address with the new one.

old_ip_address = aaa.bbb.ccc.ddd
new_ip_address

old_broadcast_ip_address = old_ip_address.255 (aaa.bbb.ccc.255)
new_broadcast_ip_address = new_ip_address.255

N_old_ip_address = Naaabbbcccddd
N_new_ip_address = Naaabbbcccddd

sed -i 's/old_ip_address/new_ip_address/g' /D/vertica/catalog/db_name/v_db_name_node0001_catalog/Catalog/config.cat
sed -i 's/old_broadcast_ip_address/new_broadcast_ip_address/g' /D/vertica/catalog/db_name/v_db_name_node0001_catalog/Catalog/config.cat

sed -i 's/old_ip_address/new_ip_address/g' /opt/vertica/config/admintools.conf

sed -i 's/old_ip_address/new_ip_address/g' /D/vertica/catalog/db_name/v_officedw_node0001_catalog/spread.conf
sed -i 's/N_old_ip_address/N_new_ip_address/g' /D/vertica/catalog/db_name/v_officedw_node0001_catalog/spread.conf

will try on a local vm copy first.

i used catalog editor to change ip and now DB works. Now MC doesnt work. Not sure where to change ip for MC.

I think you will have to re-import the DB using the new IPs