n8n icon indicating copy to clipboard operation
n8n copied to clipboard

Published 20 hours ago • verified publisher icon n8n-io

feat(config): PG&MySQL run migration configurable

Open wei840222 opened this issue 2 years ago • 3 comments

in some private cloud env, we want to run n8n with db account which is no DDL permision. so I want to make run schema migration behavior configurable to prevent n8n keep crashing when db account can't run DDL SQL command.

wei840222 avatar Nov 23 '22 15:11 wei840222

CLA assistant check
All committers have signed the CLA.

CLAassistant avatar Nov 23 '22 15:11 CLAassistant

@wei840222 If you disable the migrationsRun flag, the migrations still need to be executed manually. How are you doing that right now? That could be valuable information to document.

netroy avatar Nov 24 '22 11:11 netroy

@netroy I run n8n with mysql db by docker-compose in local computer, and I dump db schema manualy. I run migrations by dumped files before I deploy n8n.

wei840222 avatar Nov 24 '22 11:11 wei840222

We decided that while we understand why a customer might need this option, we don't want to officially support an option to disable migrations. If we ever change our minds, we can re-open and rebase this PR 🙏🏽

netroy avatar Jun 24 '24 08:06 netroy