pgd group show v5.7

Synopsis

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

Syntax

pgd group <GROUP_NAME> show [OPTIONS]

Where <GROUP_NAME> 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_subgroup show
Output
# Summary
Group Property    Value        
----------------- -------------
Group Name        dc1_subgroup 
Parent Group Name democluster15
Group Type        data         
Write Leader      kaftan       
Commit Scope                   

# Nodes
Node Name Node Kind Join State Node Status
--------- --------- ---------- -----------
kaftan    data      ACTIVE     Up         
kaboom    data      ACTIVE     Up         
kaolin    data      ACTIVE     Up         

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

Show group information as JSON

pgd group dc1_subgroup show -o json
Output
[
  {
    "Summary": [
      {
        "info": "Group Name",
        "value": "dc1_subgroup"
      },
      {
        "info": "Parent Group Name",
        "value": "democluster15"
      },
      {
        "info": "Group Type",
        "value": "data"
      },
      {
        "info": "Write Leader",
        "value": "kaftan"
      },
      {
        "info": "Commit Scope",
        "value": ""
      }
    ]
  },
  {
    "Nodes": [
      {
        "join_state": "ACTIVE",
        "node_kind_name": "data",
        "node_name": "kaftan",
        "node_status": "Up"
      },
      {
        "join_state": "ACTIVE",
        "node_kind_name": "data",
        "node_name": "kaboom",
        "node_status": "Up"
      },
      {
        "join_state": "ACTIVE",
        "node_kind_name": "data",
        "node_name": "kaolin",
        "node_status": "Up"
      }
    ]
  },
  {
    "Options": [
      {
        "option_name": "apply_delay",
        "option_value": "00:00:00 (inherited)"
      },
      {
        "option_name": "check_constraints",
        "option_value": "true (inherited)"
      },
      {
        "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 (inherited)"
      },
      {
        "option_name": "location",
        "option_value": "dc1"
      },
      {
        "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 (inherited)"
      }
    ]
  }
]