docker-compose-nextcloud-pgsql.yml

version: "3.9"

volumes:
  # Volume für Postgre-SQL und Postgre-Admin
  pgdb:
  pgadmin:

networks:
  # Die Netzwerke erstellt vom NginX Proxy Manager
  nginx_proxy_frontend:
    # add this if the network is already existing!
    external: true
  nginx_proxy_backend:
    # add this if the network is already existing!
    external: true

services:
  nextcloud-db:
    container_name: ${P_HOST}
    hostname: ${P_HOST}
    image: postgres:alpine
    restart: always
    volumes:
      - pgdb:/var/lib/postgresql/data
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro
    environment:
      # Postgre-SQL Environment
      POSTGRES_PASSWORD: ${P_PW}
      POSTGRES_DB: ${P_DB}
      POSTGRES_USER: ${P_U}
    healthcheck:
      # Healthcheck für den Datenbank Container
      test: ["CMD-SHELL", "pg_isready"]
      interval: 30s
      timeout: 5s
      retries: 5
    ports:
      - '${P_PORT}:5432'
    networks:
      - nginx_proxy_backend

  nextcloud-redis:
    image: redis:alpine
    container_name: ${R_CONTAINER}
    hostname: ${R_HOST}
    networks:
      - nginx_proxy_backend
    restart: unless-stopped
    #Redis Passwort eingeben
    command: redis-server --requirepass ${R_PW}
  
  # Optional
  nextcloud-pgadmin:
    container_name: ${PGADMIN_CONTAINER}
    depends_on:
      - ${R_HOST}
      - ${R_CONTAINER}
    image: dpage/pgadmin4:latest
    environment:
      # PGADMIN Environment
      PGADMIN_DEFAULT_EMAIL: ${PGADMIN_DEFAULT_EMAIL}
      PGADMIN_DEFAULT_PASSWORD: ${PGADMIN_DEFAULT_PASSWORD}
      PGADMIN_CONFIG_SERVER_MODE: 'False'
      POSTGRES_HOST: nc-postgres
    volumes:
      - pgadmin:/var/lib/pgadmin
    ports:
      - "${PGADMIN_PORT}:80"
    networks:
      - nginx_proxy_frontend
      - nginx_proxy_backend
    restart: unless-stopped
  #############  

  nextcloud-app:
    container_name: nc-app
    depends_on:
      - ${P_HOST}
      - ${R_CONTAINER}
    build: 
      context: .
      dockerfile: docker_nc_pgsql_app
    restart: always
    deploy:
      resources:
        limits:
          memory: 2048M
        reservations:
          memory: 500M
    ports:
      - '${NC_PORT}:80'
    volumes:
      - type: bind
        source: ${NC_SOURCE}
        target: /var/www/html
      - type: bind
        source: ${NC_DATA_SOURCE}
        target: /var/www/html/data
      - type: bind
        source: ${NC_SOURCE}/custom_apps
        target: /var/www/html/custom_apps
      - type: bind
        source: ${NC_SOURCE}/config 
        target: /var/www/html/config 
    healthcheck:
      # Healthcheck Nextcloud
      test: curl --fail http://localhost || exit 1
      interval: 30s
      retries: 5
      timeout: 10s
    environment:
      REDIS_HOST: ${R_HOST}
      # Redis Passwort von oben wieder eingeben
      REDIS_HOST_PASSWORD: ${R_PW}
      POSTGRES_PASSWORD: ${P_PW}
      POSTGRES_DB: ${P_DB}
      POSTGRES_USER: ${P_U}
      POSTGRES_HOST: ${P_HOST}
      POSTGRES_DB_PORT: ${P_PORT}     
      # Set overwriteprotocol to https to fix Remote Proxy Failure
      NC_overwriteprotocol: https
      # Set default_phone_region to DE=Germany
      NC_default_phone_region: DE
      # Set Default EMail Config
      SMTP_HOST: ${S_H}
      SMTP_SECURE: SSL
      SMTP_PORT: 465
      SMTP_NAME: ${S_U}
      SMTP_PASSWORD: ${S_PW}
      MAIL_FROM_ADDRESS: ${MAIL_FROM_ADDRESS}
      MAIL_DOMAIN: ${MAIL_DOMAIN}
    networks:
      - nginx_proxy_frontend
      - nginx_proxy_backend