PostgreSQL versions and extensions

PostgreSQL versions

Currently, Database Lab Engine fully supports the following PostgreSQL major versions:

  • 9.6
  • 10
  • 11
  • 12
  • 13

Extensions

By default, Database Lab Engine uses the extended Postgres.ai Docker images built on top of the official Docker images for PostgreSQL. Use these images with Database Lab when you need non-standard Postgres extensions.

All these extended images include the following extensions:

Not included in the PostgreSQL 13 image (yet)

The PostgreSQL 13 image is now missing the following extensions (they will be added in the future):

  • hll
  • topn
  • citus
  • hypopg
  • pg_auth_mon
  • pg_hint_plan
  • powa
  • timescaledb

How to extend

Proposals to extend this list are welcome in the project repository: https://gitlab.com/postgres-ai/custom-images.

tip

If needed, you can specify any custom Docker image with PostgreSQL in the Database Lab Engine configuration. There is one requirement: such an image needs to use the directory /var/lib/postgresql/pgdata as PostgreSQL data directory (PGDATA).

Use this Dockerfile as an example. You can extend or modify it for your needs.