Installation of n8n on Render.com / Best Practice?

Questions
1

Describe the problem/error/question

Hi - I tried to install n8n on Render.com.
This is what I tried:
1/ 1 project for 2 services: PostGres DB & n8n (via Docker).
For the latter (n8n) I passed on

  • the envir vars of the postgresDB
  • the N8N_ENCRYPTION_KEY & N8N_ACTIVATION_KEY

The first as I read not doing that causes n8n to produce a different one at rebot (and in doing so making your credentials inaccessible). The latter as I noticed it kept loosing the activation key so that way it takes care of itself.

What is the error message (if any)?

The problem is: when I log in & out, all seems OK.
Yet, even if I believe this is the smoothest way to do it, it still makes my Credentials & Workflows inaccessible after a (docker) container reboot.

How is that possible, it should keep all in the DB.
Is there an obvious mistake I make?

Information on your n8n setup

  • n8n version:: 1.78 (via Docker on Render.com)
  • Database : Postgress (on Render.com)
  • n8n EXECUTIONS_PROCESS setting (default: own, main): self-hosting on Render.com (free tier)
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker.
  • Operating system: Sarari on OSX.
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

? Bots… it’s all there man.

5

hello @Wicked_AI_Ware

have you set a volume for the docker container? However it should not be a problem if you have a separate DB instance, as all data are stored there.

And is your DB also resides in the docker?

6

I switched to running Postgres on Supabase and pointed there from my Render environment. That solved the problem.
It also solves a more important issue: running a DB on Render means all content only will be kept for 1 month. On Supabase all is kept.
So I’m happy with the final result.

1 Like
7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.