pgd cluster show v5.7

Synopsis

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

Syntax

pgd cluster show [OPTIONS]

Options

The following table lists the options available for the pgd cluster show command:

ShortLongDescription
--clock-driftOnly show detailed clock drift information.
--summaryOnly show cluster summary information.
--healthOnly show cluster health information.

Only one of the above options can be specified at a time.

See also Global Options.

Clock Drift

Please note that the current implementation of clock drift may return an inaccurate value if the cluster is under high load while running this command or has large number of nodes in it.

SymbolMeaning
*ok
~warning (drift > 2 seconds)
!critical (drift > 5 seconds)
xdown / unreachable
?unknown
-not applicable

Examples

Display the cluster information

pgd cluster show
Output
# Summary
Group Name    Parent Group  Group Type Node Name Node Kind
------------- ------------- ---------- --------- ---------
democluster                 global                        
dc1_subgroup  democluster   data       kaboom    data     
dc1_subgroup  democluster   data       kaftan    data     
dc1_subgroup  democluster   data       kaolin    data     

# Health
Check             Status Details                                        
----------------- ------ -----------------------------------------------
Connections       Ok     All BDR nodes are accessible                   
Raft              Ok     Raft Consensus is working correctly            
Replication Slots Ok     All PGD replication slots are working correctly
Clock Skew        Ok     Clock drift is within permissible limit        
Versions          Ok     All nodes are running the same PGD version     

# Clock Drift
Reference Node Node Name Clock Drift
-------------- --------- -----------
kaftan         kaboom    *          
kaftan         kaolin    *