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-15)
- 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]