Postgres Module - Testcontainers for Java Sourcey Reference

Testcontainers module for PostgresSQL

Usage example

You can start a PostgreSQL container instance from any Java application by using:

Container creation inside_block:container

See Database containers for documentation and usage that is common to all relational database container types.

Testcontainers JDBC URL

PostgreSQL: jdbc:tc:postgresql:9.6.8:///databasename
PostGIS: jdbc:tc:postgis:9.6-2.5:///databasename
TimescaleDB: jdbc:tc:timescaledb:2.1.0-pg13:///databasename
PGvector: jdbc:tc:pgvector:pg16:///databasename

See JDBC for documentation.

Compatible images

PostgreSQLContainer can also be used with the following images:

pgvector/pgvector

Using pgvector inside_block:pgvectorContainer

postgis/postgis

Using PostGIS inside_block:postgisContainer

timescale/timescaledb

Using TimescaleDB inside_block:timescaledbContainer

Adding this module to your project dependencies

Add the following dependency to your pom.xml/build.gradle file:

Gradle

testImplementation "org.testcontainers:testcontainers-postgresql:{{latest_version}}"

Maven

&lt;dependency&gt;
    &lt;groupId&gt;org.testcontainers</groupId>
    &lt;artifactId&gt;testcontainers-postgresql</artifactId>
    &lt;version&gt;{{latest_version}}</version>
    &lt;scope&gt;test</scope>
</dependency>

Hint Adding this Testcontainers library JAR will not automatically add a database driver JAR to your project. You should ensure that your project also has a suitable database driver as a dependency.