pgd cluster show

pgd cluster show#

Synopsis#

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

Users and roles#

Requires the bdr_superuser role. See User roles .

Syntax#

pgd cluster show [OPTIONS]

Options#

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

Short

Long

Description

--clock-drift

Only show detailed clock drift information.

--summary

Only show cluster summary information.

--health

Only 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.

Symbol

Meaning

*

ok

~

warning (drift > 2 seconds)

!

critical (drift > 5 seconds)

x

down / 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 Drift       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    *
Contents