PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Follow these steps as the bdr_user PostgreSQL user to create another BDR node on an active database named myapp, on the pgha2 host:

1. Execute the following SQL to create the BDR extension:

CREATE EXTENSION bdr CASCADE; 

2. Initialize the current node with the following SQL:

SELECT bdr.create_node( 
  node_name := 'tokyo', 
  local_dsn := 'dbname=myapp host=pgha2 user=bdr_user' 
); 

3. Create the BDR cluster definition with the following SQL:

SELECT bdr.join_node_group( 
join_target_dsn := 'dbname=myapp host=pgha1 user=bdr_user', 
wait_for_completion := True 
); 

4. Obtain the status of the cluster nodes with the following query:

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