ALTER FAULT GROUP

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

  • Add a node to or drop a node from an existing fault group
  • Add a child fault group to or drop a child fault group from a parent fault group
  • Rename a fault group

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.

For a list of all fault groups defined in the cluster, query the 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

Superuser

Example

This example shows how to rename the parent0 fault group to parent100:

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

Verify the change by querying the FAULT_GROUPS system table:

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

See Also