All Products
Search
Document Center

Supported plug-ins

Last Updated: Jun 10, 2022

This topic provides an overview of the plug-ins and plug-in versions that are supported by ApsaraDB RDS for PostgreSQL instances.

Note
  • If your RDS instance does not support a few plug-ins 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.

  • If you have requirements or suggestions for the plug-ins that are described in the following table, you can submit a ticket.

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

  • Before you use some plug-ins, you must add the names of the plug-ins to the value of the shared_preload_libraries parameter of your RDS instance. Otherwise, you cannot create the plug-ins.

    • The plug-ins 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 plug-in, 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.

Plug-in

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 plug-in is used to standardize the names of geographic locations based on Postal Address Geocoder (PAGC). For more information, see Tuning the Standardizer.

address_standardizer_data_us

3.1.4

3.1.4

3.1.4

3.1.4

3.1.4

2.5.4

This plug-in is used to standardize the names of the geographic locations in the United States based on PAGC. For more information, see Tuning the Standardizer.

aggs_for_arrays

Not supported

Not supported

Not supported

Not supported

1.3.1

Not supported

This plug-in provides an extension function that is used to compute the statistics of numeric arrays.

bloom

1.0

1.0

1.0

1.0

1.0

Not supported

This plug-in 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 plug-in provides sample GIN operator classes that are used to implement B-tree equivalent behavior for multiple data types and all enumerated data types.

btree_gist

1.6

1.5

1.5

1.5

1.5

1.0

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

chkpass

Not supported

Not supported

Not supported

Not supported

1.0

1.0

This plug-in 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 plug-in provides a string type that is not case-sensitive.

cube

1.5

1.4

1.4

1.4

1.2

1.0

This plug-in provides a data type that is used to represent multidimensional cubes.

dblink

1.2

1.2

1.2

1.2

1.2

1.1

This plug-in 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 plug-in 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 plug-in provides a sample add-on dictionary template that is used to run full-text searches.

earthdistance

1.1

1.1

1.1

1.1

1.1

1.0

This plug-in provides two different methods that are used to calculate great-circle distances on the surface of the Earth.

encdb

1.1.9

1.1.9

1.1.9

1.1.9

1.1.9

Not supported

This plug-in is used to support fully encrypted databases.

fuzzystrmatch

1.1

1.1

1.1

1.1

1.1

1.0

This plug-in is used to calculate the similarity and distance between strings.

ganos_address_standardizer

4.6

4.6

4.6

4.6

4.6

Not supported

This plug-in 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.6

4.6

4.6

4.6

4.6

Not supported

This plug-in is used to standardize the names of the geographic locations in the United States based on PAGC. For more information, see Tuning the Standardizer.

ganos_geometry

4.6

4.6

4.6

4.6

4.6

Not supported

This plug-in is used to compute and analyze spatial geometries.

ganos_geometry_sfcgal

4.6

4.6

4.6

4.6

4.6

Not supported

This plug-in is used to compute and analyze spatial geometries.

ganos_geometry_topology

4.6

4.6

4.6

4.6

4.6

Not supported

This plug-in is an extension of the SFCGAL plug-in that is used to process spatial geometries.

ganos_networking

4.6

4.6

4.6

4.6

4.6

Not supported

This plug-in is used to compute and analyze spatial network geometries.

ganos_pointcloud

4.6

4.6

4.6

4.6

4.6

Not supported

This plug-in is used to store, compute, and analyze point clouds.

ganos_pointcloud_geometry

4.6

4.6

4.6

4.6

4.6

Not supported

This plug-in is used to store, compute, and analyze point clouds.

ganos_raster

4.6

4.6

4.6

4.6

4.6

Not supported

This plug-in is used to store, compute, and analyze spatial grids.

ganos_spatialref

4.6

4.6

4.6

4.6

4.6

Not supported

This plug-in is used to compute and analyze spatial references.

ganos_tiger_geocoder

4.6

4.6

4.6

4.6

4.6

Not supported

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

ganos_trajectory

4.6

4.6

4.6

4.6

4.6

Not supported

This plug-in 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 plug-in is used to estimate business metrics, such as page views (PV) and unique visitors (UV), at fast speeds.

hstore

1.8

1.7

1.6

1.5

1.4

1.3

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

hypopg

1.3.1

1.3.1

1.3.1

1.3.1

1.3.1

Not supported

This plug-in is used to create virtual indexes.

imgsmlr

Not supported

Not supported

Not supported

Not supported

Not supported

1.0

This plug-in is used to search for similar images.

index_adviser

2.0

2.0

2.0

2.0

2.0

Not supported

This plug-in is used to recommend indexes.

intagg

1.1

1.1

1.1

1.1

1.1

1.0

This plug-in provides an integer aggregator and an enumerator.

intarray

1.5

1.3

1.2

1.2

1.2

1.0

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

isn

1.2

1.2

1.2

1.2

1.1

1.0

This plug-in is used to validate input numbers and hyphenate output numbers based on a hard-coded list of prefixes.

ltree

1.2

1.2

1.1

1.1

1.1

1.0

This plug-in 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 plug-in is an extension that 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 plug-in is used to query the logs.

madlib

Not supported

Not supported

1.18.0

1.18.0

Not supported

Not supported

This plug-in 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 plug-in is used to read data from 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 plug-in 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 plug-in provides functions that are compatible with Oracle.

oss_fdw

Not supported

1.1

1.1

1.1

1.1

1.1

This plug-in 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 plug-in is used to efficiently search for vectors.

pg_bigm

1.2

1.2

1.2

1.2

1.2

Not supported

This plug-in 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 plug-in 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 plug-in is used to control the concurrency of SQL statements.

pg_cron

Not supported

Not supported

1.1

1.1

1.1

Not supported

This plug-in is used to configure scheduled tasks.

pg_freespacemap

1.2

1.2

1.2

1.2

1.2

1.0

This plug-in is used to examine the free space map (FSM).

pg_jieba

Not supported

1.1.0

1.1.0

1.1.0

1.1.0

Not supported

This plug-in is used to segment Chinese texts.

pg_hint_plan

Not supported

1.3.7

1.3.7

1.3.7

1.3.0

1.1.3

This plug-in is used to add hints to SQL statements. 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 plug-in is used to partition tables at high performance.

pg_prewarm

1.2

1.2

1.2

1.2

1.1

1.0

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

pg_repack

Not supported

1.4.6

1.4.6

1.4.6

1.4.6

Not supported

This plug-in is used to clear tablespaces that stay online.

pg_sphere

Not supported

Not supported

Not supported

Not supported

1.0

1.0

This plug-in 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 plug-in is used to track the statistics of all SQL statements that are executed on a server.

pg_trgm

1.6

1.5

1.4

1.4

1.3

1.1

This plug-in provides functions and operators that are used to calculate the similarity between alphanumeric texts. This plug-in also provides index operator classes that are used to search for similar strings at fast speeds.

pgaudit

1.6.1

1.5

1.4.1

1.3.2

1.2.2

Not supported

This plug-in is used to generate audit logs. The audit logs contain details about sessions and objects.

pgcrypto

1.3

1.3

1.3

1.3

1.3

1.1

This plug-in provides cryptographic functions for PostgreSQL.

pglogical

2.4.0

2.4.0

2.4.0

2.4.0

2.4.0

Not supported

This plug-in 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 plug-in is used to compute and analyze spatial network geometries.

pgrowlocks

1.2

1.2

1.2

1.2

1.2

1.1

This plug-in provides a function that is used to display the row lock information of a specified table.

pgstattuple

1.5

1.5

1.5

1.5

1.5

1.2

This plug-in 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 plug-in is used to debug stored procedures.

plperl

1.0

1.0

1.0

1.0

1.0

1.0

This plug-in is used to support the Perl procedural language.

plpgsql

1.0

1.0

1.0

1.0

1.0

1.0

This plug-in 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 plug-in provides two modes that are used to access an ApsaraDB RDS for PostgreSQL instance: CLUSTER and CONNECT.

pltcl

1.0

1.0

1.0

1.0

1.0

1.0

This plug-in 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 plug-in 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 plug-in is an extension that is used to process and store spatial geographic information.

postgis_sfcgal

3.1.4

3.1.4

3.1.4

3.1.4

3.1.4

Not supported

This plug-in 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 plug-in is an extension that 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 plug-in is an extension that is used to manage topological objects in PostGIS.

postgres_fdw

1.1

1.0

1.0

1.0

1.0

1.0

This plug-in is used to manage tables across databases.

q3c

Not supported

Not supported

Not supported

Not supported

1.5.0

1.5.0

This plug-in is used to create spatial indexes on a sphere.

rdkit

Not supported

Not supported

3.8

Not supported

Not supported

3.4

This plug-in 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 plug-in is used to compute bitmaps to increase query performance.

rum

Not supported

1.3

1.3

1.3

1.3

Not supported

This plug-in 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 plug-in is used to generate sequential UUIDs.

smlar

1.0

1.0

1.0

1.0

1.0

1.0

This plug-in is used to calculate the similarity between two arrays of the same data type.

sql_firewall

Not supported

Not supported

0.8

0.8

0.8

Not supported

This plug-in 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 plug-in is used to obtain information about the SSL certificate that is provided by the connected client.

tablefunc

1.0

1.0

1.0

1.0

1.0

1.0

This plug-in 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 plug-in is used to query data from an ApsaraDB RDS instance that does not run PostgreSQL.

timescaledb

Not supported

2.5.0

1.7.1

1.7.1

1.3.0

Not supported

This plug-in is used to support features such as the 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 plug-in 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 plug-in provides a table sampling method called SYSTEM_ROWS.

tsm_system_time

1.0

1.0

1.0

1.0

1.0

Not supported

This plug-in provides a table sampling method called SYSTEM_TIME.

unaccent

1.1

1.1

1.1

1.1

1.1

1.0

This plug-in provides a text search dictionary that is used to remove accent marks or diacritic signs from lexemes.

uuid-ossp

1.1

1.1

1.1

1.1

1.1

1.0

This plug-in provides functions that use a standard algorithm to generate UUIDs.

varbitx

Not supported

Not supported

Not supported

1.0

1.0

1.0

This plug-in is used to support various BIT-type operations.

xml2

1.1

1.1

1.1

1.1

1.1

1.0

This plug-in provides XPath query and XSLT functionality.

zhparser

Not supported

1.0

1.0

1.0

1.0

1.0

This plug-in is used to support full-text searches in Chinese.

zombodb

Not supported

Not supported

Not supported

4.0

Not supported

Not supported

This plug-in provides text indexing and analytics features.