pgweb/docker-compose.dev.yml at main · flowbi/pgweb · 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
services:
  postgres:
    container_name: pgweb-postgres
    image: postgres:15
    ports:
      - "5433:5432"
    volumes:
      - postgres_data:/var/lib/postgresql/data
    environment:
      POSTGRES_DB: postgres
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U postgres -h localhost"]
      interval: 5s
      timeout: 5s
      retries: 5
    networks:
      - pgweb

  pgweb:
    container_name: pgweb-dev
    build: .
    ports:
      - "8081:8081"
    depends_on:
      postgres:
        condition: service_healthy
    environment:
      # Override PGWEB_DATABASE_URL for production with URL-encoded password
      PGWEB_DATABASE_URL: ${PGWEB_DATABASE_URL:-postgres://pgweb_dev:pgweb_dev_password@postgres:5432/pgweb_test?sslmode=disable}
      PGWEB_TEST_ROLE: ${PGWEB_TEST_ROLE}
      PGWEB_CUSTOM_PARAMS: ${PGWEB_CUSTOM_PARAMS}
      # Font configuration
      PGWEB_FONT_FAMILY: ${PGWEB_FONT_FAMILY}
      PGWEB_FONT_SIZE: ${PGWEB_FONT_SIZE}
      PGWEB_GOOGLE_FONTS: ${PGWEB_GOOGLE_FONTS}
      # Query and metadata caching configuration
      PGWEB_DISABLE_QUERY_CACHE: ${PGWEB_DISABLE_QUERY_CACHE}
      PGWEB_DISABLE_METADATA_CACHE: ${PGWEB_DISABLE_METADATA_CACHE}
      PGWEB_QUERY_CACHE_TTL: ${PGWEB_QUERY_CACHE_TTL}
      PGWEB_METADATA_CACHE_TTL: ${PGWEB_METADATA_CACHE_TTL}
    command:
      [
        "./pgweb",
        "--url",
        "${PGWEB_DATABASE_URL:-postgres://pgweb_dev:pgweb_dev_password@postgres:5432/pgweb_test?sslmode=disable}",
        "--bind",
        "0.0.0.0",
        "--listen",
        "8081",
        "--debug",
      ]
    networks:
      - pgweb

volumes:
  postgres_data:
    name: pgweb_postgres_data

networks:
  pgweb:
    name: pgweb_dev