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:
- Connect to the database with Administration Tools or via vsql.
- Enter the command:
ALTER NODE (
node‑name) RESET;
.
To revert all cluster nodes from active standby:
- Connect to the database with Administration Tools or via vsql.
- 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.