Skip to content

postgres.md

Latest commit

 

History

History
67 lines (45 loc) · 2.32 KB

postgres.md

File metadata and controls

67 lines (45 loc) · 2.32 KB
Raw

Postgres Module

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:

Using pgvector inside_block:pgvectorContainer

Using PostGIS inside_block:postgisContainer

Using TimescaleDB inside_block:timescaledbContainer

Adding this module to your project dependencies

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

=== "Gradle" groovy testImplementation "org.testcontainers:testcontainers-postgresql:{{latest_version}}" === "Maven" xml <dependency> <groupId>org.testcontainers</groupId> <artifactId>testcontainers-postgresql</artifactId> <version>{{latest_version}}</version> <scope>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.