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

  • SillyLilBearBEnglish
    1·
    1 year ago

    docker w/ postgres, but really up to you. Either would be fine.

  • adamshandBEnglish
    1·
    1 year ago

    It’s mostly just preference. If you are already familiar with MySQL or Postgres, use what you know. If you just want simple and lightweight, use it with SQLite (no external database).

    • roycorderovOPBEnglish
      1·
      1 year ago

      I will create a lxc conteiner in my proxmox just for him so my question would be… which one would be more secure that it will not have problems in the future? for example that it is slower or easier to be damaged or lose information or that it lacks some feature, do you know what I mean?

      • adamshandBEnglish
        1·
        1 year ago

        Use SQLite. Easy to backup, no process taking up cpu/memory, no users to manage.

  • Sudden_Cheetah7530BEnglish
    1·
    1 year ago

    If you design an application, choosing database would be a big deal, but since you are the user, you can choose whatever you want. My go to is postgre though.

    • roycorderovOPBEnglish
      1·
      1 year ago

      I will create a lxc conteiner in my proxmox just for him so my question would be… which one would be more secure that it will not have problems in the future? for example that it is slower or easier to be damaged or lose information or that it lacks some feature, do you know what I mean? but ok i wil go with a database thanks!

  • roycorderovOPBEnglish
    1·
    1 year ago

    ok… I couldn’t install docker with postgres so I did it with sql and that’s it I hope I don’t miss out in the future because I will have to look for someone to help me install it thanks friends

  • roycorderovOPBEnglish
    1·
    1 year ago

    thanks I will go for postgres database because of what I have been advised and additionally because I have been told that soon n8n will remove mysql/mariadb support.

  • roycorderovOPBEnglish
    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