This topic lists the extensions and their versions supported by each RDS PostgreSQL version. Use this information to quickly determine whether your instance supports a specific extension and choose the appropriate functionality.
Join the RDS PostgreSQL Extension Exchange DingTalk group (103525002795) to get more information about extensions, ask questions, share experiences, and provide feedback.
Usage Notes
Before using RDS PostgreSQL extensions, review the following compatibility requirements, configuration methods, and query limitations to ensure correct installation and usage.
Version Compatibility
Engine Version Dependency: Extension support depends closely on the engine version. If your instance does not support an extension listed in this document, upgrade your instance to the latest minor engine version.
Edition Differences: The list of supported extensions varies between editions (Standard Edition and Yitian Edition). For details, refer to the corresponding edition tab in this document.
Preloading Configuration
Before using certain extensions, you must add their names to the database parameter shared_preload_libraries. Otherwise, running the CREATE EXTENSION command fails. For instructions on modifying the shared_preload_libraries parameter, see Configure Instance Parameters.
The following extensions require preloading:
Performance Monitoring:
pg_stat_statements,auto_explain,pg_prewarmSecurity Audit:
auth_delay,passwordcheck,pgauditPartition Management:
pg_pathmanLogical Replication:
pglogicalFull-Text Search:
pg_bigm,zhparser,pg_jiebaTask Scheduling:
pg_cronQuery Optimization:
pg_hint_planData Compression:
pg_squeezeTime Series Data:
timescaledbQuery Acceleration:
rds_duckdbOracle Compatibility:
orafceDebugging Tools:
pldebugger(set the parameter value toplugin_debugger)
Extension Queries and Restrictions
Query Available Extensions: Run
SELECT * FROM pg_available_extensions;in your database to obtain a complete list of all available extensions for your instance.Security Restrictions: To standardize extension management and enhance security, RDS gradually optimizes extensions that pose security risks during engine version iterations. As a result, you cannot create certain extensions in some engine versions, although existing extensions remain unaffected. For more information, see Restrictions on Creating Extensions.
Supported Extensions List
Standard Edition
Extension Name | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | Description |
None | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | None | None | None | Provides online partitioning capabilities. | |
4.0.5 | 4.0.4 | None | None | None | None | None | None | None | Provides full-text search capabilities for PostgreSQL. | |
1.0.0 | 1.0.0 | None | None | None | None | None | None | None | Provides advanced full-text search capabilities. | |
None | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | None | None | None | Enables PostgreSQL to directly query data from ClickHouse databases as if querying local tables. | |
None | 1.4 | None | None | None | None | None | None | None | Allows you to view and audit permission settings for all objects (tables, views, functions, etc.) in a PostgreSQL database, facilitating permission management and security audits. | |
None | 3.3.7 | 3.3.4 | 3.3.2 | 3.1.4 | 3.1.4 | 3.1.4 | 3.1.4 | 3.1.4 | Address standardization plugin based on the PAGC standard. | |
None | 3.3.7 | 3.3.4 | 3.3.2 | 3.1.4 | 3.1.4 | 3.1.4 | 3.1.4 | 3.1.4 | Address standardization (US) data plugin based on the PAGC standard. | |
None | None | None | None | None | None | None | None | 1.3.1 | Provides aggregate functions for calculating statistics on numeric arrays. | |
1.6.0 | 1.6.0 | 1.6.0 | 1.6.0 | 1.6.0 | None | None | None | None | Provides graph database capabilities for PostgreSQL. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Provides an index access method based on Bloom filters. | |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.2 | Provides a GIN operator class example that implements B-tree equivalent behavior for multiple data types and all enum types. | |
1.8 | 1.7 | 1.7 | 1.7 | 1.6 | 1.5 | 1.5 | 1.5 | 1.5 | Provides a GiST operator class example that implements B-tree equivalent behavior for multiple data types and all enum types. | |
None | None | None | None | None | None | None | None | 1.0 | Implements a data type for storing encrypted passwords. | |
1.8 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.5 | 1.4 | Provides a case-insensitive string type. | |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.4 | 1.4 | 1.4 | 1.2 | Provides a data type for representing multidimensional cubes. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | Performs cross-database table operations. | |
None | None | None | None | None | 0.1.0 | 0.1.0 | 0.1.0 | 0.1.0 | Outputs data compatible with the Debezium platform according to the Protocol Buffers protocol. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | An example of an additional full-text search dictionary template. | |
1.2 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | Provides two different methods for calculating great-circle distances on the Earth's surface. | |
None | 1.1.14 | 1.1.14 | 1.1.14 | 1.1.14 | 1.1.14 | 1.1.14 | 1.1.14 | 1.1.13 | Provides confidential database capabilities. | |
None | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | Accelerates ciphertext queries on confidential databases. | |
1.2 | 1.2 | 1.2 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | Determines the similarity and distance between strings. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Address standardization plugin based on the PAGC standard. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Address standardization US data plugin based on the PAGC standard. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Provides spatial geometry computation and analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Enables fast display of large-scale 2D spatial geometry data. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Provides spatial geometry SFCGAL plugin extension capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Provides spatial geometry computation and analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Provides grid partitioning, encoding, indexing, and analysis capabilities such as H3 and GeoSOT. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Provides spatial geometry network computation and analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Provides point cloud storage and computation analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Provides point cloud storage and computation analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Provides spatial raster data storage and computation analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Provides spatial reference computation and analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Provides USCB Tiger data type support. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 | 6.3 | 6.3 | Ganos moving object (MOD) data computation and analysis capabilities. | |
2.18 | 2.19 | 2.18 | 2.18 | 2.18 | 2.15 | 2.14 | 2.14 | None | Quickly estimates business metrics such as PV and UV. | |
1.8 | 1.8 | 1.8 | 1.8 | 1.8 | 1.7 | 1.6 | 1.5 | 1.4 | Stores key-value pairs within a single PostgreSQL instance. | |
1.4.2 | 1.4.1 | 1.4.1 | 1.4.1 | 1.4.1 | 1.3.1 | 1.3.1 | 1.3.1 | 1.3.1 | Creates virtual indexes. | |
None | 4.2.3 | None | None | None | None | None | None | None | Provides Uber's H3 hexagonal hierarchical spatial indexing capabilities. | |
None | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | Provides index recommendations. | |
None | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | Provides an integer aggregator and an enumerator. | |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.3 | 1.2 | 1.2 | 1.2 | Provides useful functions and operators for manipulating non-null integer arrays. | |
2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | None | None | None | Enables PostgreSQL to support IP address range types. | |
1.3 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.1 | Validates input against a hard-coded prefix list and concatenates numbers during output. | |
1.3 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.1 | 1.1 | 1.1 | Represents labels stored in a hierarchical tree structure. | |
None | None | None | None | None | None | None | 1.0 | None | Queries database logs. | |
None | 2.9.2 | 1.2 | 1.2 | 1.2 | 1.1 | 1.1 | 1.1 | 1.1 | Reads and writes data from RDS MySQL instances or self-managed MySQL databases. | |
None | None | None | None | None | None | 1.1 | None | None | Supports synchronously updating Oracle database tables from PostgreSQL tables. | |
4.15 | None | 4.9.2 | 4.9.2 | 4.9.2 | None | None | 3.8 | 3.6 | Provides a series of Oracle-compatible functions. | |
None | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | Reads and writes data from OSS. | |
None | None | 0.0.1 | 0.0.1 | 0.0.1 | 0.0.1 | 0.0.1 | 0.0.1 | None | Efficient vector retrieval. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | Creates a bigram (2-gram) GIN index to accelerate full-text search processes. | |
1.6 | 1.4 | 1.4 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | Provides a method to inspect shared buffers in real time. | |
None | None | None | None | None | None | None | 1.0 | 1.0 | Performs SQL concurrency control. | |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.5 | 1.1 | 1.1 | 1.1 | Sets scheduled tasks. | |
1.3 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | Inspects the free space map (FSM). | |
1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | Performs Chinese text segmentation for full-text search. | |
1.8.0 | 1.7.0 | 1.6.1 | 1.5.2 | 1.4.3 | 1.3.9 | 1.3.9 | 1.3.9 | 1.3.0 | Uses special comment hints to change PostgreSQL's default execution plan. | |
5.2.4 | 5.2.4 | 5.1.0 | 5.1.0 | 5.1.0 | 4.7.3 | 4.7.3 | None | None | Creates and manages time-based and sequence-based table partition sets. | |
None | None | None | None | None | 1.5 | 1.5 | 1.5 | 1.5 | High-performance partitioned table plugin. | |
1.2 | None | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.1 | Provides a convenient method to load data into operating system buffers or PostgreSQL buffers. | |
None | None | 4.4 | 4.4 | 4.4 | 4.1 | 4.1 | 4.1 | 4.1 | Resource-intensive activity statistics. | |
None | 0.0.13 | 0.0.10 | 0.0.10 | 0.0.10 | 0.0.10 | 0.0.10 | 0.0.10 | None | Allows users to access operating system-level process and system resource consumption data through SQL queries. | |
None | 1.5.1 | 1.5.0 | 1.5.0 | 1.5.0 | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | Online tablespace cleanup functionality. | |
None | None | None | None | None | None | None | None | 1.0 | Provides PostgreSQL spherical data types, functions, operators, and indexes. | |
None | 2.3.0 | 2.2.3 | 2.2.3 | 2.2.3 | 2.2.1 | 2.2.1 | 2.2.1 | 2.2.1 | System read/write statistics. | |
1.12 | 1.10 | 1.10 | 1.10 | 1.9 | 1.8 | 1.7 | 1.6 | 1.6 | Provides a method to track execution statistics for all SQL statements executed by the server. | |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.5 | 1.4 | 1.4 | 1.3 | Provides functions and operators for alphanumeric text similarity and index operator classes for fast similar string searches. | |
1.8 | 1.7 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | None | Online shrinkage of bloated tables and indexes. | |
1.1 | 1.1 | None | None | None | None | None | None | None | Monitors and analyzes database wait states. | |
None | 17.0 | 16.0 | 1.6.1 | 1.6.1 | 1.5 | 1.4.1 | 1.3.2 | 1.2.2 | Provides detailed session and object audit logging. | |
1.4 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | Provides cryptographic functions for PostgreSQL. | |
None | None | 2.2 | 2.2 | 2.2 | 2.1 | None | None | None | Enables transparent logical DDL replication in PostgreSQL. | |
2.4.6 | 2.4.5 | 2.4.5 | 2.4.4 | 2.4.4 | 2.4.2 | 2.4.2 | 2.4.0 | 2.4.0 | Provides logical streaming replication publishing and subscription capabilities. | |
None | 3.4.2 | 3.4.2 | 3.4.2 | 3.4.2 | 3.4.2 | 3.4.2 | 3.4.2 | 3.4.2 | Provides spatial geometry network computation and analysis capabilities. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | Provides a function to display row lock information for a specified table. | |
1.0 | 1.0.0 | 1.0.0 | None | None | None | None | None | None | Implements Gzip compression and decompression for data in PostgreSQL databases. | |
1.6 | 1.6 | 1.6 | None | None | None | None | None | None | Allows users to send HTTP requests directly from PostgreSQL databases. | |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | Provides multiple functions to obtain tuple-level statistics. | |
0.8.1 | 0.8.0 | 0.8.0 | 0.8.0 | 0.8.0 | None | None | None | None | High-dimensional vector similarity search plugin. | |
None | 1.8 | 1.8 | 1.8 | 1.8 | 1.1 | 1.1 | 1.1 | 1.1 | Stored procedure debugging plugin. | |
None | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Provides the Perl procedural language. | |
None | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Provides the SQL procedural language. | |
2.11.0 | None | 2.11.0 | 2.10.0 | 2.10.0 | 2.10.0 | 2.9.0 | 2.9.0 | 2.8.0 | Includes CLUSTER mode and CONNECT mode to help you access databases in different ways. | |
None | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Provides the Tcl procedural language. | |
None | None | None | None | 2.3.15 | 2.3.15 | 2.3.15 | 2.3.15 | 2.3.15 | Trusted JavaScript language extension. | |
3.3.7 | 3.3.7 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.2 | PostGIS spatial geography-related extension. | |
3.3.7 | 3.3.7 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.2 | PostGIS SFCGAL spatial geography-related extension. | |
3.3.7 | 3.3.7 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.2 | PostGIS TIGER data spatial geography-related extension. | |
3.3.7 | 3.3.7 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.2 | PostGIS topology data spatial geography-related extension. | |
1.2 | 1.1 | 1.1 | 1.1 | 1.1 | 1.0 | 1.0 | 1.0 | 1.0 | Cross-database operation table. | |
None | 1.1.0 | None | 1.1.0 | 1.1.0 | None | None | None | None | Anonymizes or masks sensitive data in databases. | |
None | None | None | None | None | None | None | None | 1.5.0 | Performs spatial indexing on spheres. | |
None | None | None | None | None | None | 3.8 | None | None | Supports cheminformatics and chemical molecule retrieval. | |
1.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | None | None | None | None | Integrates Alibaba Cloud Model Studio's advanced models, including Qwen, general-purpose text embeddings and general-purpose text ranking. With this plugin, you can easily implement various scenarios in RDS PostgreSQL databases, such as LLM Q&A, text-to-vector conversion, text ranking, top-N similar vector retrieval, and RAG Q&A. | |
1.3 | 1.2 | 1.2 | 1.2 | 1.2 | None | None | None | None | Supports SQL throttling. | |
1.3.2.3 | 1.1 | 1.2 | 1.3 | 1.1 | 1.1 | 1.1 | None | None | Accelerates complex queries. | |
None | 1.0 | 1.0 | 1.0 | 1.0 | None | None | None | None | Provides custom model configuration and model invocation capabilities to convert text to vectors directly in the database. | |
None | None | 1.0 | None | None | None | None | None | None | Encrypts sensitive columns in query result sets. By setting database account permissions, authorized accounts receive only ciphertext-formatted results when accessing sensitive column information. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | None | None | Supports online column type modification to complete schema changes without affecting business continuity. | |
1.1 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | TDE batch encryption and decryption plugin. | |
0.5.4 | 0.5.4 | 0.5.4 | 0.5 | 0.5 | 0.5 | 0.5 | None | None | Uses bitmap functionality to improve query performance. | |
1.3.15 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | High-speed full-text retrieval. | |
1.0.3 | None | 1.0.2 | 1.0.2 | 1.0.2 | 1.0.2 | 1.0.2 | 1.0.2 | 1.0.2 | UUID generator with sequential patterns. | |
None | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Calculates the similarity between two arrays of the same type. | |
2.2 | 2.2 | 2.2 | 2.2 | None | None | None | None | None | Provides a unique ID solution based on int8 and sequences as an optional replacement for PostgreSQL's built-in bigserial data type. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | Provides information about the SSL certificate provided by the current client. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Includes multiple functions that return tables. | |
None | 2.0.4 | 2.0.3 | 2.0.3 | 2.0.3 | 2.0.3 | 2.0.3 | 2.0.3 | None | Queries data from other types of databases. | |
None | 2.24.0 | 2.24.0 | 2.9.2 | 2.9.2 | 2.5.0 | 1.7.1 | 1.7.1 | 1.3.0 | Supports automatic sharding, efficient writing, retrieval, and near real-time aggregation of time series data. | |
1.0 | None | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Provides the SYSTEM_ROWS table sampling method. | |
1.0 | None | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Provides the SYSTEM_TIME table sampling method. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | Text search dictionary that removes accents (diacritical marks) from lexemes. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | Provides functions to generate universally unique identifiers (UUIDs) using several standard algorithms. | |
None | None | None | None | None | None | None | 1.0 | 1.0 | Supports multiple BIT operations. | |
2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.3 | 2.3 | 2.2 | 2.2 | Outputs logical log files in JSON format. | |
1.2 | None | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | Provides XPath query and XSLT functionality. | |
2.1 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Chinese full-text search. | |
None | None | None | None | None | None | None | 4.0 | None | Powerful text indexing and analysis capabilities. |
Yitian Edition
Extension Name | 18 | 17 | 16 | 15 | 14 | 13 | Description |
None | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Provides online partitioning capabilities. | |
None | 4.0.4 | None | None | None | None | Provides full-text search capabilities for PostgreSQL. | |
1.0.0 | 1.0.0 | None | None | None | None | Provides advanced full-text search capabilities. | |
None | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | Enables PostgreSQL to directly query data from ClickHouse databases as if querying local tables. | |
None | 1.4 | None | None | None | None | Allows you to view and audit permission settings for all objects (tables, views, functions, etc.) in a PostgreSQL database, facilitating permission management and security audits. | |
None | 3.3.7 | 3.3.4 | 3.3.2 | 3.1.4 | 3.1.4 | Address standardization plugin based on the PAGC standard. | |
None | 3.3.7 | 3.3.4 | 3.3.2 | 3.1.4 | 3.1.4 | Address standardization US data plugin based on the PAGC standard. | |
1.6.0 | 1.6.0 | 1.6.0 | 1.6.0 | 1.6.0 | None | Provides graph database capabilities for PostgreSQL. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Provides an index access method based on Bloom filters. | |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | Provides a GIN operator class example that implements B-tree equivalent behavior for multiple data types and all enum types. | |
1.8 | 1.7 | 1.7 | 1.7 | 1.6 | 1.5 | Provides a GiST operator class example that implements B-tree equivalent behavior for multiple data types and all enum types. | |
1.8 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | Provides a case-insensitive string type. | |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.4 | Provides a data type for representing multidimensional cubes. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | Performs cross-database table operations. | |
None | None | None | None | None | 0.1.0 | Outputs data compatible with the Debezium platform according to the Protocol Buffers protocol. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | An example of an additional full-text search dictionary template. | |
1.2 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | Provides two different methods for calculating great-circle distances on the Earth's surface. | |
1.2 | 1.2 | 1.2 | 1.1 | 1.1 | 1.1 | Determines the similarity and distance between strings. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Address standardization plugin based on the PAGC standard. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Address standardization US data plugin based on the PAGC standard. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Provides spatial geometry computation and analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Enables fast display of large-scale 2D spatial geometry data. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Provides spatial geometry SFCGAL plugin extension capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Provides spatial geometry computation and analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Provides grid partitioning, encoding, indexing, and analysis capabilities such as H3 and GeoSOT. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Provides spatial geometry network computation and analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Provides point cloud storage and computation analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Provides point cloud storage and computation analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Provides spatial raster data storage and computation analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Provides spatial reference computation and analysis capabilities. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Provides USCB Tiger data type support. | |
None | 7.0 | 6.9 | 6.9 | 6.9 | 6.9 | Ganos moving object (MOD) data computation and analysis capabilities. | |
2.18 | 2.19 | 2.18 | 2.18 | 2.18 | 2.15 | Quickly estimates business metrics such as PV and UV. | |
1.8 | 1.8 | 1.8 | 1.8 | 1.8 | 1.7 | Stores key-value pairs within a single PostgreSQL instance. | |
1.4.2 | 1.4.1 | 1.4.1 | 1.4.1 | 1.4.1 | 1.3.1 | Creates virtual indexes. | |
None | 4.2.3 | None | None | None | None | Provides Uber's H3 hexagonal hierarchical spatial indexing capabilities. | |
None | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | Provides index recommendations. | |
None | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | Provides an integer aggregator and an enumerator. | |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.3 | Provides useful functions and operators for manipulating non-null integer arrays. | |
2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | Enables PostgreSQL to support IP address range types. | |
1.3 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | Validates input against a hard-coded prefix list and concatenates numbers during output. | |
1.3 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | Represents labels stored in a hierarchical tree structure. | |
None | 2.9.2 | 1.2 | 1.2 | 1.2 | 1.1 | Reads and writes data from RDS MySQL instances or self-managed MySQL databases. | |
4.15 | None | 4.9.2 | 4.9.2 | 4.9.2 | None | Provides a series of Oracle-compatible functions. | |
None | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | Read and write data in OSS. | |
None | None | 0.0.1 | 0.0.1 | 0.0.1 | 0.0.1 | Efficient vector retrieval. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | Creates a bigram (2-gram) GIN index to accelerate full-text search processes. | |
1.6 | 1.4 | 1.4 | 1.3 | 1.3 | 1.3 | Provides a method to inspect shared buffers in real time. | |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.5 | Sets scheduled tasks. | |
1.3 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | Inspects the free space map (FSM). | |
1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.1.0 | Tokenize the entire Chinese text. | |
1.8.0 | 1.7.0 | 1.6.1 | 1.5.2 | 1.4.3 | 1.3.9 | Uses special comment hints to change PostgreSQL's default execution plan. | |
4.7.3 | 5.2.4 | 5.1.0 | 5.1.0 | 5.0.1 | 4.7.3 | Creates and manages time-based and sequence-based table partition sets. | |
None | None | None | None | None | 1.5 | High-performance partitioned table plugin. | |
1.2 | None | 1.2 | 1.2 | 1.2 | 1.2 | Provides a convenient method to load data into operating system buffers or PostgreSQL buffers. | |
None | None | 4.4 | 4.4 | 4.4 | 4.1 | Resource-intensive activity statistics. | |
0.0.13 | 0.0.10 | 0.0.10 | 0.0.10 | 0.0.10 | 0.0.10 | Allows users to access operating system-level process and system resource consumption data through SQL queries. | |
None | 1.5.1 | 1.5.0 | 1.5.0 | 1.5.0 | 1.4.6 | Online tablespace cleanup functionality. | |
None | 2.3.0 | 2.2.3 | 2.2.3 | 2.2.3 | 2.2.1 | System read/write statistics. | |
1.12 | 1.10 | 1.10 | 1.10 | 1.9 | 1.8 | Provides a method to track execution statistics for all SQL statements executed by the server. | |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.5 | Provides functions and operators for alphanumeric text similarity and index operator classes for fast similar string searches. | |
1.8 | 1.7 | 1.6 | 1.6 | 1.6 | 1.6 | Online shrinkage of bloated tables and indexes. | |
1.1 | 1.1 | None | None | None | None | Monitors and analyzes database wait states. | |
None | 17.0 | 16.0 | 1.6.1 | 1.6.1 | 1.5 | Provides detailed session and object audit logging. | |
1.4 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | Provides cryptographic functions for PostgreSQL. | |
None | None | 2.2 | 2.2 | 2.2 | 2.1 | Enables transparent logical DDL replication in PostgreSQL. | |
2.4.6 | 2.4.5 | 2.4.5 | 2.4.4 | 2.4.4 | 2.4.2 | Provides logical streaming replication publishing and subscription capabilities. | |
None | 3.4.2 | 3.4.2 | 3.4.2 | 3.4.2 | 3.4.2 | Provides spatial geometry network computation and analysis capabilities. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | Provides a function to display row lock information for a specified table. | |
1.0 | 1.0.0 | 1.0.0 | None | None | None | Implements Gzip compression and decompression for data in PostgreSQL databases. | |
1.6 | None | 1.6 | None | None | None | Allows users to send HTTP requests directly from PostgreSQL databases. | |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | Provides multiple functions to obtain tuple-level statistics. | |
0.8.1 | 0.8.0 | 0.8.0 | 0.8.0 | 0.8.0 | None | High-dimensional vector similarity search plugin. | |
None | 1.8 | 1.8 | 1.8 | 1.8 | 1.1 | Stored procedure debugging plugin. | |
None | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Provides the Perl procedural language. | |
None | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Provides the SQL procedural language. | |
2.11.0 | None | 2.11.0 | 2.10.0 | 2.10.0 | 2.10.0 | Includes CLUSTER mode and CONNECT mode to help you access databases in different ways. | |
None | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Provides the Tcl procedural language. | |
None | 3.3.7 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | PostGIS spatial geography-related extension. | |
None | 3.3.7 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | PostGIS SFCGAL spatial geography-related extension. | |
None | 3.3.7 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | PostGIS TIGER data spatial geography-related extension. | |
None | 3.3.7 | 3.3.4 | 3.3.4 | 3.3.4 | 3.3.4 | PostGIS topology data spatial geography-related extension. | |
1.2 | 1.1 | 1.1 | 1.1 | 1.1 | 1.0 | Cross-database operation table. | |
None | 1.1.0 | None | 1.1.0 | 1.1.0 | None | Anonymizes or masks sensitive data in databases. | |
1.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | None | Integrates Alibaba Cloud Model Studio's advanced models, including Qwen, general-purpose text embeddings and general-purpose text ranking. With this plugin, you can easily implement various scenarios in RDS PostgreSQL databases, such as LLM Q&A, text-to-vector conversion, text ranking, top-N similar vector retrieval, and RAG Q&A. | |
1.3 | 1.2 | 1.2 | 1.2 | 1.2 | None | Supports SQL throttling. | |
1.3.2.3 | 1.1 | 1.2 | 1.3 | 1.1 | 1.1 | Accelerates complex queries. | |
None | 1.0 | 1.0 | 1.0 | 1.0 | None | Provides custom model configuration and model invocation capabilities to convert text to vectors directly in the database. | |
None | None | 1.0 | None | None | None | Encrypts sensitive columns in query result sets. By setting database account permissions, authorized accounts receive only ciphertext-formatted results when accessing sensitive column information. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Supports online column type modification to complete schema changes without affecting business continuity. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | TDE batch encryption and decryption plugin. | |
0.5.4 | 0.5.4 | 0.5.4 | 0.5 | 0.5 | 0.5 | Uses bitmap functionality to improve query performance. | |
None | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | High-speed full-text retrieval. | |
1.0.3 | None | 1.0.2 | 1.0.2 | 1.0.2 | 1.0.2 | UUID generator with sequential patterns. | |
None | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Calculates the similarity between two arrays of the same type. | |
2.2 | 2.2 | 2.2 | 2.2 | None | None | Provides a unique ID solution based on int8 and sequences as an optional replacement for PostgreSQL's built-in bigserial data type. | |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | Provides information about the SSL certificate provided by the current client. | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Includes multiple functions that return tables. | |
None | 2.0.4 | 2.0.3 | 2.0.3 | 2.0.3 | 2.0.3 | Queries data from other types of databases. | |
None | 2.24.0 | 2.24.0 | 2.9.2 | 2.9.2 | 2.5.0 | Supports automatic sharding, efficient writing, retrieval, and near real-time aggregation of time series data. | |
1.0 | None | 1.0 | 1.0 | 1.0 | 1.0 | Provides the SYSTEM_ROWS table sampling method. | |
1.0 | None | 1.0 | 1.0 | 1.0 | 1.0 | Provides the SYSTEM_TIME table sampling method. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | Text search dictionary that removes accents (diacritical marks) from lexemes. | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | Provides functions to generate universally unique identifiers (UUIDs) using several standard algorithms. | |
2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.3 | Outputs logical log files in JSON format. | |
1.2 | None | 1.1 | 1.1 | 1.1 | 1.1 | Provides XPath query and XSLT functionality. | |
2.1 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | Chinese full-text search. |
FAQ
Q: The extension I need is not listed in the table. What should I do?
A: Take the following actions:
This page lists only commonly used extensions. To check support for more extensions, run the command
SELECT * FROM pg_available_extensions;in your database.Submit your suggestions and requirements on the Alibaba Cloud Connect platform.
Q: The extension I need is supported in another major version but not in my current major version. What should I do?
A: Take the following actions:
Wait patiently. Extensions are gradually being synchronized across major versions. Monitor the AliPG Minor Engine Version Release Notes for potential support in future minor version updates.
If you want to switch instance versions to use the required extension sooner:
If the target major version is higher than your current version: Perform a major version upgrade on your current instance. For details, see Upgrade Database Major Version.
If the target major version is lower than your current version: Purchase a new instance with the required major version and migrate your data from the current instance to the new one using Data Transmission Service (DTS).
Submit your suggestions and requirements on the Alibaba Cloud Connect platform.
Q: The extension table shows that an extension is supported, but I get an error when trying to create it. What should I do?
A: First, upgrade your minor engine version to the latest version and try again.
Q: All extensions I create are in the public schema. How can I create and use extensions in other schemas?
A: Specify the schema when creating the extension. For example:
CREATE EXTENSION <extension_name> SCHEMA <schema_name>;References
RDS PostgreSQL supports managing extensions in the console. For more information, see Manage Extensions.
For usage instructions for each extension, refer to the relevant documentation provided in this topic or the official documentation of the open-source extension.
To use the latest extension versions, upgrade your minor engine version to the latest version.
You can also check the AliPG Minor Engine Version Release Notes to determine which minor version supports a specific extension.