Backup Docker n8n with Postgresql

[JanHoedt]

Describe the problem/error/question

I have a Docker container running with n8n (latest version) and PostgreSQL with volumes mounted for data persistence and 2FA enabled. I’d like to create separate test and production environments for n8n, allowing an easy transition of workflows between environments, ideally through drag-and-drop functionality without the need to export. I’m also looking for a way to manage workflow versions.

Additionally, I’d like to know if there’s a way to unlock premium features locally without subscribing to n8n Cloud, as I’m a single user/hobbyist and paying a monthly fee isn’t feasible.

What is the error message (if any)?

No error message; I’m looking for guidance on environment setup and feature access.

Please share your workflow

(I will share specific workflows if needed for troubleshooting purposes.)

Share the output returned by the last node

Information on your n8n setup

• n8n version: Latest
• Database: PostgreSQL
• n8n EXECUTIONS_PROCESS setting: [Add current setting if known]
• Running n8n via: Docker
• Operating system: Docker

[n8n]

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:

[Jon]

Hey @JanHoedt,

Assuming you don’t want an enterprise license which is the only way to get the features you are after on a self hosted instance the other way would be through exporting and importing using the API.

You might be interested in this workflow created by a community member which could help you move things between your local environments: Import workflows and map their credentials using a Multi-Form | n8n workflow template

[JanHoedt]

Thanks! I hope the workflow is able to import all workflows. Transferring one at a time is no added value. That’s already there out of the box.