All Products
Search
Document Center

ApsaraDB RDS:Supported extensions

Last Updated:Nov 02, 2022

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 configure the shared_preload_libraries parameter, see Manage the parameters of an ApsaraDB RDS for PostgreSQL instance.

Extension

14

13

12

11

10

9.4

Description

address_standardizer

3.1.4

3.1.4

3.1.4

3.1.4

3.1.4

2.5.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.1.4

3.1.4

3.1.4

3.1.4

3.1.4

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

1.3.1

Not supported

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

Not supported

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

btree_gin

1.3

1.3

1.3

1.3

1.2

1.0

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

1.5

1.5

1.5

1.5

1.0

This extension provides sample GiST operator classes that are used to implement B-tree equivalent behavior for multiple data types or all enumerated data types.

chkpass

Not supported

Not supported

Not supported

Not supported

1.0

1.0

This extension provides a data type that is used to store encrypted passwords.

citext

1.6

1.6

1.6

1.5

1.4

1.0

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

cube

1.5

1.4

1.4

1.4

1.2

1.0

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

This extension is used to manage tables across databases.

decoderbufs

Not supported

0.1.0

0.1.0

0.1.0

0.1.0

Not supported

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

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

This extension provides two different methods that are used to compute great-circle distances on the surface of the Earth.

encdb

1.1.11

1.1.11

1.1.11

1.1.11

1.1.11

Not supported

This extension is used to support fully encrypted databases.

fuzzystrmatch

1.1

1.1

1.1

1.1

1.1

1.0

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

ganos_address_standardizer

4.9

4.9

4.9

4.9

4.9

Not supported

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

ganos_address_standardizer_data_us

4.9

4.9

4.9

4.9

4.9

Not supported

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

4.9

4.9

4.9

4.9

4.9

Not supported

This extension is used to compute and analyze spatial geometries.

ganos_geometry_sfcgal

4.9

4.9

4.9

4.9

4.9

Not supported

This extension is used to compute and analyze spatial geometries.

ganos_geometry_topology

4.9

4.9

4.9

4.9

4.9

Not supported

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

ganos_networking

4.9

4.9

4.9

4.9

4.9

Not supported

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

ganos_pointcloud

4.9

4.9

4.9

4.9

4.9

Not supported

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

ganos_pointcloud_geometry

4.9

4.9

4.9

4.9

4.9

Not supported

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

ganos_raster

4.9

4.9

4.9

4.9

4.9

Not supported

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

ganos_spatialref

4.9

4.9

4.9

4.9

4.9

Not supported

This extension is used to compute and analyze spatial references.

ganos_tiger_geocoder

4.9

4.9

4.9

4.9

4.9

Not supported

This extension is used to support the Topologically Integrated Geographic Encoding and Referencing (TIGER) data format that is used by the United States Census Bureau (USCB).

ganos_trajectory

4.9

4.9

4.9

4.9

4.9

Not supported

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

hll

2.16

2.15

2.14

2.14

Not supported

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

1.6

1.5

1.4

1.3

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

hypopg

1.3.1

1.3.1

1.3.1

1.3.1

1.3.1

Not supported

This extension is used to create virtual indexes.

imgsmlr

Not supported

Not supported

Not supported

Not supported

Not supported

1.0

This extension is used to search for similar images.

index_adviser

2.0

2.0

2.0

2.0

2.0

Not supported

This extension provides index recommendations.

intagg

1.1

1.1

1.1

1.1

1.1

1.0

This extension provides an integer aggregator and an enumerator.

intarray

1.5

1.3

1.2

1.2

1.2

1.0

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

isn

1.2

1.2

1.2

1.2

1.1

1.0

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

1.1

1.1

1.0

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

jsonbx

Not supported

Not supported

Not supported

Not supported

Not supported

1.0

This extension is used in PostgreSQL 9.4 to support JSONB functions.

log_fdw

Not supported

Not supported

Not supported

1.0

Not supported

Not supported

This extension is used to query logs.

madlib

Not supported

Not supported

1.18.0

1.18.0

Not supported

Not supported

This extension is an open source library that is used for machine learning and graph computing models.

mysql_fdw

Not supported

1.1

1.1

1.1

1.1

Not supported

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

1.1

Not supported

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

3.17

Not supported

Not supported

3.8

3.6

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

This extension is used to read data from and write data to an Object Storage Service (OSS) bucket.

pase

Not supported

Not supported

Not supported

0.0.1

Not supported

Not supported

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

pg_bigm

1.2

1.2

1.2

1.2

1.2

Not supported

This extension is used to create a 2-gram Generalized Inverted Index (GIN) that is used to accelerate full-text searches.

pg_buffercache

1.3

1.3

1.3

1.3

1.3

1.0

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

pg_concurrency_control

Not supported

Not supported

Not supported

1.0

1.0

1.0

This extension is used to control the concurrency of SQL statements.

pg_cron

1.1

1.1

1.1

1.1

1.1

Not supported

This extension is used to configure scheduled tasks.

pg_freespacemap

1.2

1.2

1.2

1.2

1.2

1.0

This extension is used to examine the free space map (FSM).

pg_jieba

1.1.0

1.1.0

1.1.0

1.1.0

1.1.0

Not supported

This extension is used to segment Chinese text.

pg_hint_plan

Not supported

1.3.7

1.3.7

1.3.7

1.3.0

1.1.3

This extension is used to add hints to SQL statements. The hints are used to change the execution plans of SQL statements.

pg_pathman

Not supported

1.5

1.5

1.5

1.5

Not supported

This extension is used to partition tables at high performance.

pg_prewarm

1.2

1.2

1.2

1.2

1.1

1.0

This extension is used to load data to the buffer of the operating system or PostgreSQL database engine.

pg_repack

Not supported

1.4.6

1.4.6

1.4.6

1.4.6

Not supported

This extension is used to clear tablespaces that stay online.

pg_sphere

Not supported

Not supported

Not supported

Not supported

1.0

1.0

This extension provides spherical data types, functions, operators, and indexes for PostgreSQL.

pg_stat_statements

1.9

1.8

1.7

1.6

1.6

1.2

This extension is used to track the statistics of all SQL statements that are executed on a specific server.

pg_trgm

1.6

1.5

1.4

1.4

1.3

1.1

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

1.6.1

1.5

1.4.1

1.3.2

1.2.2

Not supported

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

This extension provides cryptographic functions for PostgreSQL.

pglogical

2.4.0

2.4.0

2.4.0

2.4.0

2.4.0

Not supported

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

pgrouting

2.6.2

2.6.2

2.6.2

2.6.2

2.6.2

2.0.0

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

pgrowlocks

1.2

1.2

1.2

1.2

1.2

1.1

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

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

pldebugger

Not supported

1.1

1.1

1.1

1.1

Not supported

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

This extension is used to support the Perl procedural language.

plpgsql

1.0

1.0

1.0

1.0

1.0

1.0

This extension is used to support the SQL procedural language.

plproxy

2.10.0

2.10.0

2.9.0

2.9.0

2.8.0

Not supported

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

This extension is used to support the TCL procedural language.

plv8

Not supported

2.3.15

2.3.15

2.3.15

2.3.15

1.4.2

This extension is a trusted JavaScript language extension.

postgis

3.1.4

3.1.4

3.1.4

3.1.4

3.1.4

2.5.4

This extension is used to process and store the information about spatial geographical locations in PostGIS.

postgis_sfcgal

3.1.4

3.1.4

3.1.4

3.1.4

3.1.4

Not supported

This extension is an extension that is used to manage spatial geographic information in PostGIS.

postgis_tiger_geocoder

3.1.4

3.1.4

3.1.4

3.1.4

3.1.4

2.5.4

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

postgis_topology

3.1.4

3.1.4

3.1.4

3.1.4

3.1.4

2.5.4

This extension is used to manage topological objects in PostGIS.

postgres_fdw

1.1

1.0

1.0

1.0

1.0

1.0

This extension is used to manage tables across databases.

q3c

Not supported

Not supported

Not supported

Not supported

1.5.0

1.5.0

This extension is used to create spatial indexes on a sphere.

rdkit

Not supported

Not supported

3.8

Not supported

Not supported

3.4

This extension is used to support features such as molecular computing and search.

roaringbitmap

0.5

0.5

0.5

Not supported

Not supported

Not supported

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

rum

Not supported

1.3

1.3

1.3

1.3

Not supported

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

Not supported

This extension is used to generate sequential UUIDs.

smlar

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.

sql_firewall

Not supported

Not supported

0.8

0.8

0.8

Not supported

This extension is used as a firewall to protect databases from SQL injection attacks.

sslinfo

1.2

1.2

1.2

1.2

1.2

1.0

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

This extension provides functions that are used to return tables.

tds_fdw

Not supported

Not supported

2.0.1

2.0.1

Not supported

Not supported

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

timescaledb

2.5.0

2.5.0

1.7.1

1.7.1

1.3.0

Not supported

This extension is used to support features such as automatic sharding, efficient writes, retrieval, and near real-time aggregation of time series data.

tsearch2

Not supported

Not supported

Not supported

Not supported

Not supported

1.0

This extension provides a text search feature that is compatible with earlier tsearch2 versions.

tsm_system_rows

1.0

1.0

1.0

1.0

1.0

Not supported

This extension provides the table sampling method SYSTEM_ROWS.

tsm_system_time

1.0

1.0

1.0

1.0

1.0

Not supported

This extension provides the table sampling method SYSTEM_TIME.

unaccent

1.1

1.1

1.1

1.1

1.1

1.0

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

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

varbitx

Not supported

Not supported

Not supported

1.0

1.0

1.0

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

wal2json

2.3

2.3

2.3

2.2

2.2

Not supported

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

This extension provides XPath query and XSLT functionality.

zhparser

Not supported

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

4.0

Not supported

Not supported

This extension provides text indexing and analytics features.