title: Flyway: Multiple nodes migrating in parallel with PgBouncer transaction pooling
body: <p>We're encountering issues with using Flyway for database migrations with multiple nodes in parallel, backed by a PostgreSQL database behind <a href="https://www.pgbouncer.org/features.html" rel="nofollow noreferrer">PgBouncer with transaction pooling</a>.</p>
  <p>The problem is that when multiple nodes start up at the same time, Flyway gets an exclusive lock but this seems to be a <em>session</em> lock, which isn't supported by PgBouncer transaction pooling (as multiple nodes may get the same session). This then causes each node to not start up because they've locked each other.</p>
  <p>Is there anything we can change or configure in Flyway to support this? We'd prefer not to switch away from transaction pooling if possible, as that's our main motivation for using PgBouncer.</p>