docker-compose.yml

services:
  postgres:
    image: pgduckdb/pgduckdb:16-main
    volumes:
      - postgresql_bin:/usr/lib/postgresql
      - postgresql_data:/var/lib/postgresql/data
    environment:
      POSTGRES_DB: ${DB_NAME_PROD} 
      POSTGRES_USER: ${DB_USER_PROD}
      POSTGRES_PASSWORD: ${DB_PASS_PROD}
    healthcheck:
      test: ["CMD", "pg_isready", "-U", "postgres"]
      interval: 10s
      timeout: 5s
      retries: 5
    ports:
      - "5432:5432"
    networks:
      - mynetwork

  backend-1:
    hostname: backend-1
    build: 
      context: ./app/backend
      dockerfile: Dockerfile
    volumes:
      - ./app/backend:/main
    environment:
      DB_HOST_PROD: ${DB_HOST_PROD}  
      DB_PORT_PROD: ${DB_PORT_PROD}
      DB_NAME_PROD: ${DB_NAME_PROD}
      DB_USER_PROD: ${DB_USER_PROD}
      DB_PASS_PROD: ${DB_PASS_PROD}
    env_file:
    - .env
    ports:
      - "8001:8000"
    depends_on:
      - postgres
    networks:
      - mynetwork

  backend-2:
    hostname: backend-2
    build: 
      context: ./app/backend
      dockerfile: Dockerfile
    volumes:
      - ./app/backend:/main
    environment:
      DB_HOST_PROD: ${DB_HOST_PROD}  
      DB_PORT_PROD: ${DB_PORT_PROD}
      DB_NAME_PROD: ${DB_NAME_PROD}
      DB_USER_PROD: ${DB_USER_PROD}
      DB_PASS_PROD: ${DB_PASS_PROD}
    env_file:
    - .env
    ports:
      - "8002:8000"
    depends_on:
      - postgres
    networks:
      - mynetwork

  backend-3:
    hostname: backend-3
    build: 
      context: ./app/backend
      dockerfile: Dockerfile
    volumes:
      - ./app/backend:/main
    environment:
      DB_HOST_PROD: ${DB_HOST_PROD}  
      DB_PORT_PROD: ${DB_PORT_PROD}
      DB_NAME_PROD: ${DB_NAME_PROD}
      DB_USER_PROD: ${DB_USER_PROD}
      DB_PASS_PROD: ${DB_PASS_PROD}
    env_file:
    - .env
    ports:
      - "8003:8000"
    depends_on:
      - postgres
    networks:
      - mynetwork

  nginx:
    image: nginx:latest
    ports:
      - "80:80"
    volumes:
      - ./nginx.conf:/etc/nginx/nginx.conf
    depends_on:
      - backend-1
      - backend-2
      - backend-3
    networks:
      - mynetwork

  frontend:
    build: 
      context: ./app/frontend
      dockerfile: Dockerfile
    volumes:
      - ./app/frontend:/app
    env_file:
    - .env
    ports:
      - "8501:8501"
    networks:
      - mynetwork

  pgadmin:
    image: dpage/pgadmin4:latest
    environment:
      PGADMIN_DEFAULT_EMAIL: ${PGADMIN_EMAIL}
      PGADMIN_DEFAULT_PASSWORD: ${PGADMIN_PASSWORD}
      PGADMIN_LISTEN_PORT: 5050
      PGADMIN_CONFIG_SERVER_MODE: 'False'
    volumes:
      - postgresql_bin:/usr/lib/postgresql
      - pgadmin_root_prefs:/root/.pgadmin
      - pgadmin_working_dir:/var/lib/pgadmin
    ports:
      - 5050:5050
    depends_on:
      - postgres
    networks:
      - mynetwork

  briefer:
    image: briefercloud/briefer:latest
    environment:
      BRIEFER_DB_HOST: ${DB_HOST_PROD}
      BRIEFER_DB_PORT: ${DB_PORT_PROD}
      BRIEFER_DB_NAME: ${DB_NAME_PROD}
      BRIEFER_DB_USER: ${DB_USER_PROD}
      BRIEFER_DB_PASSWORD: ${DB_PASS_PROD}
    ports:
      - "3000:3000"
    depends_on:
      - postgres
    networks:
      - mynetwork

  n8n:
    image: docker.n8n.io/n8nio/n8n
    restart: always
    environment:
      - DB_TYPE=postgresdb
      - DB_POSTGRESDB_HOST=${DB_HOST_PROD}
      - DB_POSTGRESDB_PORT=${DB_PORT_PROD}
      - DB_POSTGRESDB_DATABASE=${DB_NAME_PROD}
      - DB_POSTGRESDB_USER=${DB_USER_PROD}
      - DB_POSTGRESDB_PASSWORD=${DB_PASS_PROD}
      - GENERIC_TIMEZONE=${GENERIC_TIMEZONE}
    ports:
      - 5678:5678
    links:
      - postgres
    volumes:
      - n8n_storage:/home/node/.n8n
    depends_on:
      postgres:
        condition: service_healthy
    networks:
      - mynetwork

  minio:
    image: minio/minio
    container_name: minio
    environment:
      MINIO_ROOT_USER: minioadmin
      MINIO_ROOT_PASSWORD: minioadmin
    ports:
      - "9000:9000"
      - "9001:9001"
    command: server /data --console-address ":9001"
    volumes:
      - minio_data:/data
    networks:
      - mynetwork
      
networks:
  mynetwork:
    driver: bridge

volumes:
  pgadmin_root_prefs:
    driver: local
  pgadmin_working_dir:
    driver: local
  postgresql_data:
    driver: local
  postgresql_bin:
    driver: local
  minio_data:
    driver: local
  n8n_storage:
    driver: local