Skip to content

jgiannuzzi/docker-postgres-bdr

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

24 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Docker image for PostgreSQL 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)

Build Status

About

Docker image for PostgreSQL with BDR support

Resources

License

Stars

Watchers

Forks

Packages

 
 
 

Languages

  • Shell 100.0%