How can I persist n8n credentials and workflows on Render using Docker with Postgres?

I'm trying to run n8n on Render.com using Docker with two services: one for Postgres and one for n8n. I set the n8n service with the following environment variables:

• Postgres DB configuration
• N8N_ENCRYPTION_KEY (to avoid generating a new key on reboot)
• N8N_ACTIVATION_KEY (to prevent loss of activation key)

The intended setup is to store all data (credentials and workflows) in the Postgres DB. However, after logging in/out or when the Docker container restarts, my credentials and workflows become inaccessible, which indicates that the persistent data might not be saved despite using a database. I suspect there's an issue with how data is persisted between container restarts.

What's the best practice to ensure that all necessary n8n data is retained across container reboots? I've read about mounting volumes for folder /home/node/.n8n, but I'm not sure if this is the complete solution. Below is an example of a Docker run command that mounts the volume:

SHCopied
docker volume create n8n_data

docker run -it --rm \
  --name n8n \
  -p 5678:5678 \
  -e DB_TYPE=postgresdb \
  -e DB_POSTGRESDB_DATABASE=<POSTGRES_DATABASE> \
  -e DB_POSTGRESDB_HOST=<POSTGRES_HOST> \
  -e DB_POSTGRESDB_PORT=<POSTGRES_PORT> \
  -e DB_POSTGRESDB_USER=<POSTGRES_USER> \
  -e DB_POSTGRESDB_SCHEMA=<POSTGRES_SCHEMA> \
  -e DB_POSTGRESDB_PASSWORD=<POSTGRES_PASSWORD> \
  -e N8N_ENCRYPTION_KEY=<your_custom_key> \
  -e N8N_ACTIVATION_KEY=<your_activation_key> \
  -v n8n_data:/home/node/.n8n \
  docker.n8n.io/n8nio/n8n

Any insights or corrections to this setup would be appreciated.