Updated on 2023-10-23 GMT+08:00

PGXC_GROUP

PGXC_GROUP records information about storage node groups.

Table 1 PGXC_GROUP columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified)

group_name

name

Name of a node group

in_redistribution

"char"

Whether redistribution is required. The value must be one of the following:
  • n: The node group is not redistributed.
  • y: The source node group is in redistribution.
  • t: The destination node group is in redistribution.

group_members

oidvector_extend

Node OID list of the node group

group_buckets

text

Distributed data bucket group

is_installation

boolean

Whether to install a sub-cluster

  • t (true): yes
  • f (false): no

group_acl

aclitem[]

Access permission

group_kind

"char"

Node group type. The value can be i, n, v, or e.
  • i: installation node group
  • n: node group in a common, non-logical cluster
  • v: node group in a logical cluster (The current feature is a lab feature. Contact Huawei engineers for technical support before using it.)
  • e: elastic cluster

group_parent

oid

For a child node group, this field indicates the OID of the parent node group. For a parent node group, this field is left blank.