This topic provides an overview of the plug-ins and their versions that are supported by ApsaraDB RDS for PostgreSQL.
Note
- If your RDS instance does not support some plug-ins that are described in the following table, you must update your RDS instance to the latest minor engine version. For more information, see Update the minor engine version of an ApsaraDB RDS for PostgreSQL instance.
- If you have specific requirements or suggestions for the plug-ins that are described in the following table, you must submit a ticket.
| Plug-in | PostgreSQL 13 | PostgreSQL 12 | PostgreSQL 11 | PostgreSQL 10 | PostgreSQL 9.4 | Description |
|---|---|---|---|---|---|---|
| decoderbufs | 0.1.0 | 0.1.0 | None | None | None | This plug-in is used to generate data that is compatible with the Debezium platform based on the Protocol Buffers protocol. |
| address_standardizer | 2.5.4 | 2.5.4 | 2.5.4 | 2.5.4 | None | This plug-in is used to standardize the names of geographic locations based on Postal Address Geocoder (PAGC). For more information, see Tuning the Standardizer. |
| address_standardizer_data_us | 2.5.4 | 2.5.4 | 2.5.4 | 2.5.4 | None | This plug-in is used to standardize the names of the geographic locations in the United States based on PAGC. For more information, see Tuning the Standardizer. |
| aggs_for_arrays | None | None | None | 1.3.1 | None | This plug-in provides an extension function that is used to compute the statistics of numeric arrays. |
| bloom | 1.0 | 1.0 | 1.0 | 1.0 | None | This plug-in provides an index access method that is based on Bloom filters. |
| btree_gin | 1.3 | 1.3 | 1.3 | 1.2 | 1.0 | This plug-in provides sample Generalized Inverted Index (GIN) operator classes that are used to implement B-tree equivalent behavior for multiple data types and all enum types. |
| btree_gist | 1.5 | 1.5 | 1.5 | 1.5 | 1.0 | This plug-in provides sample GiST operator classes that are used to implement B-tree equivalent behavior for multiple data types and all enum types. |
| chkpass | None | None | None | 1.0 | 1.0 | This plug-in provides a data type that is used to store encrypted passwords. |
| citext | 1.6 | 1.6 | 1.5 | 1.4 | 1.0 | This plug-in provides a string type that is not case-sensitive. |
| cube | 1.4 | 1.4 | 1.4 | 1.2 | 1.0 | This plug-in provides a data type that is used to represent multidimensional cubes. |
| dblink | 1.2 | 1.2 | 1.2 | 1.2 | 1.1 | This plug-in is used to manage tables across databases. |
| dict_int | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This plug-in provides a sample add-on dictionary template that is used to run full-text searches. |
| earthdistance | 1.1 | 1.1 | 1.1 | 1.1 | 1.0 | This plug-in provides two different methods that are used to calculate great-circle distances on the surface of the Earth. |
| fuzzystrmatch | 1.1 | 1.1 | 1.1 | 1.1 | 1.0 | This plug-in is used to calculate the similarity and distance between strings. |
| ganos_address_standardizer | 3.7 | 3.7 | 3.7 | 3.7 | None | This plug-in is used to standardize the names of geographic locations based on PAGC. For more information, see Tuning the Standardizer. |
| ganos_address_standardizer_data_us | 3.7 | 3.7 | 3.7 | 3.7 | None | This plug-in is used to standardize the names of the geographic locations in the United States based on PAGC. For more information, see Tuning the Standardizer. |
| ganos_geometry | 3.7 | 3.7 | 3.7 | 3.7 | None | This plug-in is used to compute and analyze spatial geometries. |
| ganos_geometry_sfcgal | 3.7 | 3.7 | 3.7 | 3.7 | None | This plug-in is used to compute and analyze spatial geometries. |
| ganos_geometry_topology | 3.7 | 3.7 | 3.7 | 3.7 | None | This plug-in is an extension to the SFCGAL plug-in that is used to process spatial geometries. |
| ganos_networking | 3.7 | 3.7 | 3.7 | 3.7 | None | This plug-in is used to compute and analyze spatial network geometries. |
| ganos_pointcloud | 3.7 | 3.7 | 3.7 | 3.7 | None | This plug-in is used to store, compute, and analyze point clouds. |
| ganos_pointcloud_geometry | 3.7 | 3.7 | 3.7 | 3.7 | None | This plug-in is used to store, compute, and analyze point clouds. |
| ganos_raster | 3.7 | 3.7 | 3.7 | 3.7 | None | This plug-in is used to store, compute, and analyze spatial grids. |
| ganos_spatialref | 3.7 | 3.7 | 3.7 | 3.7 | None | This plug-in is used to compute and analyze spatial references. |
| ganos_tiger_geocoder | 3.7 | 3.7 | 3.7 | 3.7 | None | This plug-in is used to support the Topologically Integrated Geographic Encoding and Referencing (TIGER) data format that is used by the United States Census Bureau (USCB). |
| ganos_trajectory | 3.7 | 3.7 | 3.7 | 3.7 | None | This plug-in is used to compute and analyze objects in the moving object detection (MOD) system of Ganos. |
| hll | 2.15 | 2.14 | 2.14 | None | None | This plug-in is used to estimate business metrics, such as page views (PV) and unique visitors (UV), at high speeds. |
| hstore | 1.7 | 1.6 | 1.5 | 1.4 | 1.3 | This plug-in is used to store key-value pairs within a single PostgreSQL value. |
| imgsmlr | None | None | None | None | 1.0 | This plug-in is used to search for similar images. |
| intagg | 1.1 | 1.1 | 1.1 | 1.1 | 1.0 | This plug-in provides an integer aggregator and an enumerator. |
| intarray | 1.3 | 1.2 | 1.2 | 1.2 | 1.0 | This plug-in provides functions and operators that are used to manage null-free arrays of integers. |
| isn | 1.2 | 1.2 | 1.2 | 1.1 | 1.0 | This plug-in is used to validate input numbers and hyphenate output numbers based on a hard-coded list of prefixes. |
| jsonbx | None | None | None | None | 1.0 | This plug-in is an extension that is used in PostgreSQL 9.4 to support JSONB functions. |
| log_fdw | None | None | 1.0 | None | None | This plug-in is used to query the logs of an RDS instance. |
| ltree | 1.2 | 1.1 | 1.1 | 1.1 | 1.0 | This plug-in is used to represent the labels of the data that is stored in a hierarchical tree-like structure. |
| mysql_fdw | 1.1 | 1.1 | 1.1 | 1.1 | None | This plug-in is used to read and write data to a database on an ApsaraDB RDS for MySQL or self-managed MySQL instance. |
| orafce | None | None | 3.8 | 3.6 | 3.6 | This plug-in provides a number of Oracle-compatible functions. |
| oss_fdw | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This plug-in is used to read and write data to an Object Storage Service (OSS) bucket. |
| pase | None | None | 0.0.1 | None | None | This plug-in is used to search for vectors at high speeds. |
| pg_bigm | 1.2 | 1.2 | 1.2 | 1.2 | None | This plug-in is used to create a 2-gram GIN index that is used to accelerate full-text searches. |
| pg_buffercache | 1.3 | 1.3 | 1.3 | 1.3 | 1.0 | This plug-in is used to examine the shared buffer in real time. |
| pg_concurrency_control | None | None | 1.0 | 1.0 | 1.0 | This plug-in is used to control the concurrency of SQL statements. |
| pg_cron | None | 1.1 | 1.1 | 1.1 | None | This plug-in is used to configure scheduled tasks. |
| pg_freespacemap | 1.2 | 1.2 | 1.2 | 1.2 | 1.0 | This plug-in is used to examine the free space map (FSM). |
| pg_hint_plan | 1.3.7 | 1.3.7 | 1.3.7 | 1.3.0 | 1.1.3 | This plug-in is used to add hints to SQL statements. These hints are used to change the plans based on which SQL statements are executed. |
| pg_pathman | 1.5 | 1.5 | 1.5 | 1.5 | None | This plug-in is used to ensure high performance when you partition tables. |
| pg_prewarm | 1.2 | 1.2 | 1.2 | 1.1 | 1.0 | This plug-in is used to load data to the buffer of the operating system or PostgreSQL database engine. |
| pg_roaringbitmap | None | 0.5.0 | None | None | None | This plug-in is used to compute bitmaps. This increases query performance. |
| pg_sphere | None | None | None | 1 | 1 | This plug-in provides spherical data types, functions, operators, and indexes for PostgreSQL. |
| pg_stat_statements | 1.8 | 1.7 | 1.6 | 1.6 | 1.2 | This plug-in is used to track the statistics of all the SQL statements that are executed on the same server. |
| pg_trgm | 1.5 | 1.4 | 1.4 | 1.3 | 1.1 | This plug-in provides functions and operators that are used to calculate the similarity between alphanumeric texts. This plug-in also provides index operator classes that are used to search for similar strings at high speeds. |
| pgcrypto | 1.3 | 1.3 | 1.3 | 1.3 | 1.1 | This plug-in provides cryptographic functions for PostgreSQL. |
| pgrouting | None | None | 2.6.2 | 2.6.2 | 2.0.0 | This plug-in is used to compute and analyze spatial network geometries. |
| pgrowlocks | 1.2 | 1.2 | 1.2 | 1.2 | 1.1 | This plug-in provides a function that is used to display the row lock information of a specified table. |
| pgstattuple | 1.5 | 1.5 | 1.5 | 1.5 | 1.2 | This plug-in provides various functions that are used to obtain tuple-level statistics. |
| plperl | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This plug-in is used to support the Perl procedural language. |
| plpgsql | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This plug-in is used to support the SQL procedural language. |
| plproxy | 2.10.0 | 2.9.0 | 2.9.0 | 2.8.0 | None | This plug-in provides two modes that are used to access an RDS instance: CLUSTER and CONNECT. |
| pltcl | None | None | None | None | 1.0 | This plug-in is used to support the TCL procedural language. |
| plv8 | 2.3.13 | 2.3.13 | 2.3.13 | 1.4.2 | 1.4.2 | This plug-in is a trusted JavaScript language extension. |
| postgis | 2.5.4 | 2.5.4 | 2.5.4 | 2.5.4 | 2.2.8 | This plug-in is an extension that is used to process and store spatial geographic information. |
| postgis_sfcgal | 2.5.4 | 2.5.4 | 2.5.4 | 2.5.4 | None | This plug-in is an extension that is used to manage spatial geographic information in PostGIS. |
| postgis_tiger_geocoder | 2.5.4 | 2.5.4 | 2.5.4 | 2.5.4 | 2.2.8 | This plug-in is an extension that is used to manage PostGIS data in the TIGER format. |
| postgis_topology | 2.5.4 | 2.5.4 | 2.5.4 | 2.5.4 | 2.2.8 | This plug-in is an extension that is used to manage topological objects in PostGIS. |
| postgres_fdw | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This plug-in is used to manage tables across databases. |
| q3c | None | None | None | 1.5.0 | 1.5.0 | This plug-in is used to create spatial indexes on a sphere. |
| rdkit | None | 3.8 | None | None | 3.4 | This plug-in is used to support features such as molecular computing and search. |
| rum | 1.3 | 1.3 | 1.3 | 1.3 | None | This plug-in is used to run full-text searches at high speeds. |
| smlar | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This plug-in is used to calculate the similarity between two arrays of the same data type. |
| sslinfo | 1.2 | 1.2 | 1.2 | 1.2 | 1.0 | This plug-in is used to obtain information about the SSL certificate that is provided by the connected client. |
| tablefunc | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This plug-in provides a number of functions that are used to return tables. |
| tds_fdw | None | 2.0.1 | 2.0.1 | None | None | This plug-in is used to query data from an RDS instance that runs a different database engine than the connected RDS instance. |
| tsearch2 | None | None | None | None | 1.0 | This plug-in provides a text search feature that is compatible with earlier tsearch2 versions. |
| tsm_system_rows | 1.0 | 1.0 | 1.0 | None | None | This plug-in provides a table sampling method called SYSTEM_ROWS. |
| tsm_system_time | 1.0 | 1.0 | 1.0 | None | None | This plug-in provides a table sampling method called SYSTEM_TIME. |
| unaccent | 1.1 | 1.1 | 1.1 | 1.1 | 1.0 | This plug-in provides a text search dictionary that is used to remove accent marks (diacritic signs) from lexemes. |
| uuid-ossp | 1.1 | None | None | 1.1 | 1.0 | This plug-in provides functions that use a standard algorithm to generate universally unique identifiers (UUIDs). |
| varbitx | None | None | 1.0 | 1.0 | 1.0 | This plug-in is used to support various BIT-type operations. |
| wal2json | 2.3 | 2.3 | 2.2 | None | None | This plug-in is used to export logical log records as a file in the JSON format. |
| xml2 | 1.1 | 1.1 | 1.1 | 1.1 | 1.0 | This plug-in provides XPath query and XSLT functionality. |
| zhparser | 2.1 | 2.1 | 1.0 | 1.0 | 1.0 | This plug-in is used to support full-text searches in Chinese. |
| zombodb | None | None | 4.0 | None | None | This plug-in provides text indexing and analytics features. |
| pg_repack | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | None | This plug-in provides a feature that clears tablespaces. |