Add AWS RDS in N8N Dockerfile

Vaithiyanathan_S · September 16, 2021, 6:00pm

Can you please help me how can i include AWS RDS in n8n docker file which you have provided on your github repo and to build an image out of it

RicardoE105 · September 16, 2021, 10:55pm

AWS RDS it’s the name of the service. With this service, you can deploy multiple relational databases - PostgresSQL, MySQL, etc. Hence, you do not connect n8n to AWS RDS, but to the databases it deploys. Yet, you have to keep in mind that n8n does not support all databases AWS RDS deploy. But, n8n supports the most important ones (in my opinion).

If case you are using PostgreSQL, you can use the docker-compose below. Modifying the docker-compose to use MySQL should be simple.

github.com

n8n-io/n8n/blob/master/docker/compose/withPostgres/docker-compose.yml

version: '3.1'

services:

  postgres:
    image: postgres:11
    restart: always
    environment:
      - POSTGRES_USER
      - POSTGRES_PASSWORD
      - POSTGRES_DB
      - POSTGRES_NON_ROOT_USER
      - POSTGRES_NON_ROOT_PASSWORD
    volumes:
      - ./init-data.sh:/docker-entrypoint-initdb.d/init-data.sh

  n8n:
    image: n8nio/n8n
    restart: always
    environment:

This file has been truncated. show original

Jon · September 17, 2021, 12:23am

It is worth noting that the example compose file there includes a Postgres docker image which you don’t need. You would only need the n8n service from the compose file along with the Postgres environment options.

For MySQL replace POSTGRESDB with MYSQLDB

You can find the available options here: Databases | Docs

Vaithiyanathan_S · September 17, 2021, 7:16am

Thanks that works and updated my image