change ip address

Moderator: NorbertKrupa

sreediff
Newbie
Newbie
Posts: 18
Joined: Mon Mar 28, 2016 2:51 pm

change ip address

Post by sreediff » Mon Aug 08, 2016 6:59 pm

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

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: change ip address

Post by JimKnicely » Fri Aug 12, 2016 8:44 pm

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!
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

vcarusi
Beginner
Beginner
Posts: 29
Joined: Mon Apr 20, 2015 11:03 am

Re: change ip address

Post by vcarusi » Wed Jun 07, 2017 8:33 am

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 ?

vcarusi
Beginner
Beginner
Posts: 29
Joined: Mon Apr 20, 2015 11:03 am

Re: change ip address

Post by vcarusi » Wed Jun 07, 2017 3:22 pm

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

sreediff
Newbie
Newbie
Posts: 18
Joined: Mon Mar 28, 2016 2:51 pm

Re: change ip address

Post by sreediff » Tue Jun 20, 2017 9:04 pm

will try on a local vm copy first.

sreediff
Newbie
Newbie
Posts: 18
Joined: Mon Mar 28, 2016 2:51 pm

Re: change ip address

Post by sreediff » Tue Jul 25, 2017 10:15 pm

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

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: change ip address

Post by JimKnicely » Thu Jul 27, 2017 10:13 pm

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

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Database Administration”