PostgreSQL versions and extensions supported in Database Lab Engine
#
PostgreSQL versionsCurrently, Database Lab Engine fully supports the following PostgreSQL major versions:
- 9.6 (released: 2016-09-29; EOL: 2021-11-11)
- 10 (released: 2017-10-05; EOL: 2022-11-10)
- 11 (released: 2018-10-18; EOL: 2023-11-09)
- 12 (released: 2019-10-03; EOL: 2024-11-14)
- 13 (released: 2020-09-24; EOL: 2025-11-13)
- 14 (released: 2021-09-31; EOL: 2026-11-12)
By default, version 14 is used: postgresai/extended-postgres:14
.
The images are published in Docker Hub.
#
Extensions included by defaultBy default, the Database Lab Engine uses the extended Postgres.ai Docker images built on top of the official Docker images for PostgreSQL. It is easy to change the images – see the options named dockerImage
in various sections of the Database Lab Engine configuration.
All these extended images include the following extensions:
- all official "core" contrib modules
- logerrors (only for versions 10-14)
- bg_mon (only for versions 9.6-12)
- pg_auth_mon (only for versions 9.6-12)
- PoWA (only for versions 9.6-12)
- pg_hint_plan (only for versions 9.6-13)
- Timescale (only for versions 9.6-13)
- Citus
- HypoPG
- pg_cron
- pg_qualstats
- pg_repack
- pg_show_plans
- pg_stat_kcache
- pg_wait_sampling
- pg_timetable
- pgextwlist
- hll
- topn
- postgresql_anonymizer
- set_user
#
How to add more extensionsThere are two options:
- Adjust Dockerfile and build your own Docker image: https://gitlab.com/postgres-ai/custom-images
- Ask the Postgres.ai team for help – building custom Docker images is included in support contracts. Contact: [email protected]