Docker

docker-compose-2.yml

version: '2'

services:
   db:
      image: postgres
      environment:
         POSTGRES_PASSWORD: "pupupu"
         POSTGRES_DB: "pupupu"
      volumes:
       - /home/vboxuser/postgresql_data:/var/lib/postgresql/data
      healthcheck:
        test: ["CMD-SHELL", "pg_isready -U postgres"]
        interval: 5s
        timeout: 5s
        retries: 5
   webapp:
      image: pupupu:6e73271_16_01_24
      environment:
         host_name: "postgres"
         host_port: "5432"
         db_name: "pupupu"
         postgres_password: "pupupu"
         backend_password: "pupupu"
      links:
        - db:postgres
      ports:
        - 80:8000
      depends_on:
        db:
          condition: service_healthy

docker-compose-3.yml

version: '3.8'

services:
  postgres:
    image: postgres:16-alpine
    container_name: n8n_postgres
    restart: unless-stopped
    environment:
      POSTGRES_DB: n8n
      POSTGRES_USER: n8n
      POSTGRES_PASSWORD: n8n
    volumes:
      - /n8n/db_data:/var/lib/postgresql/data
    networks:
      - n8n-network
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U n8n -d n8n"]
      interval: 10s
      timeout: 5s
      retries: 5

  n8n:
    image: n8nio/n8n:latest
    container_name: n8n
    restart: unless-stopped
    ports:
      - "5678:5678"
    environment:
      N8N_RUNNERS_ENABLED: "true"
      N8N_RUNNERS_MODE: "internal"   
      N8N_BLOCK_ENV_ACCESS_IN_NODE: "true"
      N8N_HOST: 0.0.0.0
      N8N_PORT: 5678
      N8N_PROTOCOL: https
      VUE_APP_URL: https://n8n.ru
      DB_TYPE: postgresdb
      DB_POSTGRESDB_HOST: postgres
      DB_POSTGRESDB_PORT: 5432
      DB_POSTGRESDB_DATABASE: n8n
      DB_POSTGRESDB_USER: n8n
      DB_POSTGRESDB_PASSWORD: n8n
      N8N_ENCRYPTION_KEY: n8n
      N8N_WEBHOOK_URL: https://n8n.ru
      N8N_LOG_LEVEL: info
    volumes:
      - /n8n/ai_data:/home/node/.n8n
      - /n8n/logs:/n8n-logs
    depends_on:
      postgres:
        condition: service_healthy
    networks:
      - n8n-network

networks:
  n8n-network:
    driver: bridge

docker-compose-4.yml

version: '3.8'

services:
  postgres:
    image: postgres:16-alpine
    container_name: n8n_postgres
    restart: unless-stopped
    environment:
      POSTGRES_DB: n8n
      POSTGRES_USER: n8n
      POSTGRES_PASSWORD: n8n
    volumes:
      - /n8n/db_data:/var/lib/postgresql/data
    networks:
      - n8n-network
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U n8n -d n8n"]
      interval: 10s
      timeout: 5s
      retries: 5

  n8n:
    build: .
    container_name: n8n
    restart: unless-stopped
    ports:
      - "5678:5678"
    environment:
      N8N_RUNNERS_ENABLED: "true"
      N8N_RUNNERS_MODE: "internal"
      N8N_BLOCK_ENV_ACCESS_IN_NODE: "true"
      N8N_HOST: 0.0.0.0
      N8N_SECURE_COOKIE: "false"
      N8N_PORT: 5678
      N8N_PROTOCOL: https
      VUE_APP_URL: https://n8n.ru
      DB_TYPE: postgresdb
      DB_POSTGRESDB_HOST: postgres
      DB_POSTGRESDB_PORT: 5432
      DB_POSTGRESDB_DATABASE: n8n
      DB_POSTGRESDB_USER: n8n
      DB_POSTGRESDB_PASSWORD: n8n
      N8N_ENCRYPTION_KEY: n8n
      N8N_WEBHOOK_URL: https://n8n.ru
      N8N_LOG_LEVEL: info
      N8N_EXECUTE_COMMAND_MODE: allow
    volumes:
      - /srv/n8n-data:/home/node/.n8n
      - /n8n/logs:/n8n-logs
      - ./gemini-project:/usr/src/app/gemini-project
    depends_on:
      postgres:
        condition: service_healthy
    networks:
      - n8n-network

networks:
  n8n-network:
    driver: bridge

docker-compose.yml

services:
  db:
    image: postgres:latest
    container_name: postgres_db
    environment:
      POSTGRES_DB: db_name       # Имя вашей базы данных
      POSTGRES_USER: pg_user         # Имя пользователя
      POSTGRES_PASSWORD: 12345678  # Пароль пользователя
    ports:
      - "5432:5432"                  # Порт для доступа  PostgreSQL
    volumes:
      - postgres_data:/var/lib/postgresql/data

volumes:
  postgres_data:

Docker.md

Установка Docker

sudo apt update
sudo usermod -aG docker shilgen
sudo apt install -y docker.io

Установка Docker Compose

sudo curl -L "https://github.com/docker/compose/releases/download/v2.23.0/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
sudo chmod +x /usr/local/bin/docker-compose

Проверка установки

docker --version
docker-compose --version
docker info

Запуск демона

systemctl start docker

Запуск контейнера

Выполните команду в директории с файлом docker-compose.yml:

docker-compose up -d

Проверка статуса

docker ps
systemctl status docker

Вход в psql консоль внутри docker контейнера

docker exec -it postgres_db psql -U myuser -d mydatabase

Вход в bash консоль внутри docker контейнера

docker exec -it postgres_db bash

Проверка сохранения данных

docker volume inspect postgres_data

Остановка контейнера

docker-compose down

Остановка контейнера с удалением данных

docker-compose down -v

Чтение ошибок

docker logs postgres_db

alembic upgrade head
uvicorn main:app --host 0.0.0.0 --port 8000

FROM python:3.11.10

WORKDIR /opt

COPY /source .
COPY start.sh .
RUN pip3 install --upgrade pip
RUN pip3 install -r requirements.txt

ENTRYPOINT ["/bin/bash","./start.sh"]