postgres-ha-cluster-lab/docker-compose.postgres_exporter.yaml at main · richwrd/postgres-ha-cluster-lab · GitHub

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
# ═══════════════════════════════════════════════════════════════════
# Cluster PostgreSQL com Patroni para Alta Disponibilidade (HA)
# Autor: Eduardo Richard
# Versão: v2.0 (2025)
# ═══════════════════════════════════════════════════════════════════

# ═══════════════════════════════════════════════════════════════════
# ÂNCORAS YAML (Templates Reutilizáveis)
# ═══════════════════════════════════════════════════════════════════

x-exporter-common: &exporter-common
  image: prometheuscommunity/postgres-exporter:latest
  networks:
    - pg-ha-network
  env_file:
    - ./infra/patroni-postgres/config/.patroni.env
  healthcheck:
    test: ["CMD-SHELL", "wget --no-verbose --tries=1 --spider http://localhost:9187/metrics || exit 1"]
    interval: 15s
    timeout: 5s
    retries: 3
    start_period: 10s
  deploy:
    resources:
      limits:
        cpus: '0.2'
        memory: 128M

# ═══════════════════════════════════════════════════════════════════
# Postgres Exporters para Prometheus
# ═══════════════════════════════════════════════════════════════════

services:
  patroni-postgres-1-exporter:
    <<: *exporter-common
    container_name: patroni-postgres-1-exporter
    hostname: patroni-postgres-1-exporter
    environment:
      DATA_SOURCE_NAME: "postgresql://${EXPORTERS_USERNAME}:${EXPORTERS_PASSWORD}@${PATRONI1_NAME}:5432/postgres?sslmode=disable"
    ports:
      - "${PG1_EXPORTER_PORT}:9187"
    depends_on:
      patroni-postgres-1:
        condition: service_healthy

  patroni-postgres-2-exporter:
    <<: *exporter-common
    container_name: patroni-postgres-2-exporter
    hostname: patroni-postgres-2-exporter
    environment:
      DATA_SOURCE_NAME: "postgresql://${EXPORTERS_USERNAME}:${EXPORTERS_PASSWORD}@${PATRONI2_NAME}:5432/postgres?sslmode=disable"
    ports:
      - "${PG2_EXPORTER_PORT}:9187"
    depends_on:
      patroni-postgres-2:
        condition: service_healthy

  patroni-postgres-3-exporter:
    <<: *exporter-common
    container_name: patroni-postgres-3-exporter
    hostname: patroni-postgres-3-exporter
    environment:
      DATA_SOURCE_NAME: "postgresql://${EXPORTERS_USERNAME}:${EXPORTERS_PASSWORD}@${PATRONI3_NAME}:5432/postgres?sslmode=disable"
    ports:
      - "${PG3_EXPORTER_PORT}:9187"
    depends_on:
      patroni-postgres-3:
        condition: service_healthy