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?

aa ok thanks

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