This page in other versions: 1.0

13.1. bdr.bdr_nodes

The bdr.bdr_nodes table keeps track of a node's membership in a BDR group. A row is inserted or updated in the table during the node join process, and during node removal.

The 'status' column may have the following values, which are subject to change:

Note that the status doesn't indicate whether the node is actually up right now. A node may be shut down, isolated from the network, or crashed and still appear as r in bdr.bdr_nodes because it's still conceptually part of the BDR group. Check pg_stat_replication and pg_replication_slots for the connection and replay status of a node. See Monitoring.

Warning

Do not directly modify bdr.bdr_nodes. Use the provided node management functions instead. See Node management functions.