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.