pgd node show v5

Synopsis

The pgd node show command is used to display node-level information in the EDB Postgres Distributed cluster.

Syntax

pgd node <NODE_NAME> show [OPTIONS]

Where <NODE_NAME> is the name of the node for which you want to display information.

Options

No command specific options. See Global Options.

Examples

Show node information

pgd node node-one show
Output
# Summary
Node Property   Value
--------------- ----------
Node Name       node-one
Group Name      dc1
Node Kind       data
Join State      ACTIVE
Node Status     Up
Node ID         2824718320
Snowflake SeqID 1
Database        bdrdb

# Options
Option Name    Option Value
-------------- ----------------------------------
route_dsn      host=dhost1 dbname=bdrdb port=5444
route_fence    false
route_priority -1
route_reads    true
route_writes   true

Show node information as JSON

pgd node node-one show -o json
Output
[
  {
    "Summary": [
      {
        "info": "Node Name",
        "value": "node-one"
      },
      {
        "info": "Group Name",
        "value": "dc1"
      },
      {
        "info": "Node Kind",
        "value": "data"
      },
      {
        "info": "Join State",
        "value": "ACTIVE"
      },
      {
        "info": "Node Status",
        "value": "Up"
      },
      {
        "info": "Node ID",
        "value": "2824718320"
      },
      {
        "info": "Snowflake SeqID",
        "value": "1"
      },
      {
        "info": "Database",
        "value": "bdrdb"
      }
    ]
  },
  {
    "Options": [
      {
        "option_name": "route_dsn",
        "option_value": "host=dhost1 dbname=bdrdb port=5444"
      },
      {
        "option_name": "route_fence",
        "option_value": "false"
      },
      {
        "option_name": "route_priority",
        "option_value": "-1"
      },
      {
        "option_name": "route_reads",
        "option_value": "true"
      },
      {
        "option_name": "route_writes",
        "option_value": "true"
      }
    ]
  }
]