PostgreSQL versions and extensions supported in Database Lab Engine
PostgreSQL versions​
Currently, 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)
- 15 (released: 2022-10-13; EOL: 2027-11-11)
- 16 (released: 2023-09-14; EOL: 2028-11-09)
By default, version 15 is used: postgresai/extended-postgres:15
.
The images are published in Docker Hub.
Extensions included by default​
By 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
- pgvector (only for Postgres 11+)
- logerrors (only for Postgres 10+)
- bg_mon
- pg_auth_mon (only for Postgres 9.6-15)
- PoWA
- pg_hint_plan
- Timescale (only for Postgres 12-16)
- Citus (only for Postgres 11+)
- HypoPG
- pg_cron
- pg_qualstats
- pg_repack
- pg_show_plans (only for Postgres 12+)
- pg_stat_kcache
- pg_wait_sampling
- pg_timetable
- pgextwlist
- hll
- topn (only for Postgres 10+)
- postgresql_anonymizer
- pgaudit
- set_user (only for Postgres 9.6-15)
How to add more extensions​
There 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]