PostgreSQL 12 High Availability Cookbook - Third Edition

There's more...

If we use \dx+ bdr within our database, we should see every function, table, and view available for interacting with the extension. Among these is the bdr.node_summary view that reflects the current join state and several other attributes of all nodes in the cluster.

Let's run the following query in the myapp database really quickly to see how it looks with a single node:

SELECT node_seq_id, node_id, node_name, node_group_name, peer_state_name FROM bdr.node_summary;

We should see something like this:

While BDR itself assigns a sequential node ID to each node as it joins the cluster, it also assigns an absolute node_id as part ...