pgd nodes list v5
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:
| 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. |
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 ---------- ---------- --------------- ---------- ----------- node-one dc1 data ACTIVE Up node-two dc1 data ACTIVE Up node-three dc1 data ACTIVE Up sonode-one sogroup1 subscriber-only ACTIVE Up sonode2 sogroup1 subscriber-only ACTIVE Up
List all nodes with detailed information
pgd nodes list --verboseOutput
Node Name Group Name Node Kind Join State Node Status Node ID Snowflake SeqID Database ---------- ---------- --------------- ---------- ----------- ---------- --------------- -------- node-one dc1 data ACTIVE Up 2824718320 1 bdrdb node-two dc1 data ACTIVE Up 2299992455 2 bdrdb node-three dc1 data ACTIVE Up 1954860017 3 bdrdb sonode-one sogroup1 subscriber-only ACTIVE Up 2657684243 4 bdrdb sonode2 sogroup1 subscriber-only ACTIVE Up 1509873538 5 bdrdb
List all nodes version information
pgd nodes list --versionsOutput
Node Name BDR Version Postgres Version ---------- ----------- --------------------------------- node-one 5.6.0 16.4.1 (Debian 16.4.1-1.bookworm) node-three 5.6.0 16.4.1 (Debian 16.4.1-1.bookworm) node-two 5.6.0 16.4.1 (Debian 16.4.1-1.bookworm) sonode2 5.6.0 16.4.1 (Debian 16.4.1-1.bookworm) sonode-one 5.6.0 16.4.1 (Debian 16.4.1-1.bookworm)