Setting the PostgreSQL version

By default, pg-embedded uses a PostgreSQL 13 database. This version can be changed in multiple ways:

• call Builder.setServerVersion() on the EmbeddedPostgres.Builder
• call Builder.withInstancePreparer(b -> b.setServerVersion(...)) on the DatabaseManagerBuilder
• set the pg-embedded.postgres-version system property

Setting the system property overrides all other settings.

pg-embedded downloads repackaged EnterpriseDB PostgreSQL releases from the Maven repository system using the io.zonky.test.postgres groupId. Any artifact available here can be used with pg-embedded as long as the version and binary architecture is supported.

• More information about Zonky.IO PostgreSQL binaries.
• List of all available PostgreSQL versions. Only 9.6 and later versions are supported by pg-embedded, older versions might still work but are unsupported (please do not file bug reports about older versions).

The FlywayPreparer only supports PostgreSQL 10+.