So this fixes it, but I’m not 100% sure it actually is the resolution. Let me explain. I’ve matched my previous docker-compose.yml file that I’ve had previous discussions around to include the storage volume like this:
- ${DATA_FOLDER}/postgres-data:/var/lib/postgresql/data
Now, that allows the data to survive reboots and docker downs and docker ups. However, and this is the issue I ran into the last time I self-hosted N8N, there is no postgres-data folder under /root/n8n, which is set as the DATA_FOLDER in .env.
DATA_FOLDER=/root/n8n/
There is a letsencrypt (traefik) folder and a .n8n folder (n8n), but no postgres-data folder. This is the issue I ran into via Update n8n (Docker), but decided against troubleshooting as I moved to n8n cloud.