how i change single node cluster loopback ip address?
Hi, I have a single node cluster that is installed on localhost now I want to change the IP address of my cluster(consist of a single node). So kindly suggest me how I achieve this task.Thanks in advance
0
Answers
Check out the doc page "Mapping New IP Addresses:"
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/ManageNodes/ReMapIPs/ReMapIPOverview.htm
Example:
Thanks Jim for your response I will implement this and give feedback about this solution.
Which version of Vertica are you running? This feature was first implemented in Vertica 8.1.1.
See:
https://www.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/NewFeatures/8.1/8.1.1/Database.htm
I use Vertica Analytic Database v7.2.1-0 version
Hi,
Unfortunately it is not as easy to re-ip a node prior to Vertica 8.1.1 and Vertica 7.2.1-0 isn't supported anymore.
For suggested instructions see this post:
https://forum.vertica.com/discussion/238708/how-to-change-ip-address-of-node
If you can wait I can test these commands later this afternoon (i.e. around 3 PM EST) and let you know if it works. I'd hate for you to mess up your database! MAKE SURE YOU TAKE A BACKUP if you decode to try.
@Imran_Shabbir -
I installed Vertica 7.2.1-0 on a VM using the loopback address of 127.0.0.1.
As you can see you won't be able to use this method to alter the IP address of a single node cluster.
Been a while since I used Vertica 7.2!
Anyway, beyond using the catalog editor, it should be possible to add 2 nodes to the DB, then offline the original node, change the IP, then remove the 2 nodes you added... A lot of work!
Any change you can upgrade to 8.1.1?
But we can't add more nodes because of the loopback IP. And this is mention in vertica documentation.
Oh, yeah, forgot about that!
Can you stand up another node with the correct IP and just do a COPY from Vertica?
See:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/EXPORTTOVERTICA.htm
Or if the database isn't that big, stand up anther node with correct IP then export the catalog and table data and simply bulk load it into the new node.
No, I can't stand up with another node and I have to change the loopback IP address of my existing node.
Is this a production class database?
yes