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:
- all official "core" contrib modules
- bg_mon
- Citus
- HypoPG
- pg_auth_mon
- pg_cron
- pg_hint_plan
- pg_qualstats
- pg_repack
- pg_show_plans
- pg_stat_kcache
- pg_timetable
- pgextwlist
- hll
- topn
- postgresql_anonymizer
- PoWA
- set_user
- Timescale
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.