pgd nodes list v5.7

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.

Syntax

pgd nodes list [OPTIONS]

Options

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

ShortLongDescription
--versionsDisplay only version information about the nodes. For each node, the BDR version and Postgres version are shown.
-v--verboseDisplay detailed information about the nodes. For each node, this option addes the node id, Snowflake sequence id and database name.

See the 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   

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               bdrdb   
kaboom    dc1_subgroup data      ACTIVE     Up          2710197610 2               bdrdb   
kaolin    dc1_subgroup data      ACTIVE     Up          2111777360 3               bdrdb

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)