docker-compose.postgres.yml

# Optional PostgreSQL storage. Combine with the matching SQLite-default base
# using -f base.yml -f this-file.yml. No profiles: unused PG credentials and
# services are absent from the base model. Changing files is not a conversion;
# use the documented offline storage switch before changing an installed backend.
services:
  postgres:
    extends:
      file: docker/postgres.compose.yml
      service: postgres
    volumes:
      - ${PROD_POSTGRES_DATA_DIR:-~/corescope-postgres}:/var/lib/postgresql
  bootstrap:
    extends:
      file: docker/postgres.compose.yml
      service: bootstrap
    image: corescope:latest
    volumes:
      - ${PROD_DATA_DIR:-~/meshcore-data}:/app/data
  prod:
    depends_on:
      bootstrap:
        condition: service_completed_successfully
    environment:
      CORESCOPE_DB_BACKEND: postgres
      CORESCOPE_READER_DATABASE_URL: postgresql://corescope_reader:${CORESCOPE_READER_PASSWORD:?Set CORESCOPE_READER_PASSWORD}@postgres:5432/corescope_telemetry?sslmode=disable&search_path=public
      CORESCOPE_WRITER_DATABASE_URL: postgresql://corescope_writer:${CORESCOPE_WRITER_PASSWORD:?Set CORESCOPE_WRITER_PASSWORD}@postgres:5432/corescope_telemetry?sslmode=disable&search_path=public
      CORESCOPE_USERS_DATABASE_URL: postgresql://corescope_accounts:${CORESCOPE_ACCOUNTS_PASSWORD:?Set CORESCOPE_ACCOUNTS_PASSWORD}@postgres:5432/corescope_accounts?sslmode=disable&search_path=public
      CORESCOPE_APPROVED_CHANNELS_DATABASE_URL: postgresql://corescope_channels:${CORESCOPE_CHANNELS_PASSWORD:?Set CORESCOPE_CHANNELS_PASSWORD}@postgres:5432/corescope_accounts?sslmode=disable&search_path=public