All Products
Search
Document Center

ApsaraDB RDS:Supported extensions

Last Updated:Jan 25, 2024

This topic provides an overview of the extensions and extension versions that are supported by ApsaraDB RDS for PostgreSQL instances.

Note
  • 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 of an ApsaraDB RDS for PostgreSQL instance.

  • The following table describes only common extensions. If you want to query the extensions that are supported by your RDS instance, you can run the SELECT * FROM pg_available_extensions; command.

  • 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, and pg_jieba.

    • 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 modify 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 economy ApsaraDB RDS for PostgreSQL instances. For more information, see Product types.

Important

The extensions that are supported for RDS instances are changed. Some 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

16

15

14

13

12

11

10

Description

address_standardizer

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.

address_standardizer_data_us

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.

aggs_for_arrays

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.

bloom

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.

btree_gin

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.

btree_gist

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.

chkpass

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.

citext

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.

cube

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.

dblink

1.2

1.2

1.2

1.2

1.2

1.2

1.2

This extension is used to manage tables across databases.

decoderbufs

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.

dict_int

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.

earthdistance

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.

encdb

1.1.13

1.1.13

1.1.13

1.1.13

1.1.13

1.1.13

1.1.13

This extension is used to provide the fully encrypted database feature.

encdb_btree

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 fully encrypted databases.

fuzzystrmatch

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.

ganos_address_standardizer

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is used to standardize the names of geographical locations based on Postal Address Geocoder (PAGC). For more information, see Tuning the Standardizer.

ganos_address_standardizer_data_us

6.1

6.0

6.0

6.0

6.0

6.0

6.0

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.

ganos_geometry

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is used to compute and analyze spatial geometries.

ganos_geometry_pyramid

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is used to display 2D geometric big data at high speeds.

ganos_geometry_sfcgal

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is an extension of the SFCGAL extension and is used to process spatial geometries.

ganos_geometry_topology

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is used to compute and analyze spatial geometries.

ganos_geomgrid

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is used for the meshing, coding, indexing, and analysis of grids such as H3 and GeoSOT grids.

ganos_networking

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is used to compute and analyze spatial network geometries.

ganos_pointcloud

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is used to store, compute, and analyze point clouds.

ganos_pointcloud_geometry

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is used to store, compute, and analyze point clouds.

ganos_raster

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is used to store, compute, and analyze spatial grids.

ganos_spatialref

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is used to compute and analyze spatial references.

ganos_tiger_geocoder

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is used to support the TIGER data format that is used by the USCB.

ganos_trajectory

6.1

6.0

6.0

6.0

6.0

6.0

6.0

This extension is used to compute and analyze objects in the moving object detection (MOD) system of Ganos.

hll

2.18

2.16

2.16

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.

hstore

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.

hypopg

Not supported

1.3.1

1.3.1

1.3.1

1.3.1

1.3.1

1.3.1

This extension is used to create virtual indexes.

index_adviser

2.0

2.0

2.0

2.0

2.0

2.0

2.0

This extension provides index recommendations.

intagg

1.1

1.1

1.1

1.1

1.1

1.1

1.1

This extension provides an integer aggregator and an enumerator.

intarray

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.

ip4r

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.

isn

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.

ltree

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.

log_fdw

Not supported

Not supported

Not supported

Not supported

Not supported

1.0

Not supported

This extension is used to query the logs.

madlib

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.

mysql_fdw

1.2

1.1

1.1

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.

oracle_fdw

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.

orafce

Not supported

3.17

3.17

Not supported

Not supported

3.8

3.6

This extension provides functions that are compatible with Oracle.

oss_fdw

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.

pase

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.

pg_bigm

Not supported

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.

pg_buffercache

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.

pg_concurrency_control

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.

pg_cron

1.6

1.5

1.5

1.5

1.1

1.1

1.1

This extension is used to configure scheduled tasks.

pg_freespacemap

1.2

1.2

1.2

1.2

1.2

1.2

1.2

This extension is used to examine the FSM.

pg_jieba

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.

pg_hint_plan

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.

pg_partman

4.7.3

4.7.3

4.7.3

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.

pg_pathman

Not supported

Not supported

Not supported

1.5

1.5

1.5

1.5

This extension is used to partition tables at high performance.

pg_prewarm

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.

pg_profile

Not supported

4.1

4.1

4.1

4.1

4.1

4.1

This extension is used to collect statistics on resource-intensive activities.

pg_repack

1.4.8

1.4.8

1.4.7

1.4.6

1.4.6

1.4.6

1.4.6

This extension is used to clear tablespaces that stay online.

pg_sphere

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.

pg_stat_kcache

Not supported

2.2.1

2.2.1

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.

pg_stat_statements

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.

pg_trgm

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.

pgaudit

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.

pgcrypto

1.3

1.3

1.3

1.3

1.3

1.3

1.3

This extension provides cryptographic functions for PostgreSQL.

pgl_ddl_deploy

2.2

2.1

2.1

2.1

Not supported

Not supported

Not supported

This extension supports transparent DDL replication.

pglogical

2.4.4

2.4.2

2.4.2

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.

pgrouting

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.

pgrowlocks

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.

pgstattuple

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.

pgvector

Not supported

0.5.0

0.5.0

Not supported

Not supported

Not supported

Not supported

This extension is used for high-dimensional vector similarity search.

pldebugger

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.

plperl

1.0

1.0

1.0

1.0

1.0

1.0

1.0

This extension is used to support the Perl procedural language.

plpgsql

1.0

1.0

1.0

1.0

1.0

1.0

1.0

This extension is used to support the SQL procedural language.

plproxy

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.

pltcl

1.0

1.0

1.0

1.0

1.0

1.0

1.0

This extension is used to support the TCL procedural language.

plv8

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.

postgis

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.

postgis_sfcgal

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.

postgis_tiger_geocoder

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.

postgis_topology

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.

postgres_fdw

1.1

1.1

1.1

1.0

1.0

1.0

1.0

This extension is used to manage tables across databases.

postgresql_anonymizer

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.

q3c

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.

rdkit

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.

rds_ccl

1.1

1.0

1.0

Not supported

Not supported

Not supported

Not supported

This extension is used for SQL throttling.

rds_embedding

Not supported

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.

rds_tde_utils

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.

roaringbitmap

Not supported

0.5

0.5

0.5

0.5

Not supported

Not supported

This extension is used to compute bitmaps to increase query performance.

rum

1.3

1.3

1.3

1.3

1.3

1.3

1.3

This extension is used to efficiently run full-text searches.

sequential-uuids

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.

smlar

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.

sslinfo

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.

tablefunc

1.0

1.0

1.0

1.0

1.0

1.0

1.0

This extension provides functions that are used to return tables.

tds_fdw

2.0.3

2.0.3

2.0.3

2.0.3

2.0.1

2.0.1

Not supported

This extension is used to query data from an ApsaraDB RDS instance that does not run PostgreSQL.

timescaledb

Not supported

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.

tsm_system_rows

1.0

1.0

1.0

1.0

1.0

1.0

1.0

This extension provides the table sampling method SYSTEM_ROWS.

tsm_system_time

1.0

1.0

1.0

1.0

1.0

1.0

1.0

This extension provides the table sampling method SYSTEM_TIME.

unaccent

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.

uuid-ossp

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).

varbitx

Not supported

Not supported

Not supported

Not supported

Not supported

1.0

1.0

This extension is used to support various BIT-type operations.

wal2json

Not supported

2.3

2.3

2.3

2.3

2.2

2.2

This extension is used to export logical log records as a file in the JSON format.

xml2

1.1

1.1

1.1

1.1

1.1

1.1

1.1

This extension provides XPath query and XSLT functionality.

zhparser

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.

zombodb

Not supported

Not supported

Not supported

Not supported

Not supported

4.0

Not supported

This extension provides text indexing and analytics features.

Economy RDS instances

Extension

16

15

14

13

Description

address_standardizer

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.

address_standardizer_data_us

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.

bloom

1.0

1.0

1.0

1.0

This extension provides an index access method that is based on Bloom filters.

btree_gin

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.

btree_gist

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.

citext

1.6

1.6

1.6

1.6

This extension provides a string type that is not case-sensitive.

cube

1.5

1.5

1.5

1.4

This extension provides a data type that is used to represent multidimensional cubes.

dblink

1.2

1.2

1.2

1.2

This extension is used to manage tables across databases.

decoderbufs

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.

dict_int

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.

earthdistance

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.

fuzzystrmatch

1.2

1.1

1.1

1.1

This extension is used to compute the similarity and distance between strings.

ganos_address_standardizer

6.1

6.0

6.0

6.0

This extension is used to standardize the names of geographical locations based on Postal Address Geocoder (PAGC). For more information, see Tuning the Standardizer.

ganos_address_standardizer_data_us

6.1

6.0

6.0

6.0

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.

ganos_geometry

6.1

6.0

6.0

6.0

This extension is used to compute and analyze spatial geometries.

ganos_geometry_pyramid

6.1

6.0

6.0

6.0

This extension is used to display 2D geometric big data at high speeds.

ganos_geometry_sfcgal

6.1

6.0

6.0

6.0

This extension is an extension of the SFCGAL extension and is used to process spatial geometries.

ganos_geometry_topology

6.1

6.0

6.0

6.0

This extension is used to compute and analyze spatial geometries.

ganos_geomgrid

6.1

6.0

6.0

6.0

This extension is used for the meshing, coding, indexing, and analysis of grids such as H3 and GeoSOT grids.

ganos_networking

6.1

6.0

6.0

6.0

This extension is used to compute and analyze spatial network geometries.

ganos_pointcloud

6.1

6.0

6.0

6.0

This extension is used to store, compute, and analyze point clouds.

ganos_pointcloud_geometry

6.1

6.0

6.0

6.0

This extension is used to store, compute, and analyze point clouds.

ganos_raster

6.1

6.0

6.0

6.0

This extension is used to store, compute, and analyze spatial grids.

ganos_spatialref

6.1

6.0

6.0

6.0

This extension is used to compute and analyze spatial references.

ganos_tiger_geocoder

6.1

6.0

6.0

6.0

This extension is used to support the TIGER data format that is used by the USCB.

ganos_trajectory

6.1

6.0

6.0

6.0

This extension is used to compute and analyze objects in the moving object detection (MOD) system of Ganos.

hll

2.18

2.16

2.16

2.15

This extension is used to estimate business metrics, such as page views (PV) and unique visitors (UV), in an efficient manner.

hstore

1.8

1.8

1.8

1.7

This extension is used to store key-value pairs within a single PostgreSQL value.

hypopg

Not supported

1.3.1

1.3.1

1.3.1

This extension is used to create virtual indexes.

index_adviser

2.0

2.0

2.0

2.0

This extension provides index recommendations.

intagg

1.1

1.1

1.1

1.1

This extension provides an integer aggregator and an enumerator.

intarray

1.5

1.5

1.5

1.3

This extension provides functions and operators that are used to manage null-free arrays of integers.

ip4r

2.4

2.4

2.4

2.4

This extension is used to store IPv4 and IPv6 addresses in PostgreSQL.

isn

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.

ltree

1.2

1.2

1.2

1.2

This extension is used to label the data that is stored in a hierarchical tree structure.

mysql_fdw

1.2

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.

orafce

Not supported

3.17

3.17

Not supported

This extension provides functions that are compatible with Oracle.

oss_fdw

1.1

1.1

1.1

1.1

This extension is used to read data from and write data to an OSS bucket.

pase

0.0.1

0.0.1

0.0.1

0.0.1

This extension is used to search for vectors in an efficient manner.

pg_bigm

Not supported

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.

pg_buffercache

1.4

1.3

1.3

1.3

This extension is used to examine shared buffers in real time.

pg_cron

1.6

1.5

1.5

1.5

This extension is used to configure scheduled tasks.

pg_freespacemap

1.2

1.2

1.2

1.2

This extension is used to examine the FSM.

pg_jieba

1.2.0

1.2.0

1.2.0

1.1.0

This extension is used to segment Chinese text.

pg_hint_plan

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.

pg_partman

4.7.3

4.7.3

4.7.3

4.7.3

This extension is used to create and manage time-based and sequence-based table partition sets.

pg_pathman

Not supported

Not supported

Not supported

1.5

This extension is used to partition tables at high performance.

pg_prewarm

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.

pg_profile

Not supported

4.1

4.1

4.1

This extension is used to collect statistics on resource-intensive activities.

pg_repack

1.4.8

1.4.8

1.4.7

1.4.6

This extension is used to clear tablespaces that stay online.

pg_stat_kcache

Not supported

2.2.1

2.2.1

2.2.1

This extension is used to collect statistics on read and write operations in file systems.

pg_stat_statements

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.

pg_trgm

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.

pgaudit

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.

pgcrypto

1.3

1.3

1.3

1.3

This extension provides cryptographic functions for PostgreSQL.

pgl_ddl_deploy

2.2

2.1

2.1

2.1

This extension supports transparent DDL replication.

pglogical

2.4.4

2.4.2

2.4.2

2.4.2

This extension provides the logical streaming replication feature by using a publish/subscribe pattern.

pgrouting

3.4.2

3.4.2

3.4.2

3.4.2

This extension is used to compute and analyze spatial network geometries.

pgrowlocks

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.

pgstattuple

1.5

1.5

1.5

1.5

This extension provides various functions that are used to obtain tuple-level statistics.

pgvector

Not supported

0.5.0

0.5.0

Not supported

This extension is used for high-dimensional vector similarity search.

pldebugger

Not supported

Not supported

Not supported

1.1

This extension is used to debug the stored procedures of an ApsaraDB RDS for PostgreSQL instance.

plperl

1.0

1.0

1.0

1.0

This extension is used to support the Perl procedural language.

plpgsql

1.0

1.0

1.0

1.0

This extension is used to support the SQL procedural language.

plproxy

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.

pltcl

1.0

1.0

1.0

1.0

This extension is used to support the TCL procedural language.

postgis

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.

postgis_sfcgal

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.

postgis_tiger_geocoder

3.3.4

3.3.2

3.3.2

3.3.2

This extension is used to manage PostGIS data in the TIGER format.

postgis_topology

3.3.4

3.3.2

3.3.2

3.3.2

This extension is used to manage topological objects in PostGIS.

postgres_fdw

1.1

1.1

1.1

1.0

This extension is used to manage tables across databases.

postgresql_anonymizer

Not supported

1.1.0

1.1.0

Not supported

This extension is used for data anonymization and data masking.

rds_ccl

1.1

1.0

1.0

Not supported

This extension is used for SQL throttling.

rds_embedding

Not supported

1.0

1.0

Not supported

This extension provides custom model configuration and model invocation capabilities to convert text to vectors in a database.

rds_tde_utils

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.

roaringbitmap

Not supported

0.5

0.5

0.5

This extension is used to compute bitmaps to increase query performance.

rum

1.3

1.3

1.3

1.3

This extension is used to efficiently run full-text searches.

sequential-uuids

1.0.2

1.0.2

1.0.2

1.0.2

This extension is used to generate sequential UUIDs.

smlar

1.0

1.0

1.0

1.0

This extension is used to compute the similarity between two arrays of the same data type.

sslinfo

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.

tablefunc

1.0

1.0

1.0

1.0

This extension provides functions that are used to return tables.

tds_fdw

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.

timescaledb

Not supported

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.

tsm_system_rows

1.0

1.0

1.0

1.0

This extension provides the table sampling method SYSTEM_ROWS.

tsm_system_time

1.0

1.0

1.0

1.0

This extension provides the table sampling method SYSTEM_TIME.

unaccent

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.

uuid-ossp

1.1

1.1

1.1

1.1

This extension provides functions that use a standard algorithm to generate universally unique identifiers (UUIDs).

wal2json

Not supported

2.3

2.3

2.3

This extension is used to export logical log records as a file in the JSON format.

xml2

1.1

1.1

1.1

1.1

This extension provides XPath query and XSLT functionality.

zhparser

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 run the SELECT * FROM pg_available_extensions; command.

    • 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.