ALTER FAULT GROUP

Modifies an existing fault group. For example, use the ALTER FAULT GROUP statement to:

Syntax

ALTER FAULT GROUP fault-group-name 
... [ ADD NODE node-name ]
... [ DROP NODE node-name ]
... [ ADD FAULT GROUP child-fault-group-name ]
... [ DROP FAULT GROUP child-fault-group-name ]
... [ RENAME TO new-fault-group-name ]

Parameters

fault-group-name

The existing fault group name you want to modify.

Tip: For a list of all fault groups defined in the cluster, query the V_CATALOG.FAULT_GROUPS system table.

node-name
The node name you want to add to or drop from the existing (parent) fault group.
child-fault-group-name
The name of the child fault group you want to add to or remove from an existing parent fault group.
new-fault-group-name
The new name for the fault group you want to rename.

Privileges

Must be a superuser to alter a fault group.

Example

This example renames the parent0 fault group to parent100:

=> ALTER FAULT GROUP parent0 RENAME TO parent100;
ALTER FAULT GROUP

You can verify the change by querying the V_CATALOG.FAULT_GROUPS system table:

=> SELECT member_name FROM fault_groups;  
   member_name
----------------------
v_exampledb_node0003
parent100
mygroup
(3 rows)

See Also