Dropping Fault Groups
When you remove a fault group from the cluster, be aware that the drop operation removes the specified fault group and its child fault groups. Vertica places all nodes under the parent of the dropped fault group. To see the current fault group hierarchy in the cluster, query system table
Drop a Fault Group
DROP FAULT GROUP statement to remove a fault group from the cluster. The following example shows how you can drops the
group2 fault group:
=> DROP FAULT GROUP group2; DROP FAULT GROUP
Drop All Fault Groups
ALTER DATABASE statement to drop all fault groups, along with any child fault groups, from the specified database cluster.
The following command drops all fault groups from the current database.
=> ALTER DATABASE DEFAULT DROP ALL FAULT GROUP; ALTER DATABASE
Add Nodes Back to a Fault Group
To add a node back to a fault group, you must manually reassign it to a new or existing fault group. To do so, use the
CREATE FAULT GROUP and
ALTER FAULT GROUP..ADD NODE statements.