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
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/
soroot@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