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.

Do not stop the database.

To remove a host from the database:

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

    $ /opt/vertica/bin/admintools

    Do not remove the host that is attached to your elastic IP address.

  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.

    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.