New! – Try automated migration testing Learn more

Flyway Documentation

Poll

PostgreSQL Transactional Lock

Description

Whether or not transactional advisory locks should be used with PostgreSQL.

If false, session-level locks will be used instead.

Default

true

Usage

Commandline

./flyway -postgresql.transactional.lock=false info

Configuration File

flyway.postgresql.transactional.lock=false

Environment Variable

FLYWAY_POSTGRESQL_TRANSACTIONAL_LOCK=false

API

PostgreSQLConfigurationExtension configurationExtension = configuration.getPluginRegister().getPlugin(PostgreSQLConfigurationExtension.class)
configurationExtension.setTransactionalLock(false);

Gradle

flyway {
    pluginConfiguration [
      postgresqlTransactionalLock: false
    ]
}

Maven

<configuration>
    <pluginConfiguration>
        <postgresqlTransactionalLock>false</postgresqlTransactionalLock>
    </pluginConfiguration>
</configuration>