replication show subscriptions v5.6
Shows BDR subscription (incoming replication) details
Synopsis
Shows BDR subscription (incoming replication) details such as origin/target node, timestamp of the last replayed transaction, and lag between now and the timestamp of the last replayed transaction.
pgd replication show subscriptions [flags]
Examples
Subscriptions with a node down
In this example, a 3 node cluster is being queried. Nodes bdr-a1 and bdr-c1 are up but bdr-b1 is down.
$ pgd replication show subscriptions
Output
Origin Node Target Node Last Transaction Replayed At Lag Duration (seconds) ----------- ----------- ---------------------------- ---------------------- bdr-a1 bdr-c1 2022-04-23 13:13:40.854433+00 0.514275 bdr-b1 bdr-a1 bdr-b1 bdr-c1 bdr-c1 bdr-a1 2022-04-23 13:13:40.852233+00 0.335464
Subscriptions with a restarted node
In this example, a 3 node cluster is being queried. Node bdr-b1 was down and it has just been restarted.
$ pgd replication show subscriptions
Output
Origin Node Target Node Last Transaction Replayed At Lag Duration (seconds) ----------- ----------- ---------------------------- ---------------------- bdr-a1 bdr-b1 2022-04-23 13:14:45.669254+00 0.001686 bdr-a1 bdr-c1 2022-04-23 13:14:46.157913+00 -0.002009 bdr-b1 bdr-a1 bdr-b1 bdr-c1 bdr-c1 bdr-a1 2022-04-23 13:14:45.698472+00 0.259521 bdr-c1 bdr-b1 2022-04-23 13:14:45.667979+00 0.002961
Streaming subscriptions
In this example, a 3 node cluster is being queried. All nodes are up and in 'streaming' state.
$ pgd replication show subscriptions
Output
Origin Node Target Node Last Transaction Replayed At Lag Duration (seconds) ----------- ----------- ---------------------------- ---------------------- bdr-a1 bdr-b1 2022-04-23 13:15:39.732375+00 0.034462 bdr-a1 bdr-c1 2022-04-23 13:15:40.179618+00 0.002647 bdr-b1 bdr-a1 2022-04-23 13:15:39.719994+00 0.305814 bdr-b1 bdr-c1 2022-04-23 13:15:40.180886+00 0.001379 bdr-c1 bdr-a1 2022-04-23 13:15:39.714397+00 0.311411 bdr-c1 bdr-b1 2022-04-23 13:15:39.714397+00 0.052440
With other node types
In this example, a cluster with witness, logical standby and subscriber-only nodes is being queried. The upstream for logical-standby-a1 is bdr-a1 and for logical-standby-b1 is bdr-b1.
- A logical standby and subscriber-only node receive changes but don't send changes made locally to other nodes.
$ pgd replication show subscriptions
Output
Origin Node Target Node Last Transaction Replayed At Lag Duration (seconds) ----------- ----------- ---------------------------- ---------------------- bdr-a1 bdr-b1 2022-04-23 13:40:49.106411+00 0.853665 bdr-a1 logical-standby-a1 2022-04-23 13:40:50.72036+00 0.138430 bdr-a1 logical-standby-b1 bdr-a1 subscriber-only-c1 2022-04-23 13:40:50.72036+00 0.016226 bdr-a1 witness-c1 2022-04-23 13:40:50.470142+00 0.001514 bdr-b1 bdr-a1 2022-04-23 13:40:49.10174+00 1.095422 bdr-b1 logical-standby-a1 bdr-b1 logical-standby-b1 2022-04-23 13:40:50.713666+00 0.271213 bdr-b1 subscriber-only-c1 2022-04-23 13:40:50.713666+00 0.022920 bdr-b1 witness-c1 2022-04-23 13:40:50.471789+00 -0.000133 witness-c1 bdr-a1 2022-04-23 13:40:49.107706+00 1.089456 witness-c1 bdr-b1 2022-04-23 13:40:49.107706+00 0.852370 witness-c1 logical-standby-a1 witness-c1 logical-standby-b1 witness-c1 subscriber-only-c1 2022-04-23 13:40:50.719844+00 0.016742