ERROR: type "geometry" does not exist when creating schema using PostGIS about embedded-database-spring-test HOT 4 CLOSED

Hi @cfecherolle. Try creating the following bean:

@Bean
public PostgreSQLContainerCustomizer postgresContainerCustomizer() {
    return container -> container.withDatabaseName("template1");
}

It ses the $POSTGRES_DB property to the template1 database, which is used as a template for creating all new databases. Maybe I could set this setting as default, but I need to check the possible drawbacks first.

from embedded-database-spring-test.

Hi @tomix26,

Thanks for the help!
Actually, I forgot to post here but I found a solution to my issue last week. As you said, this can work by using Flyway to execute the CREATE EXTENSION query in a migration script before tests.
I intend to use Flyway soon in my app anyway, so the added weight from the new dependencies was not a deal breaker to me.

If it can help others, here is what I did:

1. Added these dependencies to my pom.xml:

<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-core</artifactId>
    <version>6.5.7</version>
</dependency>
<dependency>
    <groupId>org.flywaydb.flyway-test-extensions</groupId>
    <artifactId>flyway-spring-test</artifactId>
    <version>6.4.0</version>
    <scope>test</scope>
</dependency>

2. Added @FlywayTest annotation to the tests which require PostGIS to create their database schema.

3. Added a migration file V1__create-postgis-extension.sql containing CREATE EXTENSION IF NOT EXISTS postgis;

4. Adapted my Spring Boot configuration to enable Flyway and set the correct location to my migration file:

spring:
  # Flyway migrations are enabled for this profile in order to create (= enable) the PostGIS extension
  # Without this hack to enable extension creation, the database schema cannot be created with DDL auto because of missing data types (such as geometry)
  flyway:
    enabled: true
    locations: classpath:/db/migration/<your_migrations_directory>

The database name fix looks good too and would be lighter, so I'm going to try it too.

from embedded-database-spring-test.

By the way, you could also add extension registration to flyway or liquibase scripts, that would work too.

from embedded-database-spring-test.

... And the PostgreSQLContainerCustomizer bean solution also works, without Flyway 🎉 Thank you!

from embedded-database-spring-test.