Updated on 2024-05-07 GMT+08:00

PGXC_GROUP

PGXC_GROUP records information about node groups. PGXC_GROUP can only be used to query table definitions in centralized mode.

Table 1 PGXC_GROUP columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified).

group_name

name

Node group name.

in_redistribution

"char"

Specifies whether redistribution is required. Valid value:
  • 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

Specifies whether to install a sub-database instance.

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

group_acl

aclitem[]

Access permission.

group_kind

"char"

Node group type. The options are as follows:
  • i: installation node group
  • n: node group in a common non-logical database instance
  • v: node group in a logical database instance
  • e: elastic database instance

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.