which is the best solution to selfhosted n8n? - eviltoast

hi folks i am starting to use n8n and i want to do some automations in my kommo crm and other things, but i have seen that there are several ways to install n8n in a self hosted way, so my question is for those who have n8n as self hosted services,

which would be the best way to install it?

- docker without database?
- docker with database and which database would be better postgress or mysql?
thanks

  • roycorderov@alien.topOPBEnglish
    1·
    1 year ago

    Please, I’m struggling with the docker-compose with postgres to get my n8n up and running… so just copy the docker-compose from the doc and made changes for my needs, could you tell me if im doin it rigth? or should I change something?

    i want all data in: /docker/n8n/ so

    root@13-n8n-RL23-WG /docker/n8n# nano .env

    POSTGRES_USER=user-root

    POSTGRES_PASSWORD=password-root

    POSTGRES_DB=n8n

    POSTGRES_NON_ROOT_USER=user-nonroot

    POSTGRES_NON_ROOT_PASSWORD=password-nonroot

    root@13-n8n-RL23-WG /docker/n8n# nano docker-compose.yml

    version: '3.8'

    volumes:

    db_storage:

    n8n_storage:

    services:

    postgres:

    image: postgres:11

    restart: always

    environment:

    - POSTGRES_USER

    - POSTGRES_PASSWORD

    - POSTGRES_DB

    - POSTGRES_NON_ROOT_USER

    - POSTGRES_NON_ROOT_PASSWORD

    volumes:

    - /docker/n8n/postgresql/data:/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:

    image: docker.n8n.io/n8nio/n8n

    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}

    - WEBHOOK_URL=https://subdomain.wtf.org/

    - EXECUTIONS_PROCESS=main

    - GENERIC_TIMEZONE=America/La_Paz

    - TZ=America/La_Paz

    ports:

    - 5678:5678

    links:

    - postgres

    volumes:

    - /docker/n8n:/home/node/.n8n

    depends_on:

    postgres:

    condition: service_healthy