docker_sql_csv_loader/docker-compose.yml at main · poboisvert/docker_sql_csv_loader · 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
version: '3.9'

services:
  db:
    image: postgres
    restart: always
    environment:
      POSTGRES_USER: sqlpad
      POSTGRES_PASSWORD: sqlpad
    healthcheck:
      test: ['CMD-SHELL', 'pg_isready -U sqlpad']
      interval: 10s
      timeout: 5s
      retries: 5
    logging:
      options:
        max-size: 10m
        max-file: '3'
    volumes:
      - ./data:/data/
      - ./db:/var/lib/postgresql/data
      - ./sql:/docker-entrypoint-initdb.d/

  sqlpad:
    image: sqlpad/sqlpad:6
    depends_on:
      - db
    hostname: 'sqlpad'
    ports:
      - '3000:3000'
    environment:
      SQLPAD_ADMIN: 'admin@admin.com'
      SQLPAD_AUTH_DISABLED_DEFAULT_ROLE: 'admin'
      SQLPAD_AUTH_DISABLED: 'true'
      SQLPAD_APP_LOG_LEVEL: debug
      SQLPAD_WEB_LOG_LEVEL: warn
      SQLPAD_CONNECTIONS__psql__name: psql_conn
      SQLPAD_CONNECTIONS__psql__driver: postgres
      SQLPAD_CONNECTIONS__psql__host: db
      #SQLPAD_CONNECTIONS__psql__database: sqlpad
      SQLPAD_CONNECTIONS__psql__username: sqlpad
      SQLPAD_CONNECTIONS__psql__password: sqlpad
      SQLPAD_CONNECTIONS__psql__multiStatementTransactionEnabled: 'true'
      SQLPAD_CONNECTIONS__psql__idleTimeoutSeconds: 86400

volumes:
  postgres:
    driver: local
  sqlpad:
    driver: local