version: '3.8'

services:
  postgres:
    image: postgres:15-alpine
    container_name: ecoguide_postgres
    restart: unless-stopped
    environment:
      POSTGRES_USER: ${DB_USER:-ecoguide}
      POSTGRES_PASSWORD: ${DB_PASSWORD:-ecoguide_secret}
      POSTGRES_DB: ${DB_NAME:-ecoguide_db}
    ports:
      - '${DB_PORT:-5432}:5432'
    volumes:
      - postgres_data:/var/lib/postgresql/data
    healthcheck:
      test: ['CMD-SHELL', 'pg_isready -U ${DB_USER:-ecoguide}']
      interval: 10s
      timeout: 5s
      retries: 5

  pgadmin:
    image: dpage/pgadmin4:latest
    container_name: ecoguide_pgadmin
    restart: unless-stopped
    environment:
      PGADMIN_DEFAULT_EMAIL: admin@ecoguide.ai
      PGADMIN_DEFAULT_PASSWORD: admin123
    ports:
      - '5050:80'
    depends_on:
      postgres:
        condition: service_healthy
    volumes:
      - pgadmin_data:/var/lib/pgadmin

volumes:
  postgres_data:
  pgadmin_data: