这是一个集成了Oracle的n8n镜像,用于工作流自动化和数据集成,可简化SQL查询执行、数据处理及多系统集成任务,实现流程自动化以提升工作效率。
🚀 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
bashdocker-compose up -d
This will launch both n8n and PostgreSQL in the background.
⚙️ Docker Compose Configuration
yamlversion: '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:
-
Set the Environment Variables:
Define yourPOSTGRES_USER,POSTGRES_PASSWORD,POSTGRES_DB,POSTGRES_NON_ROOT_USER, andPOSTGRES_NON_ROOT_PASSWORDeither in your.envfile or environment variables. -
Start the Services:
Run the following to start the containers:bashdocker-compose up -d -
Access n8n:
Once the services are up, navigate tohttp://localhost:5678to 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: ***
更多相关 Docker 镜像与资源
以下是 gersonmonteiro/n8n 相关的常用 Docker 镜像,适用于 工作流自动化、数据集成、任务编排 等不同场景:
镜像拉取方式
您可以使用以下命令拉取该镜像。请将 <标签> 替换为具体的标签版本。如需查看所有可用标签版本,请访问 标签列表页面。
DockerHub 原生拉取命令
用户好评
来自真实用户的反馈,见证轩辕镜像的优质服务