Public Repository

Last pushed: 2 years ago
Short Description
Short description is empty for this repo.
Full Description

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.

Quick setup

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)

You may also run into issues with dns if you are clustering across hosts - consul to the rescue

Docker Pull Command
Owner
zer0touch