Redgate Summit – The Database DevOps Transformation Watch now
PASS Data Community Summit logo

PASS Data Community Summit

A hybrid conference in Seattle and online

15-18 November

Flyway Documentation

This documentation is deprecated. The new documentation can now be found on documentation.red-gate.com

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>