Based on Debian Jessie. Includes a patched postgres with support for BDR
Image heavily borrowed from the official image for postgres. Look there for further usage instructions.
Create a database on each node, eg named bdrdemo. Then, connect to the database on the first node and run:
CREATE EXTENSION IF NOT EXISTS btree_gist;
CREATE EXTENSION IF NOT EXISTS bdr;
SELECT bdr.bdr_group_create(
local_node_name := 'node01',
node_external_dsn := 'host=node01.host port=5432 dbname=bdrdemo'
);
Then, on all other nodes run:
CREATE EXTENSION IF NOT EXISTS btree_gist;
CREATE EXTENSION IF NOT EXISTS bdr;
SELECT bdr.bdr_group_join(
local_node_name := 'nodeXX',
node_external_dsn := 'host=nodeXX.host port=5432 dbname=bdrdemo',
join_using_dsn := 'host=node01.host port=5432 dbname=bdrdemo'
);
(Make sure to replace node names and hosts with appropriate values)