pgd group show v5

Synopsis

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

Syntax

pgd group <GROUPNAME> show [OPTIONS]

Where <GROUPNAME> is the name of the group for which you want to display information.

Options

No command specific options. See Global Options.

Examples

Show group information

pgd group dc1 show

Output

# Summary
Group Property    Value
----------------- -----
Group Name        dc1
Parent Group Name pgd
Group Type        data

# Nodes
Node Name  Node Kind       Join State Node Status
---------- --------------- ---------- -----------
node-one   data            ACTIVE     Up
node-two   data            ACTIVE     Up
node-three data            ACTIVE     Up
sonode-one subscriber-only ACTIVE     Up
sonode2    subscriber-only ACTIVE     Up

# Options
Option Name             Option Value
----------------------- --------------------
apply_delay             00:00:00 (inherited)
check_constraints       true
default_commit_scope     (inherited)
enable_proxy_routing    true
enable_raft             true
enable_wal_decoder      false
location                London
num_writers             -1 (inherited)
route_reader_max_lag    -1
route_writer_max_lag    -1
route_writer_wait_flush false
streaming_mode          default

Show group information as JSON

pgd group dc1 show -o json

Output

[
  {
    "Summary": [
      {
        "info": "Group Name",
        "value": "dc1"
      },
      {
        "info": "Parent Group Name",
        "value": "pgd"
      },
      {
        "info": "Group Type",
        "value": "data"
      }
    ]
  },
  {
    "Nodes": [
      {
        "join_state": "ACTIVE",
        "node_kind_name": "data",
        "node_name": "node-one",
        "node_status": "Up"
      },
      {
        "join_state": "ACTIVE",
        "node_kind_name": "data",
        "node_name": "node-two",
        "node_status": "Up"
      },
      {
        "join_state": "ACTIVE",
        "node_kind_name": "data",
        "node_name": "node-three",
        "node_status": "Up"
      },
      {
        "join_state": "ACTIVE",
        "node_kind_name": "subscriber-only",
        "node_name": "sonode-one",
        "node_status": "Up"
      },
      {
        "join_state": "ACTIVE",
        "node_kind_name": "subscriber-only",
        "node_name": "sonode2",
        "node_status": "Up"
      }
    ]
  },
  {
    "Options": [
      {
        "option_name": "apply_delay",
        "option_value": "00:00:00 (inherited)"
      },
      {
        "option_name": "check_constraints",
        "option_value": "true"
      },
      {
        "option_name": "default_commit_scope",
        "option_value": " (inherited)"
      },
      {
        "option_name": "enable_proxy_routing",
        "option_value": "true"
      },
      {
        "option_name": "enable_raft",
        "option_value": "true"
      },
      {
        "option_name": "enable_wal_decoder",
        "option_value": "false"
      },
      {
        "option_name": "location",
        "option_value": "London"
      },
      {
        "option_name": "num_writers",
        "option_value": "-1 (inherited)"
      },
      {
        "option_name": "route_reader_max_lag",
        "option_value": "-1"
      },
      {
        "option_name": "route_writer_max_lag",
        "option_value": "-1"
      },
      {
        "option_name": "route_writer_wait_flush",
        "option_value": "false"
      },
      {
        "option_name": "streaming_mode",
        "option_value": "default"
      }
    ]
  }
]

← Prev

pgd group

↑ Up