roycorderovB
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
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
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.
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!
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?
I got my proxmox in production and I’ve installed before whatschtower and just broke me down 4 containers with bad updates so I stoped from using whatschtower…
I would like any services that just notify me about any new docker image update whitout making any updating