docker-compose.yml

version: "3.7"

volumes:
  caddy_data:
  caddy_config:
  shiny_apps:
  postgis_data:

services:
  caddy:
    container_name: caddy
    image: caddy:latest
    ports:
      - "80:80"
      - "443:443"
    restart: unless-stopped
    volumes:
      - ./caddy/Caddyfile:/etc/caddy/Caddyfile
      - caddy_data:/data
      - caddy_config:/config
      - /share:/share    

  rstudio:
    build:
      context: ./rstudio
      args:
        PASSWORD: $PASSWORD
    container_name: rstudio
    environment:
      ROOT: 'true'
      USER: admin
      PASSWORD: $PASSWORD
      ADD: shiny
    ports:
      - 8787:8787
      - 3838:3838
    restart: unless-stopped
    volumes:
      - /share:/share    
      - shiny_apps:/srv/shiny-server
      
  postgis:
    container_name: postgis
    image: postgis/postgis:17-3.5
    environment:
      POSTGRES_DB: gis
      POSTGRES_USER: admin
      POSTGRES_PASSWORD: $PASSWORD
    volumes:
      - postgis_data:/var/lib/postgresql
      - ./postgis/postgresql.conf:/etc/postgresql/postgresql.conf
      - /share:/share
    restart: unless-stopped
    healthcheck:
      test: 'exit 0'
    ports:
      - 5432:5432
      
  pg_backups:
    container_name: pg_backups
    image: prodrigestivill/postgres-backup-local:17
    restart: always
    user: postgres:postgres # Optional: see below
    volumes:
      - /share/pg_backups:/backups
      # sudo mkdir /share/pg_backups; sudo chown -R 999:999 /share/pg_backups
    links:
      - postgis
    depends_on:
      - postgis
    environment:
      - POSTGRES_HOST=postgis
      - POSTGRES_DB=gis
      - POSTGRES_USER=admin
      - POSTGRES_PASSWORD=${PASSWORD}
      - POSTGRES_EXTRA_OPTS=-Z6 --blobs
      - SCHEDULE=@daily
      #- SCHEDULE='0 19 * * * *'
      - BACKUP_KEEP_DAYS=7
      - BACKUP_KEEP_WEEKS=4
      - BACKUP_KEEP_MONTHS=6
      - HEALTHCHECK_PORT=8000

  rclone:
    build: ./rclone
    container_name: rclone
    restart: unless-stopped
    logging:
      driver: 'json-file'
      options:
        max-size: '10m'
        max-file: '10'
    volumes:
      - /share/rclone:/config/rclone
      - /share:/share

  pgadmin:
    container_name: pgadmin
    image: dpage/pgadmin4:latest
    restart: always
    environment:
      PGADMIN_DEFAULT_EMAIL: ben@ecoquants.com
      PGADMIN_DEFAULT_PASSWORD: ${PASSWORD}
      PGADMIN_LISTEN_PORT: 8088
      #PGADMIN_CONFIG_CONFIG_DATABASE_URI: "'postgresql://admin:$PASSWORD@postgis:5432/gis'"
      # test: psql -h postgis -U admin -d gis
    ports:
      - 8088:8088
    volumes:
      - /share/pgadmin:/var/lib/pgadmin
    depends_on:
      - postgis

  plumber:
    container_name: plumber
    build: ./plumber
    ports:
      - 8888:8888
    restart: unless-stopped
    volumes:
      - /share:/share
    depends_on:
      - postgis

  pg_tileserv:
    container_name: pg_tileserv
    environment:
      DATABASE_URL: postgres://admin:$PASSWORD@postgis:5432/gis
    image: pramsey/pg_tileserv:latest
    build:
      context: ./pg_tileserv
      dockerfile: Dockerfile.alpine
      args: 
        VERSION: latest
    depends_on:
      - postgis
    ports:
      - 7800:7800

  pg_rest:
    container_name: pg_rest
    environment:
      PGRST_DB_URI: postgres://ro_user:$ROPASS@postgis:5432/gis
      # {"code":"PGRST000","details":"could not translate host name \"lcof1@postgis\"
      PGRST_OPENAPI_SERVER_PROXY_URI: http://127.0.0.1:3000
      PGRST_DB_ANON_ROLE: ro_user  # db-anon-role
    image: postgrest/postgrest
    depends_on:
      - postgis
    ports:
      - "3000:3000"

  pg_swagger:
    container_name: pg_swagger
    image: swaggerapi/swagger-ui
    depends_on:
      - pg_rest
    ports:
      - "8080:8080"
    expose:
      - "8080"
    environment:
      API_URL: https://rest.calcofi.io/

  erddap:
    container_name: erddap
    image: erddap/erddap:latest
    restart: unless-stopped
    ports:
      - "8090:8080"
    volumes:
      - /share/github/CalCOFI/erddap/content:/usr/local/tomcat/content/erddap
      - /share/erddap/data:/erddapData
      - /share/erddap/datasets:/datasets
    environment:
      ERDDAP_MEMORY: 4g
      ERDDAP_baseUrl: http://localhost:8090
      ERDDAP_baseHttpsUrl: https://erddap.calcofi.io
      ERDDAP_bigParentDirectory: /erddapData/
      ERDDAP_adminInstitution: CalCOFI
      ERDDAP_adminInstitutionUrl: https://calcofi.io
      ERDDAP_adminIndividualName: CalCOFI Data Manager
      ERDDAP_adminPosition: Data Manager
      ERDDAP_adminCity: La Jolla
      ERDDAP_adminStateOrProvince: CA
      ERDDAP_adminPostalCode: "92037"
      ERDDAP_adminCountry: USA
      ERDDAP_adminEmail: calcofi@ucsd.edu

  h3t_api:
    container_name: h3t_api
    build: /share/github/CalCOFI/api-h3t
    restart: unless-stopped
    environment:
      DUCKDB_PATH: /data/calcofi_latest.duckdb
      H3T_PORT: 8889
      H3T_HOST: 0.0.0.0
      RETICULATE_PYTHON: /opt/venv/bin/python3
    volumes:
      # mount the released DuckDB files read-only. calcofi_latest.duckdb
      # should be a symlink to the current versioned release
      # (e.g. calcofi_v2026.04.08.duckdb).
      - /share/github/int-app/data:/data:ro
    expose:
      - "8889"

  varnish:
    container_name: varnish
    image: varnish:7
    restart: unless-stopped
    environment:
      VARNISH_SIZE: 1G
    volumes:
      - ./varnish/default.vcl:/etc/varnish/default.vcl:ro
    expose:
      - "80"
    depends_on:
      # Varnish compiles its VCL at startup, which resolves the backend
      # hostname via DNS. If h3t_api isn't running yet, compile fails.
      h3t_api:
        condition: service_healthy