-
Notifications
You must be signed in to change notification settings - Fork 1
/
docker-compose-example.yml
96 lines (93 loc) · 2.29 KB
/
docker-compose-example.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
version: "3.7"
secrets:
db_replica_password:
external: true
db_password:
external: true
gcp_credentials:
external: true
cronitor_key:
external: true
services:
pg_master:
image: mesoform/postgres-ha:14-latest
volumes:
- pg_data:/var/lib/postgresql/data
environment:
- PG_MASTER=true
- POSTGRES_USER=testuser
- POSTGRES_PASSWORD_FILE=/run/secrets/db_password
- POSTGRES_DB=testdb
- PGPORT=5432
- PG_REP_USER=testrep
- PG_REP_PASSWORD_FILE=/run/secrets/db_replica_password
- HBA_ADDRESS=10.0.0.0/8
- SYNC_REPLICATION=true
- BACKUPS=true
- STORAGE_BUCKET=gs://postgresql/backups
- GCP_CREDENTIALS=/run/secrets/gcp_credentials
- FULL_BACKUP_SCHEDULE=00 00 * * *
- CRONITOR_KEY=/run/secrets/cronitor_key
ports:
- "5432:5432"
secrets:
- source: db_replica_password
uid: "70"
gid: "70"
mode: 0550
- source: db_password
uid: "70"
gid: "70"
mode: 0550
- source: gcp_credentials
uid: "70"
gid: "70"
mode: 0550
- source: cronitor_key
uid: "70"
gid: "70"
mode: 0550
networks:
database:
aliases:
- pg_cluster
deploy:
placement:
constraints:
- node.labels.type == primary
pg_replica:
image: mesoform/postgres-ha:14-latest
volumes:
- pg_replica:/var/lib/postgresql/data
environment:
- PG_SLAVE=true
- POSTGRES_USER=testuser
- POSTGRES_PASSWORD_FILE=/run/secrets/db_password
- POSTGRES_DB=testdb
- PGPORT=5432
- PG_REP_USER=testrep
- PG_REP_PASSWORD_FILE=/run/secrets/db_replica_password
- PG_MASTER_HOST=pg_master # This needs to be the swarm node private IP instead of the service name (pg_master) which resolves to the service IP
- HBA_ADDRESS=10.0.0.0/8
secrets:
- source: db_replica_password
uid: "70"
gid: "70"
mode: 0550
- source: db_password
uid: "70"
gid: "70"
mode: 0550
networks:
database:
aliases:
- pg_cluster
deploy:
placement:
constraints:
- node.labels.type != primary
networks:
database: {}
volumes:
pg_data: {}
pg_replica: {}