DROP FAULT GROUP
A drop operation removes the specified fault group and its child fault groups, placing all nodes under the parent of the dropped fault group.
To drop all fault groups, use ALTER DATABASE..DROP ALL FAULT GROUP syntax.
To add an orphaned node back to a fault group, you must manually re-assign it to a new or existing fault group using a combination of CREATE FAULT GROUP and ALTER FAULT GROUP..ADD NODE statements.
Tip: For a list of all fault groups defined in the cluster, query the V_CATALOG.FAULT_GROUPS system table.
Syntax
DROP FAULT GROUP name
Parameters
name |
Specifies the name of the fault group to drop. |
Privileges
Must be a superuser to drop a fault group.
Example
The following example drops the group2
fault group from the cluster:
exampledb=> DROP FAULT GROUP group2; DROP FAULT GROUP
See Also
- V_CATALOG.FAULT_GROUPS and V_CATALOG.CLUSTER_LAYOUT
- Fault Groups in the Administrator's Guide
- High Availability With Fault Groups in Vertica Concepts