n8n

gersonmonteiro/n8n Docker Image

gersonmonteiro查看中文加速指南

这是一个集成了Oracle的n8n镜像,用于工作流自动化和数据集成,可简化SQL查询执行、数据处理及多系统集成任务,实现流程自动化以提升工作效率。

2 次收藏下载次数: 0状态:社区镜像维护者:gersonmonteiro仓库类型:镜像最近更新:
下载命令
点击查看

🚀 Supercharge Your Workflow with n8n & Oracle Integration! 🔗

Tags: n8n, oracle, postgres, workflow-automation, data-integration, automation

Streamline your tasks and boost productivity by automating processes with n8n and seamless Oracle integration. 🚀 Whether you're running SQL queries, automating data processing, or integrating with various systems, this setup has got you covered!

💡 What can you do?

  • 🔗 Connect to Oracle: Easily connect to your Oracle database and automate tasks.
  • 💼 Process Automation: Execute SQL queries, automate actions, and manipulate data effortlessly.
  • ⚡ Simple and Ready-to-Use: Get up and running with minimal effort!

🚀 How to Run n8n and PostgreSQL with Docker Compose 🏃‍♂️

Running your own n8n automation platform with PostgreSQL is now easier than ever! To get started, simply run the following command:

🔥 Quick Start with Docker Compose

bash
docker-compose up -d

This will launch both n8n and PostgreSQL in the background.

⚙️ Docker Compose Configuration

yaml
version: '3.8'

volumes:
  db_storage:
  n8n_storage:

services:
  postgres:
    image: postgres:16
    restart: always
    ports:
      - 5432:5432
    environment:
      - POSTGRES_USER
      - POSTGRES_PASSWORD
      - POSTGRES_DB
      - POSTGRES_NON_ROOT_USER
      - POSTGRES_NON_ROOT_PASSWORD
    volumes:
      - db_storage:/var/lib/postgresql/data
      - ./init-data.sh:/docker-entrypoint-initdb.d/init-data.sh
    healthcheck:
      test: ['CMD-SHELL', 'pg_isready -h localhost -U ${POSTGRES_USER} -d ${POSTGRES_DB}']
      interval: 5s
      timeout: 5s
      retries: 10

  n8n:
    build: .
    restart: always
    environment:
      - DB_TYPE=postgresdb
      - DB_POSTGRESDB_HOST=postgres
      - DB_POSTGRESDB_PORT=5432
      - DB_POSTGRESDB_DATABASE=${POSTGRES_DB}
      - DB_POSTGRESDB_USER=${POSTGRES_NON_ROOT_USER}
      - DB_POSTGRESDB_PASSWORD=${POSTGRES_NON_ROOT_PASSWORD}
      - N8N_ENCRYPTION_KEY=<KEY>
      - N8N_PROXY_HOPS=1
    ports:
      - 5678:5678
    links:
      - postgres
    volumes:
      - n8n_storage:/home/node/.n8n
    depends_on:
      postgres:
        condition: service_healthy

🔧 PostgreSQL Initialization Script

To create the non-root PostgreSQL user, create a script called init-data.sh with the following content:

bash
#!/bin/bash
set -e;

if [ -n "${POSTGRES_NON_ROOT_USER:-}" ] && [ -n "${POSTGRES_NON_ROOT_PASSWORD:-}" ]; then
  psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
    CREATE USER ${POSTGRES_NON_ROOT_USER} WITH PASSWORD '${POSTGRES_NON_ROOT_PASSWORD}';
    GRANT ALL PRIVILEGES ON DATABASE ${POSTGRES_DB} TO ${POSTGRES_NON_ROOT_USER};
    GRANT CREATE ON SCHEMA public TO ${POSTGRES_NON_ROOT_USER};
EOSQL
else
  echo "SETUP INFO: No Environment variables given!"
fi

📦 Steps to Get Started:

  1. Set the Environment Variables:
    Define your POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_DB, POSTGRES_NON_ROOT_USER, and POSTGRES_NON_ROOT_PASSWORD either in your .env file or environment variables.

  2. Start the Services:
    Run the following to start the containers:

    bash
    docker-compose up -d
    
  3. Access n8n:
    Once the services are up, navigate to http://localhost:5678 to begin automating your workflows and integrating with Oracle! ⚙️🤖


💙 Support the Project

This Docker image is free to use! If you like it and want to support the development, *** donating:

🔗 ***** *s: ***

镜像拉取方式

您可以使用以下命令拉取该镜像。请将 <标签> 替换为具体的标签版本。如需查看所有可用标签版本,请访问 标签列表页面。

轩辕镜像加速拉取命令点我查看更多 n8n 镜像标签

docker pull docker.xuanyuan.run/gersonmonteiro/n8n:<标签>

DockerHub 原生拉取命令

docker pull gersonmonteiro/n8n:<标签>
专业版 · 高速稳定拉取镜像
50GB 仅 ¥8/年
高速镜像下载在线技术支持专业版保障服务可用付费会员免广告