CREATE NODE GROUP

Name

CREATE NODE GROUP -- create a group of cluster nodes

Synopsis

CREATE NODE GROUP groupname
WITH nodename [, ... ]

Description

Note: The following description applies only to Postgres-XC

CREATE NODE GROUP is new SQL query specific to Postgres-XC since 0.9.7 that creates node group information in catalog pgxc_group.

Parameters

groupname

The name of the selected cluster node group.

nodename

The name of a cluster node.

Notes

A group of nodes works as an alias for node lists when defining tables on sub-clusters. Only Datanode can be included in node groups.

Examples

Create a cluster node group made of nodes called datanode1, datanode2.

CREATE NODE GROUP cluster_group WITH datanode1, datanode2;

Compatibility

CREATE NODE GROUP does not conform to the SQL standards, it is a Postgres-XC specific command.