node_address in nodes table

[Timbo]

Hi,
How does the node_address column get updated? We have some databases this is the ip address, some has hostname and one has both. For example:-
select node_address from nodes;
node_address
--------------
g40lxsvert01
g40lxsvert02
g40lxsvert03
g40lxsvert04
g40lxsvert05
g40lxsvert06
10.32.14.12
10.32.14.13
(8 rows)

The last two are nodes added to the cluster, how do we get this to show the physical server?
Thanks
Tim

[JimKnicely]

Timbo,

Were nodes added after the initial cluster was created? If so, for the -s option of the install_vertica and/or upgrade_vertica script did you use the host names or host ip addresses (or a mixture) to list your hosts? I think what we provide there is what is displayed in the node_address field of the nodes table.

Look at your /opt/vertica/config/admintools.conf file, particulariy the [Cluster] section. What is listed in there?

Anyway, I think you'll need to re-run the vertica_install script with the -S (capital S) option to reconfigure the spread software.

Please see the Installation Guide for details!