Skip to content
This repository has been archived by the owner on Nov 16, 2022. It is now read-only.

Latest commit

 

History

History
20 lines (16 loc) · 1.4 KB

README.md

File metadata and controls

20 lines (16 loc) · 1.4 KB
Raw

Postgres 9.6 Dockerized w/ Replication

Master/Slave Postgres Replication in 30 seconds.

  • Quickstart: docker-compose up
    • The ports of the instances are portmapped to 7432 (master) and 7433 (slave), thus to connect you would use 127.0.0.1 as the host and one of those ports depending on which instance you wish to connect to. These are configured in docker-compose.yml, under the ports key if you wish to change them.
  • For production, use docker-compose, Kubernetes, Rancher, Tutum, other PaaS tooling, ... or roll your own.
  • To see container environment variable requirements, see docker-compose.yml.
  • To demonstrate multiple slaves:
    • docker-compose up
    • docker-compose scale pg-slave=3

Notes

  • No additional replication user is setup - the postgres admin user is used. This means the superuser credentials must be identical on the master and all slaves.
  • setup-replication.sh is only executed when a container's data volume is first initialized.
  • REPLICATE_FROM environment variable is only used during container initialization - if the master changes after the database has been initialized, you'll need to manually adjust the recovery.conf file in the slave containers' data volume.
  • Configuration: