Managing Greenplum® extensions
Yandex MPP Analytics for PostgreSQL supports some Greenplum® extensions. See the full list of available extensions and their versions.
Retrieving a list of extensions available for installation
Connect to the selected database and run:
SELECT * FROM pg_available_extensions();
This will display a list of DB extensions available to install:
name | default_version | comment
------------------------+-----------------+------------------------------
diskquota | 1.0 | Disk Quota Main Program
...
Retrieving a list of installed extensions
Connect to the selected database and run:
SELECT extname FROM pg_extension;
A list of extensions installed in the DB is displayed:
extname
-------------------
plpgsql
...
Editing a list of installed extensions
Connect to the selected database and run:
CREATE EXTENSION <extension_name>;
For more information, see the relevant Greenplum® documentation
Supported Greenplum® extensions
|
Extension |
Version |
|
citext |
1.0 |
|
dblink |
1.1 |
|
diskquota |
1.0 |
|
fuzzystrmatch |
1.0 |
|
gp_internal_tools |
1.0.0 |
|
gp_url_tools |
1.0 |
|
hstore |
1.3 |
|
pgcrypto |
1.1 |
|
plperl |
1.0 |
|
plpgsql |
1.0 |
|
postgis |
2.1.5 |
|
postgres_fdw |
1.0 |
|
pxf |
2.0 |
|
uuid-cb |
1.0 |
|
Yezzey. Yandex Cloud extension Allows you to move AO and AOCO tables from the cluster storage to a cold storage and vice versa. To use this extension, enable hybrid storage in your Yandex MPP Analytics for PostgreSQL cluster. |
1.8 |
Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.