Stop Vertica on a Node

In some cases, you need to take down a node to perform maintenance tasks, or upgrade hardware.

  1. Check the K-safety level of your cluster:

    2. => SELECT current_fault_tolerance FROM system;
 current_fault_tolerance
-------------------------
                       1
(1 row)

    Stopping the node might require you to temporarily reduce the K-safety level of the database. For details, see Lowering K-Safety to Enable Node Removal.

    If you must reduce K-safety to 0, first back up the database.

  2. Run Administration Tools, select Advanced Menu, and click OK.
  3. Select Stop Vertica on Host and click OK.
  4. Choose the host that you want to stop and click OK.
  5. Return to the Main Menu, select View Database Cluster State, and click OK. The host you previously stopped should appear DOWN.
  6. You can now perform maintenance.

See Restart Vertica on a Node for details about restarting Vertica on a node.