db-extractor-pgsql/docker-compose.yml at master · keboola/db-extractor-pgsql · 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
services:
  app: &app
    build: .
    image: keboola/db-extractor-pgsql
    command: composer ci
    environment:
      - KBC_COMPONENT_RUN_MODE=run
      - KBC_DATA_TYPE_SUPPORT=none
      - PGSQL_DB_HOST=pgsql
      - PGSQL_DB_SSL_HOST=pgsql-ssl
      - PGSQL_DB_SSL_HOST_BAD_CN=pgsql-ssl-bad-cn
      - PGSQL_DB_PORT=5432
      - PGSQL_DB_DATABASE=postgres
      - PGSQL_DB_USER=postgres
      - PGSQL_DB_PASSWORD=some password
      - PGSQL_DB_RO_USER=readonly_user
      - PGSQL_DB_RO_PASSWORD=password
    volumes:
      - ./docker/pgsql/certificates:/ssl-cert:z
      - ssh-keys:/root/.ssh:ro
    links:
      - pgsql
      - pgsql-ssl
      - pgsql-ssl:pgsql-ssl-bad-cn
      - sshproxy

  dev:
    <<: *app
    volumes:
      - .:/code
      - ./data:/data
      - ./docker/pgsql/certificates:/ssl-cert:z
      - ssh-keys:/root/.ssh:ro,z

  pgsql: &pgsql
    build:
      args:
        version: ${PGSQL_VERSION}
      context: ./docker/pgsql
    image: keboola/pgsql-test:${PGSQL_VERSION}
    volumes:
      - ./docker/pgsql/init.sql:/docker-entrypoint-initdb.d/init.sql
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=some password

  pgsql-ssl:
    <<: *pgsql
    build:
      args:
        version: ${PGSQL_VERSION}
      context: ./docker/pgsql
    image: keboola/pgsql-ssl-test:${PGSQL_VERSION}
    command: -c hba_file=/etc/postgresql/pg_hba_ssl.conf -c ssl=on -c ssl_ca_file=/ssl-cert/ca-cert.pem -c ssl_cert_file=/ssl-cert/server-cert.pem -c ssl_key_file=/ssl-cert/server-key.pem

  wait:
    image: waisbrot/wait
    depends_on:
      - pgsql
      - pgsql-ssl
    environment:
      - TARGETS=pgsql:5432,pgsql-ssl:5432
      - TIMEOUT=200

  sshproxy:
    image: keboola/db-component-ssh-proxy:latest
    volumes:
      - ssh-keys:/root/.ssh:z
    links:
      - pgsql
      - pgsql-ssl

volumes:
  ssh-keys: