pgd replication show v5

Synopsis

The pgd replication show command is used to display the replication status in the EDB Postgres Distributed cluster.

By default, with no options, it produces reports on the following:

  • Node Replication Progress: A matrix of the replication status between nodes.
  • Replication Slots: The replication slots status for each node's slots.
  • Subscriptions: The subscription status for each subscription between nodes.
  • Analytics Replication: The analytics replication status for each node.

Options can be used to restrict the output to any one of the above reports. The --verbose option can be used to increase the detail in the default report to show the LSN and the replication lag for each node's connection to other nodes.

Syntax

pgd replication show [OPTIONS]

Options

The following options are available for the pgd replication show command:

ShortLongDescription
--nodesDisplay only node to node replication status in a matrix format.
--slotsDisplay the replication slots for each node.
--subscriptionsDisplay the subscription status for each subscription between nodes.
--analyticsDisplay the analytics replication status for each node.
-v--verboseDisplay detailed information about the replication status.

See the Global Options for common global options.

Examples

Display the replication status in the EDB Postgres Distributed cluster

pgd replication show

Display only the node to node replication status in a matrix format

pgd replication show --nodes