Vertica Analytics Platform Version 9.2.x Documentation

Revert from an Active Standby Node

If an active standby node has replaced a Vertica node in your cluster, you can revert from the active standby node on a node-by-node basis or on a cluster-wide basis.

To revert from a single active standby node:

  1. Connect to the database with Administration Tools or via vsql.
  2. Enter the command: ALTER NODE (node‑name) RESET;.

To revert all cluster nodes from active standby:

  1. Connect to the database with Administration Tools or via vsql.
  2. Enter the command: ALTER DATABASE (database‑name) RESET STANDBY;.

If a down node cannot resume operation,Vertica ignores the reset request and leaves the standby node in place.