Remove hosts from the database

Before you remove hosts from the database, verify that you have:

• Backed up the database.

• Lowered the K-safety of the database.

To remove a host from the database:

1. While logged on as dbadmin, launch Administration Tools.

   $ /opt/vertica/bin/admintools

2. From the Main Menu, select Advanced Menu.

3. From Advanced Menu, select Cluster Management. ClickOK.

4. From Cluster Management, select Remove Host(s). Click OK.

5. From Select Database, choose the database from which you plan to remove hosts. Click OK.

6. Select the host(s) to remove. Click OK.

7. Click Yes to confirm removal of the hosts.

   Note

   Enter a password if necessary. Leave blank if there is no password.

8. Click OK. The system displays a message telling you that the hosts have been removed. Automatic rebalancing also occurs.

9. Click OK to confirm. Administration Tools brings you back to the Cluster Management menu.