Get started
Yandex Managed Service for PostgreSQL

Managing PostgreSQL extensions

Managed Service for PostgreSQL supports many standard and some non-standard PostgreSQL extensions. A full list of available extensions is given below.

How to get a list of extensions

If you don't have the Yandex.Cloud command line interface yet, install and initialize it.

The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name or --folder-id parameter.

To get a list of extensions for a specific database, run the command:

$ yc managed-postgresql database get <database name> \
     --cluster-name <cluster name>

The enabled extensions will be listed in the extensions list.

To get a list of extensions for the cluster database, use the get method.

How to change a set of extensions

If you don't have the Yandex.Cloud command line interface yet, install and initialize it.

The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name or --folder-id parameter.

To enable or disable PostgreSQL extensions for a database, pass the full list of the required extensions in a CLI command. The enabled extensions that aren't in that list will be disabled.

$ yc managed-postgresql database update <database name> \
     --cluster-name <cluster name>
     --extensions <extension name>=<version>,<extension name>=<version>...

Note

The extension version is not considered when handling the command: you can pass any non-empty string as a version.

To pass a new list of DB extensions, use the update method.

Supported extensions PostgreSQL

All supported extensions are listed here:

In this article: