Need to know how to remove a down node completely from a vertica cluster

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Need to know how to remove a down node completely from a vertica cluster 

Environment

Release : 19.1

Component : IM Reporting / Admin / Configuration

Resolution

1.Remove the node from the database using drop command.

 

drdata=> DROP NODE <node_name> CASCADE;

2. Remove any occurrence of the down node in the admintools.conf file (/opt/vertica/config/admintools.conf, manually edit it).

3. Distribute the edited admintools.conf in all the nodes in the cluster by using admintools
Command: admintools -t distribute_config_files

4. Perform the query below to confirm the node is gone.

select * from nodes;