Removing Hosts From the Database
Before performing the procedure in this section, you must have completed the tasks referenced in Preparing to Remove a Node. The following procedure assumes that you have both backed up your database and lowered the k-safety.
Note: Do not stop the database.
Perform the following to remove a host from the database.
-
While logged on as dbadmin, launch Administration Tools.
$ /opt/vertica/bin/admintools
Note: Do not remove the host that is attached to your EIP.
- From the Main Menu, select Advanced Tools Menu.
- From Advanced Menu, select Cluster Management. Select OK.
- From Cluster Management, select Remove Host(s). Select OK.
- From Select Database, choose the database from which you plan to remove hosts. Select OK.
- Select the host(s) to remove. Select OK.
-
Click Yes to confirm removal of the hosts.
Note: Enter a password if necessary. Leave blank if there is no password.
- Select OK. The system displays a message letting you know that the hosts have been removed. Automatic re-balancing also occurs.
- Select OK to confirm. Administration Tools brings you back to the Cluster Management menu.