Using Postgres 16 with Spring Boot 3.3.0

Question

I just upgraded from spring-boot 3.2.3 -> 3.3.0. After the upgrade flyway refuses to connect to postgres:

Caused by: org.flywaydb.core.api.FlywayException: Unsupported Database: PostgreSQL 16.2
    at org.flywaydb.core.internal.database.DatabaseTypeRegister.getDatabaseTypeForConnection(DatabaseTypeRegister.java:105)
    at org.flywaydb.core.internal.jdbc.JdbcConnectionFactory.<init>(JdbcConnectionFactory.java:73)
    at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:134)
    at org.flywaydb.core.Flyway.migrate(Flyway.java:147)

What is the expected way to connect to postgres 16 using spring-boot 3.3.0 and flyway?

phuongnq1995 · Accepted Answer · 2024-05-27 14:45:44Z

62

There is pinned issue to announce about extracting database support out from flyway-core.

Try to add this dependency to your project:

<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-database-postgresql</artifactId>
</dependency>

answered May 27, 2024 at 14:45

phuongnq1995

1,73713 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Si Dou · Accepted Answer · 2024-07-03 09:20:26Z

10

in your pom.xml add this :

<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-database-postgresql</artifactId>
</dependency>
<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-core</artifactId>
    <version>10.15.2</version>
</dependency>

add also in your application.yml this :

spring:
  flyway:
    enabled: true
    locations: classpath:db/migration
    baseline-on-migrate: true

answered Jul 3, 2024 at 9:20

Si Dou

1013 bronze badges

1 Comment

javalonde Over a year ago

Will it work with Postgres 16.x ? I'm still getting org.flywaydb.core.api.FlywayException: Unsupported Database: PostgreSQL 16.3

Phillip · Accepted Answer · 2025-03-16 20:57:15Z

-1

My quick fix was lowering version of flyway dependency to:

<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-core</artifactId>
    <version>9.16.3</version>
</dependency>

answered Mar 16 at 20:57

Phillip

12 bronze badges

Collectives™ on Stack Overflow

Using Postgres 16 with Spring Boot 3.3.0

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related