docker-database

Docker Database Infrastructure

Services Overview

Database Services

• db - PostgreSQL 17 with PostGIS extension (Port 5432)
• elasticsearch - Elasticsearch 7.17.27 for Temporal visibility (Port 9200)

PostgreSQL Configuration

Image Version (DO NOT CHANGE)

db:
  image: postgis/postgis:17-3.5

Why PostGIS? Provides PostgreSQL with geospatial extensions (PostGIS, pg_trgm, etc.)

Service Definition

db:
  image: postgis/postgis:17-3.5
  environment:
    - POSTGRES_USER=${POSTGRES_USER}
    - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
    - POSTGRES_DB=${POSTGRES_DB}
    - POSTGRES_PORT=${POSTGRES_PORT:-5432}
  ports:
    - "${POSTGRES_PORT:-5432}:5432"
  volumes:
    - postgres-data:/var/lib/postgresql/data
  networks:
    - projectx-network
  restart: unless-stopped

Health Check

healthcheck:
  test: ["CMD-SHELL", "pg_isready -U $$POSTGRES_USER -d $$POSTGRES_DB"]
  interval: 5s
  timeout: 5s
  retries: 60
  start_period: 30s

Why these settings?

• interval: 5s - Check frequently during startup
• retries: 60 - Allow up to 5 minutes for startup (60 × 5s)
• start_period: 30s - Grace period before health checks count as failures

Data Persistence

volumes:
  postgres-data:
    driver: local
services:
  db:
    volumes:
      - postgres-data:/var/lib/postgresql/data

Data persists across container restarts.

PostgreSQL Extensions

PostGIS Image Includes

• postgis - Geospatial extension
• postgis_topology - Topology support
• postgis_tiger_geocoder - US address geocoding
• fuzzystrmatch - Fuzzy string matching
• postgis_sfcgal - 3D geometry support
• pg_trgm - Trigram matching for text search

Used by Prisma

The project uses Prisma ORM which connects to this PostgreSQL instance. Connection String Format:

postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@db:${POSTGRES_PORT}/${POSTGRES_DB}

Elasticsearch Configuration

Image Version (DO NOT CHANGE)

elasticsearch:
  image: elasticsearch:7.17.27

Why 7.17.27? Compatible with Temporal Server 1.29.2