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

PGXC_GROUP

PGXC_GROUP records information about node groups. The PGXC_GROUP system catalog has specific meanings only in distributed scenarios. Centralized systems can query only the table definition.

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"

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

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 value must be one of the following:
  • 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.