dbmate/docker-compose.supavisor.yml at main · amacneil/dbmate · 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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
services:
  dev:
    depends_on:
      supavisor-db:
        condition: service_healthy
      supavisor:
        condition: service_healthy
      supavisor-create-tenant:
        condition: service_completed_successfully
    environment:
      SUPAVISOR_SESSION_TEST_URL: postgres://postgres.dev_tenant:postgres@supavisor:5452/dbmate_test?sslmode=disable
      SUPAVISOR_TRANSACTION_TEST_URL: postgres://postgres.dev_tenant:postgres@supavisor:6543/dbmate_test?sslmode=disable

  supavisor-db:
    image: supabase/postgres:15.1.0.148
    shm_size: 128mb
    environment:
      POSTGRES_PASSWORD: postgres
    healthcheck:
      test: ["CMD", "pg_isready", "-U", "postgres"]
      interval: 10s
      timeout: 10s
      retries: 5
      start_period: 5s

  supavisor:
    depends_on:
      supavisor-db:
        condition: service_healthy
    image: supabase/supavisor:2.7.4
    command: sh -c "/app/bin/migrate && /app/bin/server"
    environment:
      PORT: 4000
      PROXY_PORT_SESSION: 5452
      PROXY_PORT_TRANSACTION: 6543
      CLUSTER_POSTGRES: "true"
      DATABASE_URL: "ecto://postgres:postgres@supavisor-db:5432/postgres"
      SECRET_KEY_BASE: "12345678901234567890121234567890123456789012345678903212345678901234567890123456789032123456789012345678901234567890323456789032"
      VAULT_ENC_KEY: "12345678901234567890123456789032"
      API_JWT_SECRET: "dev"
      METRICS_JWT_SECRET: "dev"
      REGION: "local"
      ERL_AFLAGS: -proto_dist inet_tcp
      DB_POOL_SIZE: 50
    healthcheck:
      test: ["CMD", "curl", "-f", "http://localhost:4000/api/health"]
      interval: 10s
      timeout: 10s
      retries: 5
      start_period: 5s

  supavisor-create-tenant:
    depends_on:
      supavisor:
        condition: service_healthy
    image: supabase/supavisor:2.7.4
    command: |-
      sh -c '
        curl -sX PUT \
          "http://supavisor:4000/api/tenants/dev_tenant" \
          --header "Accept: */*" \
          --header "User-Agent: Thunder Client (https://www.thunderclient.com)" \
          --header "Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJvbGUiOiJhbm9uIiwiaWF0IjoxNjQ1MTkyODI0LCJleHAiOjE5NjA3Njg4MjR9.M9jrxyvPLkUxWgOYSf5dNdJ8v_eRrq810ShFRT8N-6M" \
          --header "Content-Type: application/json" \
          --data-raw '\''{
            "tenant": {
              "db_host": "supavisor-db",
              "db_port": 5432,
              "db_database": "postgres",
              "ip_version": "auto",
              "enforce_ssl": false,
              "require_user": false,
              "auth_query": "SELECT rolname, rolpassword FROM pg_authid WHERE rolname=$1;",
              "users": [
                {
                  "db_user": "postgres",
                  "db_password": "postgres",
                  "pool_size": 20,
                  "mode_type": "transaction",
                  "is_manager": true
                }
              ]
            }
          }'\''

        psql postgres://postgres:postgres@supavisor-db:5432/postgres -c "create database dbmate_test"
      '