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 Raft Leader Write Leader ----- -------- ---- ------------ -------- ---- ------- ----------- ------------ bdrgroup 1360502012 global world true false bdr-a2 group_a 3618712053 data bdrgroup a true true bdr-a2 bdr-a1 group_b 402614658 data bdrgroup b true true bdr-b1 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