Creating a Postgres database with JDBC Driver when starting a SpringBoot app?

Question

When I want to use a Mysql database in a Springboot app, I am able to create it on start via a string in properties similar to this:

spring.datasource.jdbc-url=jdbc:mysql://localhost:3306/testDb?createDatabaseIfNotExist=true&autoReconnect=true&useSSL=false&allowPublicKeyRetrieval=true

Nevertheless PostgreSQL seems to ignore this:

spring.datasource.jdbc-url=jdbc:postgresql://localhost:5432/testdb?createDatabaseIfNotExist=true&autoReconnect=true&useSSL=false&allowPublicKeyRetrieval=true

Is there a way to create a PostgreSQL db on start of a SpringBoot app before Flyway attempts to initiate tables?

Andy Wilkinson · Accepted Answer · 2021-05-18 08:41:14Z

2

Postgres doesn't support creating a database on demand via the JDBC URL. You can learn about what configuration is possible in the documentation.

answered May 18, 2021 at 8:41

Andy Wilkinson

117k25 gold badges279 silver badges259 bronze badges

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

Collectives™ on Stack Overflow

Creating a Postgres database with JDBC Driver when starting a SpringBoot app?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related