pgd nodes list

pgd nodes list#

Synopsis#

The pgd nodes list command is used to display the nodes in the EDB Postgres Distributed cluster. By default, this shows the node name, group name, node kind, join state of the node and whether it is up or down.

Users and roles#

Requires the bdr_superuser role for the default output. With --versions , bdr_monitor is sufficient. See User roles .

Syntax#

pgd nodes list [OPTIONS]

Options#

The following options are available for the pgd nodes list command:

Short

Long

Description

--versions

Display only version information about the nodes. For each node, the BDR version and Postgres version are shown.

-v

--verbose

Display detailed information about the nodes. For each node, this option addes the node id, Snowflake sequence id and database name.

--group

Filter by group name.

See Global Options for common global options.

Examples#

List all nodes#

pgd nodes list
__OUTPUT__
Node Name Group Name   Node Kind Join State Node Status
- -------- ------------ --------- ---------- -----------
kaftan    dc1_subgroup data      ACTIVE     Up
kaboom    dc1_subgroup data      ACTIVE     Up
kaolin    dc1_subgroup data      ACTIVE     Up
kapok     dc2_subgroup data      ACTIVE     Up
kaput     dc2_subgroup data      ACTIVE     Up
karakul   dc2_subgroup data      ACTIVE     Up

List all nodes in a specific group#

pgd nodes list --group dc1_subgroup
__OUTPUT__
Node Name Group Name   Node Kind Join State Node Status
- -------- ------------ --------- ---------- -----------
kaftan    dc1_subgroup data      ACTIVE     Up
kaboom    dc1_subgroup data      ACTIVE     Up
kaolin    dc1_subgroup data      ACTIVE     Up

List all nodes with detailed information#

pgd nodes list --verbose
__OUTPUT__
Node Name Group Name   Node Kind Join State Node Status Node ID    Snowflake SeqID Database
- -------- ------------ --------- ---------- ----------- ---------- --------------- --------
kaftan    dc1_subgroup data      ACTIVE     Up          3490219809 1               pgddb
kaboom    dc1_subgroup data      ACTIVE     Up          2710197610 2               pgddb
kaolin    dc1_subgroup data      ACTIVE     Up          2111777360 3               pgddb
kapok     dc2_subgroup data      ACTIVE     Up          1599108790 4               pgddb
kaput     dc2_subgroup data      ACTIVE     Up          1321108721 5               pgddb
karakul   dc2_subgroup data      ACTIVE     Up          1012686451 6               pgddb

List all nodes version information#

pgd nodes list --versions
__OUTPUT__
Node Name BDR Version Postgres Version
- -------- ----------- -----------------------------------
kaboom    5.7.0       15.12.0 (Debian 15.12.0-1.bullseye)
kaftan    5.7.0       15.12.0 (Debian 15.12.0-1.bullseye)
kaolin    5.7.0       15.12.0 (Debian 15.12.0-1.bullseye)
kapok     5.7.0       15.12.0 (Debian 15.12.0-1.bullseye)
kaput     5.7.0       15.12.0 (Debian 15.12.0-1.bullseye)
karakul   5.7.0       15.12.0 (Debian 15.12.0-1.bullseye)
Contents