PostgreSQL versions and extensions
#
PostgreSQL versionsCurrently, Database Lab Engine fully supports the following PostgreSQL major versions:
- 9.6
- 10
- 11
- 12
- 13
#
ExtensionsBy 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 extendProposals 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.