Managed Service for TimescaleDB supports many PostgreSQL extensions. See available extensions for a full list.
You can add a supported extension to your database from the command line.
Some extensions have dependencies. When adding these, make sure to create them in the proper order.
Some extensions require disconnecting and reconnecting the client connection before they are fully available.
- Connect to your database as the
CREATE EXTENSION IF NOT EXISTS <extension_name>.
These extensions are available on Managed Service for TimescaleDB:
- aiven_extras (logical replication support)
- pg_partman (PostgreSQL 10 and older)
- pg_prometheus (PostgreSQL 10 and newer)
- pg_repack (PostgreSQL 10 and newer)
- plv8 (PostgreSQL 10 and older)
- postgis_legacy (see notes in this section)
postgis_legacy extension is not packaged or supported as an extension by the PostGIS project. Timescale provides the extension package for Managed Service for TimescaleDB.
You can request an extension not on the list by contacting Support. In your request, specify the database service and user database where you want to use the extension.
Untrusted language extensions are not supported. This restriction preserves our
ability to offer the highest possible service level. An example of an untrusted
language extension is
You can contact Support directly from Managed Service for TimescaleDB. Click the life-preserver icon in the upper-right corner of your dashboard.
Found an issue on this page?Report an issue!