Hello! I am wondering if it is possible to run Ecto migrations with a different user than the regular user. Sometimes sysadmins restrict database access so the handle used by the app cannot drop or create tables. Has anyone set up a separate Ecto user/repo only for migrations?

Yes, of course it can be done. Not that easy with “regular” mix ecto.migrate, but there is several ways to do so: Create additional environment for migrations (for example MIX_ENV=migrate) and then create config/migrate.exs where you configure options for your migrations user (additionally you can…

Is it possible to run migrations as a different user?

Questions / Help

hauleth April 26, 2021, 5:44pm 5

In that case only option 2 will work for you.

2 Likes

Is it possible to "release" a mix task?