change ip address
Moderator: NorbertKrupa
change ip address
Can i change IP address of any existing installation>what are the steps ,which files i need to change
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: change ip address
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!
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!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: change ip address
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 ?
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 ?
Re: change ip address
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
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
Re: change ip address
will try on a local vm copy first.
Re: change ip address
i used catalog editor to change ip and now DB works. Now MC doesnt work. Not sure where to change ip for MC.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: change ip address
I think you will have to re-import the DB using the new IPs
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.