PostgreSQL extension management

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

Getting a list of extensions

If you don't have Yandex.Cloud CLI, install 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 flag.

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

$ yc managed-postgresql database get <DB 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.

Updating a set of extensions

If you don't have Yandex.Cloud CLI, install 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 flag.

To enable or disable PostgreSQL DB extensions, 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 <DB 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 PostgreSQL extensions

Below is a full list of supported extensions: