ALTER NODE GROUP modifies the information about a Node Group.
Only a system administrator is allowed to modify Node Group information. Node Group modification operations (excluding SET DEFAULT) are internal and needs to be performed in maintenance mode (by invoking set xc_maintenance_mode=on;). ALTER NODE GROUP can be used only within a database. To avoid data inconsistency in DBMS, do not manually run this SQL statement.
ALTER NODE GROUP groupname | SET DEFAULT | RENAME TO new_group_name | SET VCGROUP RENAME TO new_group_name | SET NOT VCGROUP | SET TABLE GROUP new_group_name
Specifies the Node Group to be renamed.
Value range: a string compliant with the naming convention rules
Sets in_redistribution to 'y' for all Node Groups excluding the one specified by groupname. To be compatible with earlier versions, this syntax is retained and does not need to be executed in maintenance mode.
Rename the Node Group specified by groupname to new_group_name.
Converts the entire physical cluster into a logical cluster. After the conversion, groupname is the logical cluster name, and the original physical cluster is changed to new_group_name.
Converts all logical clusters to common Node Groups and changes group_kind from 'v' to 'n' for all of them.
Changes all the group_names in the pgroup columns of the pgxc_class tables on all CNs to new_group_name.