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.

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

    $ /opt/vertica/bin/admintools

    Note: Do not remove the host that is attached to your EIP.

  2. From the Main Menu, select Advanced Tools Menu.
  3. From Advanced Menu, select Cluster Management. Select OK.
  4. From Cluster Management, select Remove Host(s). Select OK.
  5. From Select Database, choose the database from which you plan to remove hosts. Select OK.
  6. Select the host(s) to remove. Select OK.
  7. Click Yes to confirm removal of the hosts.

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

  8. Select OK. The system displays a message letting you know that the hosts have been removed. Automatic re-balancing also occurs.
  9. Select OK to confirm. Administration Tools brings you back to the Cluster Management menu.