PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Follow these steps as the bdr_user PostgreSQL user to activate BDR on an active database named myapp on the pgha1 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 := 'chicago', 
  local_dsn := 'dbname=myapp host=pgha1 user=bdr_user' 
); 

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

SELECT bdr.create_node_group(
  node_group_name := 'megacorp'
);

4. Run the following function to wait for everything to complete:

SELECT bdr.wait_for_join_completion();