Skip to content

max-lt/docker-postgres-bdr

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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)

About

Docker image for Postgres with BDR support

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Shell 50.1%
  • Dockerfile 49.9%