The following PostgreSQL extensions are available, and can be enabled by running the CREATE EXTENSION command as avnadmin user.
Please note that some of the extensions have dependencies and they need to be created in the proper order. Also some extensions may require disconnecting the client connection and reconnecting before they are fully available.
List of supported extensions:
- aiven_extras (logical replication support)
- pg_partman (PostgreSQL 10 and older)
- pg_prometheus (PostgreSQL 10 to 12, see note below)
- pg_repack (PostgreSQL 10 and newer)
- plv8 (PostgreSQL 10 and older)
- postgis_legacy (see note below)
- timescaledb (PostgreSQL 10 and newer)
The postgis_legacy extension is not packaged or supported as an extension by the PostGIS project, the extension package is provided by Aiven for Aiven users.
The pg_prometheus extension has been sunset by Timescale in favor of promscale and is not supported for PostgreSQL 13.
Based on support requests, we may also install additional extension related files for your database. When requesting things not on the pre-approved list through a support ticket, be sure to remember to specify to which database service and to which particular user database you'd like to see us install them.
"Untrusted" language extensions such as plpythonu cannot be supported as they would compromise our ability to guarantee the highest possible service level.
If you have some other extensions you'd like to be supported, please give us a heads up on what you'd like to see in the future.
Got here by accident? Learn how Aiven simplifies Postgres: