I have managed to start up an instance of n8n with config data stored in a Postgres DB. When I start this up with the
postgres user (which has ALL privileges), the instance connects 100%. When I try to connect with a user with only
SELECT, INSERT, UPDATE, DELETE privileges it does not work.
I then tried to first start up with the
postgres user, after which the tables were correctly created, and then connect to the same DB (which now contains the n8n tables) with the limited user. But, still not connecting - I suspect this is because n8n, on startup ALWAYS runs the migrations.
I have 2 questions:
(1) What are the exact permission required for the DB user?
(2) Is there a way to start the instance without migrations?