Docker image for postgres 9.4 with BDR support
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)
Hi Agios, found this image gr8 thanks! just found an error:
E: Version '9.4.1-2jessie' for 'postgresql-bdr-9.4' was not found
E: Version '9.4.1-2jessie' for 'postgresql-bdr-contrib-9.4' was not found