This topic provides an overview of the extensions and extension versions that are supported by ApsaraDB RDS for PostgreSQL instances.
If your RDS instance does not support a few extensions that are described in the following table, you must update the minor engine version of your RDS instance to the latest version. For more information, see Update the minor engine version.
The following table describes only common extensions. To query the extensions that are supported by your RDS instance, you can execute the
SELECT * FROM pg_available_extensions;
statement.Before you use some extensions, you must add the names of the extensions to the value of the shared_preload_libraries parameter of your RDS instance. Otherwise, you cannot create the extensions.
The extensions include pg_stat_statements, auth_delay, passwordcheck, auto_explain, pg_pathman, orafce, pgaudit, pglogical, pg_bigm, pg_cron, pg_hint_plan, pg_prewarm, zhparser, timescaledb, pldebugger, pg_jieba, pg_squeeze, and rds_duckdb.
If you want to use the pldebugger extension, you must add
plugin_debugger
to the value of the shared_preload_libraries parameter of your RDS instance.
For more information about how to configure the shared_preload_libraries parameter, see Manage the parameters of an ApsaraDB RDS for PostgreSQL instance.
The following tables describe the extensions that are supported by the standard and YiTian RDS instances. For more information, see Product types.
To streamline extension management and improve extension security, vulnerable extensions are optimized in minor engine version iterations. The optimized extensions can no longer be created for RDS instances that run earlier minor engine versions. The existing extensions are not affected. For more information, see [Product changes/Feature changes] Limits on extension creation for ApsaraDB RDS for PostgreSQL instances.
Standard RDS instances
Extension | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | Description |
Not supported | 3.3.4 | 3.3.2 | 3.1.4 | 3.1.4 | 3.1.4 | 3.1.4 | 3.1.4 | This extension is used to standardize the names of geographical locations based on Postal Address Geocoder (PAGC). For more information, see Tuning the Standardizer. | |
Not supported | 3.3.4 | 3.3.2 | 3.1.4 | 3.1.4 | 3.1.4 | 3.1.4 | 3.1.4 | This extension is used to standardize the names of the geographical locations in the United States based on PAGC. For more information, see Tuning the Standardizer. | |
Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | 1.3.1 | This extension provides an extension function that is used to compute the statistics of numeric arrays. | |
Not supported | 1.5.0 | 1.5.0 | 1.5.0 | Not supported | Not supported | Not supported | Not supported | This extension enables users to leverage a graph database on top of existing PostgreSQL databases. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension provides an index access method that is based on Bloom filters. | |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.2 | This extension provides sample GIN operator classes that are used to implement B-tree equivalent behavior for multiple data types or all enumerated data types. | |
1.7 | 1.7 | 1.7 | 1.6 | 1.5 | 1.5 | 1.5 | 1.5 | This extension provides sample GiST operator classes that are used to implement B-tree equivalent behavior for multiple data types and all enumerated data types. | |
Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | 1.0 | This extension provides a data type that is used to store encrypted passwords. | |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.5 | 1.4 | This extension provides a string type that is not case-sensitive. | |
1.5 | 1.5 | 1.5 | 1.5 | 1.4 | 1.4 | 1.4 | 1.2 | This extension provides a data type that is used to represent multidimensional cubes. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | This extension is used to manage tables across databases. | |
Not supported | Not supported | Not supported | Not supported | 0.1.0 | 0.1.0 | 0.1.0 | 0.1.0 | This extension is used to generate data that is compatible with the Debezium platform based on the Protocol Buffers protocol. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension provides a sample add-on dictionary template that is used to run full-text searches. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This extension provides two different methods that are used to compute great-circle distances on the surface of the Earth. | |
1.1.14 | 1.1.14 | 1.1.14 | 1.1.14 | 1.1.14 | 1.1.14 | 1.1.14 | 1.1.13 | This extension is used to provide the always-confidential database feature. | |
1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | This extension is used to accelerate ciphertext queries on always-confidential databases. | |
1.2 | 1.2 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This extension is used to compute the similarity and distance between strings. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to standardize the names of geographical locations based on PAGC. For more information, see Tuning the Standardizer. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to standardize the names of the geographical locations in the United States based on PAGC. For more information, see Tuning the Standardizer. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to compute and analyze spatial geometries. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to display 2D geometric big data at high speeds. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is an extension of the SFCGAL extension and is used to process spatial geometries. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to compute and analyze spatial geometries. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used for the meshing, coding, indexing, and analysis of grids such as H3 and GeoSOT grids. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to compute and analyze spatial network geometries. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to store, compute, and analyze point clouds. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to store, compute, and analyze point clouds. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to store, compute, and analyze spatial grids. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to compute and analyze spatial references. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to support the TIGER data format that is used by the USCB. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to compute and analyze objects in the moving object detection (MOD) system of Ganos. | |
Not supported | 2.18 | 2.18 | 2.18 | 2.15 | 2.14 | 2.14 | Not supported | This extension is used to estimate business metrics, such as page views (PV) and unique visitors (UV), in an efficient manner. | |
1.8 | 1.8 | 1.8 | 1.8 | 1.7 | 1.6 | 1.5 | 1.4 | This extension is used to store key-value pairs within a single PostgreSQL value. | |
Not supported | 1.4.1 | 1.4.1 | 1.4.1 | 1.3.1 | 1.3.1 | 1.3.1 | 1.3.1 | This extension is used to create virtual indexes. | |
2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | This extension provides index recommendations. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This extension provides an integer aggregator and an enumerator. | |
1.5 | 1.5 | 1.5 | 1.5 | 1.3 | 1.2 | 1.2 | 1.2 | This extension provides functions and operators that are used to manage null-free arrays of integers. | |
Not supported | 2.4 | 2.4 | 2.4 | 2.4 | Not supported | Not supported | Not supported | This extension is used to store IPv4 and IPv6 addresses in PostgreSQL. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.1 | This extension is used to validate input numbers and hyphenate output numbers based on a hard-coded list of prefixes. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.1 | 1.1 | 1.1 | This extension is used to label the data that is stored in a hierarchical tree structure. | |
Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | 1.0 | Not supported | This extension is used to query the logs. | |
Not supported | Not supported | Not supported | Not supported | Not supported | 1.18.0 | 1.18.0 | Not supported | This extension is an open source library that is used for machine learning and graph computing models. | |
Not supported | 1.2 | 1.2 | 1.2 | 1.1 | 1.1 | 1.1 | 1.1 | This extension is used to read and write data to an ApsaraDB RDS for MySQL instance or a self-managed MySQL database. | |
Not supported | Not supported | Not supported | Not supported | Not supported | 1.1 | Not supported | Not supported | This extension is used to synchronize the update operations on the tables of an ApsaraDB RDS for PostgreSQL instance to the tables of an Oracle database. | |
Not supported | 4.9.2 | 4.9.2 | 4.9.2 | Not supported | Not supported | 3.8 | 3.6 | This extension provides functions that are compatible with Oracle. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This extension is used to read data from and write data to an OSS bucket. | |
Not supported | 0.0.1 | 0.0.1 | 0.0.1 | 0.0.1 | 0.0.1 | 0.0.1 | Not supported | This extension is used to search for vectors in an efficient manner. | |
Not supported | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | This extension is used to create a 2-gram Generalized Inverted Index (GIN) that is used to accelerate full-text searches. | |
1.4 | 1.4 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | This extension is used to examine shared buffers in real time. | |
Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | 1.0 | 1.0 | This extension is used to control the concurrency of SQL statements. | |
Not supported | 1.6 | 1.6 | 1.6 | 1.5 | 1.1 | 1.1 | 1.1 | This extension is used to configure scheduled tasks. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | This extension is used to examine the FSM. | |
Not supported | 1.2.0 | 1.2.0 | 1.2.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | This extension is used to segment Chinese text. | |
Not supported | 1.6.0 | 1.5.0 | 1.4.0 | 1.3.7 | 1.3.7 | 1.3.7 | 1.3.0 | This extension is used to add hints to SQL statements. The hints are used to change the execution plans of SQL statements. | |
Not supported | 5.1.0 | 5.1.0 | 5.1.0 | 4.7.3 | 4.7.3 | Not supported | Not supported | This extension is used to create and manage time-based and sequence-based table partition sets. | |
Not supported | Not supported | Not supported | Not supported | 1.5 | 1.5 | 1.5 | 1.5 | This extension is used to partition tables at high performance. | |
Not supported | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.1 | This extension is used to load data to the buffer of the operating system or PostgreSQL database engine. | |
Not supported | 4.4 | 4.4 | 4.4 | 4.1 | 4.1 | 4.1 | 4.1 | This extension is used to collect statistics on resource-intensive activities. | |
Not supported | 0.0.10 | 0.0.10 | 0.0.10 | 0.0.10 | 0.0.10 | 0.0.10 | Not supported | This extension allows you to access the processes and resource consumption data in an operating system by using SQL statements. | |
Not supported | 1.5.0 | 1.5.0 | 1.5.0 | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | This extension is used to clear tablespaces that stay online. | |
Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | 1.0 | This extension provides spherical data types, functions, operators, and indexes for PostgreSQL. | |
Not supported | 2.2.3 | 2.2.3 | 2.2.3 | 2.2.1 | 2.2.1 | 2.2.1 | 2.2.1 | This extension is used to collect statistics on read and write operations in file systems. | |
1.10 | 1.10 | 1.10 | 1.9 | 1.8 | 1.7 | 1.6 | 1.6 | This extension is used to track the statistics of all SQL statements that are executed on a specified server. | |
1.6 | 1.6 | 1.6 | 1.6 | 1.5 | 1.4 | 1.4 | 1.3 | This extension provides functions and operators that are used to compute the similarity between alphanumeric texts. This extension also provides index operator classes that are used to search for similar strings in an efficient manner. | |
Not supported | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | Not supported | This extension is used to shrink bloated tables and indexes online. | |
Not supported | 16.0 | 1.6.1 | 1.6.1 | 1.5 | 1.4.1 | 1.3.2 | 1.2.2 | This extension is used to generate audit logs that contain the details about sessions and objects. | |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | This extension provides cryptographic functions for PostgreSQL. | |
Not supported | 2.2 | 2.2 | 2.2 | 2.1 | Not supported | Not supported | Not supported | This extension supports transparent DDL replication. | |
Not supported | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.2 | 2.4.2 | 2.4.0 | 2.4.0 | This extension provides the logical streaming replication feature by using a publish/subscribe pattern. | |
Not supported | 3.4.2 | 3.4.2 | 3.4.2 | 3.4.2 | 3.4.2 | 3.4.2 | 3.4.2 | This extension is used to compute and analyze spatial network geometries. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | This extension provides a function that is used to display the row lock information about a specific table. | |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | This extension provides various functions that are used to obtain tuple-level statistics. | |
Not supported | 0.7.4 | 0.7.4 | 0.7.4 | Not supported | Not supported | Not supported | Not supported | This extension is used for high-dimensional vector similarity search. | |
Not supported | Not supported | Not supported | Not supported | 1.1 | 1.1 | 1.1 | 1.1 | This extension is used to debug the stored procedures of an ApsaraDB RDS for PostgreSQL instance. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to support the Perl procedural language. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to support the SQL procedural language. | |
Not supported | 2.11.0 | 2.10.0 | 2.10.0 | 2.10.0 | 2.9.0 | 2.9.0 | 2.8.0 | This extension provides the CLUSTER and CONNECT modes in which an ApsaraDB RDS for PostgreSQL instance can be accessed. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to support the TCL procedural language. | |
Not supported | Not supported | Not supported | 2.3.15 | 2.3.15 | 2.3.15 | 2.3.15 | 2.3.15 | This extension is a trusted JavaScript language extension. | |
Not supported | 3.3.4 | 3.3.2 | 3.3.2 | 3.3.2 | 3.3.2 | 3.3.2 | 3.3.2 | This extension is used to process and store the information about spatial geographical locations in PostGIS. | |
Not supported | 3.3.4 | 3.3.2 | 3.3.2 | 3.3.2 | 3.3.2 | 3.3.2 | 3.3.2 | This extension is an extension that is used to manage spatial geographic information in PostGIS. | |
Not supported | 3.3.4 | 3.3.2 | 3.3.2 | 3.3.2 | 3.3.2 | 3.3.2 | 3.3.2 | This extension is used to manage PostGIS data in the TIGER format. | |
Not supported | 3.3.4 | 3.3.2 | 3.3.2 | 3.3.2 | 3.3.2 | 3.3.2 | 3.3.2 | This extension is used to manage topological objects in PostGIS. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to manage tables across databases. | |
Not supported | Not supported | 1.1.0 | 1.1.0 | Not supported | Not supported | Not supported | Not supported | This extension is used for data anonymization and data masking. | |
Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | 1.5.0 | This extension is used to create spatial indexes on a sphere. | |
Not supported | Not supported | Not supported | Not supported | Not supported | 3.8 | Not supported | Not supported | This extension is used to support features such as molecular computing and search. | |
1.1 | 1.1 | 1.0 | 1.0 | Not supported | Not supported | Not supported | Not supported | This extension is used for SQL throttling. | |
rds_duckdb | Not supported | 1.0 | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | This extension is used to accelerate complex queries. |
Not supported | 1.0 | 1.0 | 1.0 | Not supported | Not supported | Not supported | Not supported | This extension provides custom model configuration and model invocation capabilities to convert text to vectors in a database. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to encrypt and decrypt tables and indexes at a time by using TDE. | |
Not supported | 0.5.4 | 0.5 | 0.5 | 0.5 | 0.5 | Not supported | Not supported | This extension is used to compute bitmaps to increase query performance. | |
Not supported | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | This extension is used to efficiently run full-text searches. | |
Not supported | 1.0.2 | 1.0.2 | 1.0.2 | 1.0.2 | 1.0.2 | 1.0.2 | 1.0.2 | This extension is used to generate sequential UUIDs. | |
Not supported | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to compute the similarity between two arrays of the same data type. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | This extension is used to obtain information about the SSL certificate that is provided by the connected client. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension provides functions that are used to return tables. | |
Not supported | 2.0.3 | 2.0.3 | 2.0.3 | 2.0.3 | 2.0.3 | 2.0.3 | Not supported | This extension is used to query data from an ApsaraDB RDS instance that does not run PostgreSQL. | |
Not supported | 2.14.2 | 2.9.2 | 2.9.2 | 2.5.0 | 1.7.1 | 1.7.1 | 1.3.0 | This extension is used to support features such as automatic sharding, efficient writes, retrieval, and near real-time aggregation of time series data. | |
Not supported | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension provides the table sampling method SYSTEM_ROWS. | |
Not supported | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension provides the table sampling method SYSTEM_TIME. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This extension provides a text search dictionary that is used to remove accent marks or diacritic signs from lexemes. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This extension provides functions that use a standard algorithm to generate universally unique identifiers (UUIDs). | |
Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | 1.0 | 1.0 | This extension is used to support various BIT-type operations. | |
Not supported | 2.6 | 2.6 | 2.6 | 2.3 | 2.3 | 2.2 | 2.2 | This extension is used to export logical log records as a file in the JSON format. | |
Not supported | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This extension provides XPath query and XSLT functionality. | |
Not supported | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to support full-text searches in Chinese. | |
Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | 4.0 | Not supported | This extension provides text indexing and analytics features. |
YiTian RDS instances
Extension | 17 | 16 | 15 | 14 | 13 | Description |
Not supported | 3.3.4 | 3.3.2 | 3.1.4 | 3.1.4 | This extension is used to standardize the names of geographical locations based on Postal Address Geocoder (PAGC). For more information, see Tuning the Standardizer. | |
Not supported | 3.3.4 | 3.3.2 | 3.1.4 | 3.1.4 | This extension is used to standardize the names of the geographical locations in the United States based on PAGC. For more information, see Tuning the Standardizer. | |
Not supported | 1.5.0 | 1.5.0 | 1.5.0 | Not supported | This extension enables users to leverage a graph database on top of existing PostgreSQL databases. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension provides an index access method that is based on Bloom filters. | |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | This extension provides sample GIN operator classes that are used to implement B-tree equivalent behavior for multiple data types or all enumerated data types. | |
1.7 | 1.7 | 1.7 | 1.6 | 1.5 | This extension provides sample GiST operator classes that are used to implement B-tree equivalent behavior for multiple data types and all enumerated data types. | |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 | This extension provides a string type that is not case-sensitive. | |
1.5 | 1.5 | 1.5 | 1.5 | 1.4 | This extension provides a data type that is used to represent multidimensional cubes. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | This extension is used to manage tables across databases. | |
Not supported | Not supported | Not supported | Not supported | 0.1.0 | This extension is used to generate data that is compatible with the Debezium platform based on the Protocol Buffers protocol. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension provides a sample add-on dictionary template that is used to run full-text searches. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This extension provides two different methods that are used to calculate great-circle distances on the surface of the Earth. | |
1.2 | 1.2 | 1.1 | 1.1 | 1.1 | This extension is used to compute the similarity and distance between strings. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to standardize the names of geographical locations based on PAGC. For more information, see Tuning the Standardizer. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to standardize the names of the geographical locations in the United States based on PAGC. For more information, see Tuning the Standardizer. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to compute and analyze spatial geometries. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to display 2D geometric big data at high speeds. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is an extension of the SFCGAL extension and is used to process spatial geometries. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to compute and analyze spatial geometries. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used for the meshing, coding, indexing, and analysis of grids such as H3 and GeoSOT grids. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to compute and analyze spatial network geometries. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to store, compute, and analyze point clouds. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to store, compute, and analyze point clouds. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to store, compute, and analyze spatial grids. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to compute and analyze spatial references. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to support the TIGER data format that is used by the USCB. | |
Not supported | 6.3 | 6.3 | 6.3 | 6.3 | This extension is used to compute and analyze objects in the moving object detection (MOD) system of Ganos. | |
Not supported | 2.18 | 2.18 | 2.18 | 2.15 | This extension is used to estimate business metrics, such as page views (PV) and unique visitors (UV), in an efficient manner. | |
1.8 | 1.8 | 1.8 | 1.8 | 1.7 | This extension is used to store key-value pairs within a single PostgreSQL value. | |
Not supported | 1.4.1 | 1.4.1 | 1.4.1 | 1.3.1 | This extension is used to create virtual indexes. | |
2.0 | 2.0 | 2.0 | 2.0 | 2.0 | This extension provides index recommendations. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This extension provides an integer aggregator and an enumerator. | |
1.5 | 1.5 | 1.5 | 1.5 | 1.3 | This extension provides functions and operators that are used to manage null-free arrays of integers. | |
Not supported | 2.4 | 2.4 | 2.4 | 2.4 | This extension is used to store IPv4 and IPv6 addresses in PostgreSQL. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | This extension is used to validate input numbers and hyphenate output numbers based on a hard-coded list of prefixes. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | This extension is used to label the data that is stored in a hierarchical tree structure. | |
Not supported | 1.2 | 1.2 | 1.2 | 1.1 | This extension is used to read and write data to an ApsaraDB RDS for MySQL instance or a self-managed MySQL database. | |
Not supported | 4.9.2 | 4.9.2 | 4.9.2 | Not supported | This extension provides functions that are compatible with Oracle. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This extension is used to read data from and write data to an OSS bucket. | |
Not supported | 0.0.1 | 0.0.1 | 0.0.1 | 0.0.1 | This extension is used to search for vectors in an efficient manner. | |
Not supported | 1.2 | 1.2 | 1.2 | 1.2 | This extension is used to create a 2-gram Generalized Inverted Index (GIN) that is used to accelerate full-text searches. | |
1.4 | 1.4 | 1.3 | 1.3 | 1.3 | This extension is used to examine shared buffers in real time. | |
Not supported | 1.6 | 1.6 | 1.6 | 1.5 | This extension is used to configure scheduled tasks. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | This extension is used to examine the FSM. | |
Not supported | 1.2.0 | 1.2.0 | 1.2.0 | 1.1.0 | This extension is used to segment Chinese text. | |
Not supported | 1.6.0 | 1.5.0 | 1.4.0 | 1.3.7 | This extension is used to add hints to SQL statements. The hints are used to change the execution plans of SQL statements. | |
Not supported | 5.1.0 | 5.1.0 | 5.0.1 | 4.7.3 | This extension is used to create and manage time-based and sequence-based table partition sets. | |
Not supported | Not supported | Not supported | Not supported | 1.5 | This extension is used to partition tables at high performance. | |
Not supported | 1.2 | 1.2 | 1.2 | 1.2 | This extension is used to load data to the buffer of the operating system or PostgreSQL database engine. | |
Not supported | 4.4 | 4.4 | 4.4 | 4.1 | This extension is used to collect statistics on resource-intensive activities. | |
Not supported | 0.0.10 | 0.0.10 | 0.0.10 | 0.0.10 | This extension allows you to access the processes and resource consumption data in an operating system by using SQL statements. | |
Not supported | 1.5.0 | 1.5.0 | 1.5.0 | 1.4.6 | This extension is used to clear tablespaces that stay online. | |
Not supported | 2.2.3 | 2.2.3 | 2.2.3 | 2.2.1 | This extension is used to collect statistics on read and write operations in file systems. | |
1.10 | 1.10 | 1.10 | 1.9 | 1.8 | This extension is used to track the statistics of all SQL statements that are executed on a specified server. | |
1.6 | 1.6 | 1.6 | 1.6 | 1.5 | This extension provides functions and operators that are used to compute the similarity between alphanumeric texts. This extension also provides index operator classes that are used to search for similar strings in an efficient manner. | |
Not supported | 1.6 | 1.6 | 1.6 | 1.6 | This extension is used to shrink bloated tables and indexes online. | |
Not supported | 16.0 | 1.6.1 | 1.6.1 | 1.5 | This extension is used to generate audit logs that contain the details about sessions and objects. | |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | This extension provides cryptographic functions for PostgreSQL. | |
Not supported | 2.2 | 2.2 | 2.2 | 2.1 | This extension supports transparent DDL replication. | |
Not supported | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.2 | This extension provides the logical streaming replication feature by using a publish/subscribe pattern. | |
Not supported | 3.4.2 | 3.4.2 | 3.4.2 | 3.4.2 | This extension is used to compute and analyze spatial network geometries. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | This extension provides a function that is used to display the row lock information about a specific table. | |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | This extension provides various functions that are used to obtain tuple-level statistics. | |
Not supported | 0.7.4 | 0.7.4 | 0.7.4 | Not supported | This extension is used for high-dimensional vector similarity search. | |
Not supported | Not supported | Not supported | Not supported | 1.1 | This extension is used to debug the stored procedures of an ApsaraDB RDS for PostgreSQL instance. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to support the Perl procedural language. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to support the SQL procedural language. | |
Not supported | 2.11.0 | 2.10.0 | 2.10.0 | 2.10.0 | This extension provides the CLUSTER and CONNECT modes in which an ApsaraDB RDS for PostgreSQL instance can be accessed. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to support the TCL procedural language. | |
Not supported | 3.3.4 | 3.3.2 | 3.3.2 | 3.3.2 | This extension is used to process and store the information about spatial geographical locations in PostGIS. | |
Not supported | 3.3.4 | 3.3.2 | 3.3.2 | 3.3.2 | This extension is an extension that is used to manage spatial geographic information in PostGIS. | |
Not supported | 3.3.4 | 3.3.2 | 3.3.2 | 3.3.2 | This extension is used to manage PostGIS data in the TIGER format. | |
Not supported | 3.3.4 | 3.3.2 | 3.3.2 | 3.3.2 | This extension is used to manage topological objects in PostGIS. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.0 | This extension is used to manage tables across databases. | |
Not supported | Not supported | 1.1.0 | 1.1.0 | Not supported | This extension is used for data anonymization and data masking. | |
1.1 | 1.1 | 1.0 | 1.0 | Not supported | This extension is used for SQL throttling. | |
rds_duckdb | Not supported | 1.0 | Not supported | Not supported | Not supported | This extension is used to accelerate complex queries. |
Not supported | 1.0 | 1.0 | 1.0 | Not supported | This extension provides custom model configuration and model invocation capabilities to convert text to vectors in a database. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to encrypt and decrypt tables and indexes at a time by using TDE. | |
Not supported | 0.5.4 | 0.5 | 0.5 | 0.5 | This extension is used to compute bitmaps to increase query performance. | |
Not supported | 1.3 | 1.3 | 1.3 | 1.3 | This extension is used to efficiently run full-text searches. | |
Not supported | 1.0.2 | 1.0.2 | 1.0.2 | 1.0.2 | This extension is used to generate sequential UUIDs. | |
Not supported | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to compute the similarity between two arrays of the same data type. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | This extension is used to obtain information about the SSL certificate that is provided by the connected client. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | This extension provides functions that are used to return tables. | |
Not supported | 2.0.3 | 2.0.3 | 2.0.3 | 2.0.3 | This extension is used to query data from an ApsaraDB RDS instance that does not run PostgreSQL. | |
Not supported | 2.14.2 | 2.9.2 | 2.9.2 | 2.5.0 | This extension is used to support features such as automatic sharding, efficient writes, retrieval, and near real-time aggregation of time series data. | |
Not supported | 1.0 | 1.0 | 1.0 | 1.0 | This extension provides the table sampling method SYSTEM_ROWS. | |
Not supported | 1.0 | 1.0 | 1.0 | 1.0 | This extension provides the table sampling method SYSTEM_TIME. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This extension provides a text search dictionary that is used to remove accent marks or diacritic signs from lexemes. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | This extension provides functions that use a standard algorithm to generate universally unique identifiers (UUIDs). | |
Not supported | 2.6 | 2.6 | 2.6 | 2.3 | This extension is used to export logical log records as a file in the JSON format. | |
Not supported | 1.1 | 1.1 | 1.1 | 1.1 | This extension provides XPath query and XSLT functionality. | |
Not supported | 1.0 | 1.0 | 1.0 | 1.0 | This extension is used to support full-text searches in Chinese. |
FAQ
What do I do if I cannot find the required extension in the preceding tables?
You can use the following methods:
The tables in this topic describe only common extensions. If you cannot find the required extension in the preceding tables, you can execute the
SELECT * FROM pg_available_extensions;
statement.You can submit your suggestions and requirements on Alibaba Cloud Connect.
What do I do if the extension that I want to use is not supported by the major engine version of my RDS instance?
You can use the following methods:
Wait until the extension is supported. Extensions are supported by RDS instances that run all major engine versions in phases. You can pay attention to the updates in Release notes for AliPG. The extension that you want to use may be supported in future updates of minor engine versions.
If you want to use the extension at the earliest opportunity by changing the major engine version of your RDS instance, you can use the following methods:
If the new major engine version of the RDS instance is later than the original major engine version, perform a major engine version upgrade on the RDS instance. For more information, see Upgrade the major engine version.
If the new major engine version of the RDS instance is earlier than the original major engine version, purchase an RDS instance of the major engine version that supports the required extension, and then use Data Transmission Service (DTS) to migrate the data of the original RDS instance to the newly created RDS instance. For more information, see Data Transmission Service (DTS).
You can submit your suggestions and requirements on Alibaba Cloud Connect.
An extension can be found in the preceding tables, but an error message is displayed indicating that the extension is not supported when I create the extension. What can I do?
Update the minor engine version of your RDS instance to the latest version and try again. For more information, see Update the minor engine version.
All extensions that I created are in the public schema. How do I create and use extensions in other schemas?
Run the following statement to specify a schema when you create an extension.
CREATE EXTENSION <Extension name> SCHEMA <Schema name>;
References
You can manage extensions of RDS instances that run PostgreSQL in the ApsaraDB RDS console. For more information, see Manage extensions.
For more information about how to use each extension, see the related topics provided in References or the official documentation of open source extensions.
You can update an extension of your RDS instance to the latest version. For more information, see Update the minor engine version.
You can view the minor engine versions in which an extension is supported. For more information, see Release notes for AliPG.