PostgreSQL with BDR B-Directional Replication in a docker.

Docker Image with PostgreSQL server with BDR support for database Bi-Directional replication. Based on CentOS with Supervisor.

User can specify if database should work as stand-alone or master/slave mode. Even though BDR is more master/master solution we need to deploy first image which will create BDR setup inside of PostgreSQL. So for this purpose on run we need to specify one image to be so called master.

Environmental Variables

Usage

Stand-Alone mode

docker run \
  -d \
  --name postgres \
  -p 5432:5432 \
  polinux/postgres-bdr

Master + 2 slaves

Use docker-compose.yml exmple.

Deploy all at once from docker-compose-yml file.

docker compose up

Deploy master only

docker compose up master

Deploy slave1 only

docker compose up slave1

Deploy slave2 only

docker compose up slave2

Build

docker build -t polinux/postgres-bdr .

Docker troubleshooting

Use docker command to see if all required containers are up and running:

$ docker ps

Check logs of postgres-bdr server container:

$ docker logs postgres-bdr

Sometimes you might just want to review how things are deployed inside a running container, you can do this by executing a bash shell through docker's exec command:

docker exec -ti postgres-bdr /bin/bash

History of an image and size of layers:

docker history --no-trunc=true polinux/postgres-bdr | tr -s ' ' | tail -n+2 | awk -F " ago " '{print $2}'

Author

Przemyslaw Ozgo ([email protected])
This work is also inspired by agios's work on their docker images. Many thanks!