Flyway support for Postgresql by version

Question

Other than looking over release notes, is there any way to find what versions of postgresql a given version of Flyway would support?

We are trying to upgrade some Postgresql 9.6 servers, so looking for the highest version of Flyway that would support Postgresql 9.6 so we can support both the existing 9.6 and a newer version of Postgresql.

Answer 1

It would be nice if there was a compatibility matrix of Flyway version against database version for each supported database in the docs but if such a thing exists, I haven't found it.

Instead, I've had to resort to a bit of git blame detective work.

For PostgreSQL, the minimum version is checked in PostgreSQLDatabase.java.

Viewing the Git Blame for that file, shows that the minimum community edition-supported version of PostgreSQL was changed to 10 in this commit, which first appeared in Flyway 8.0.0-beta1.

The previous minimum version was 9.5, which would work with your current database version of 9.6, and this can be found in Flyway 7.15.0, which is the latest release before 8.0.0-beta1.