show-groups v5

Shows all groups in the EDB Postgres Distributed cluster and their summary.

Synopsis

Shows all groups in the EDB Postgres Distributed cluster and their summary.

In some cases when the raft isn't working properly or the group raft leader isn't present, this command might show stale or incorrect write leader for that group.

pgd show-groups [flags]

Examples

  Example 1 (multi-group cluster, with special witness-only data group
  group_c and subscriber-only group group_so)
  Note:
  1. For group write leader election both enable_raft and
  enable_proxy_routing options should be true for that group
  2. enable_raft is always set to true for global group

  $ pgd show-groups

  Group    Group ID   Type            Parent Group Location Raft  Routing Write Leader
  -----    --------   ----            ------------ -------- ----  ------- ------------
  bdrgroup 1360502012 global                                true  false
  group_a  3618712053 data            bdrgroup     a        true  true    bdr-a1
  group_b  402614658  data            bdrgroup     b        true  true    bdr-b1
  group_c  2808307099 data            bdrgroup     c        false false
  group_so 2123208041 subscriber-only bdrgroup     c        false false

Options

  -h, --help   help for show-groups

Options inherited from parent commands

  -f, --config-file string   config file; ignored if 
                             --dsn flag is present (default "/etc/edb/pgd-cli/pgd-cli-config.yml")
      --dsn string           database connection string
                             e.g."host=bdr-a1 port=5432 dbname=bdrdb user=postgres "
  -L, --log-level string     logging level: debug, info, warn, error (default "error")
  -o, --output string        output format: json, yaml

← Prev

show-events

show-nodes