Prevent migrations from running in parallel

[silverpill]

I have an application that runs migrations automatically at startup. However, in certain cases multiple instances of an application might be started at the same time, and that leads to conflicts (e.g. an instance fails because some table already exists).

What is the recommended way of dealing with this?

Driver: tokio-postgres.

[jxs]

Hi, does running tokio single threaded help?

[silverpill]

I don't expect it to help, because in my case there are different processes executing migrations, not different tasks within same process.

The problem might be solved by an exclusive lock on the migration table, for example.