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 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 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 PostgreSQL extensions

All supported extensions are listed here: