Quick Starts

Extensions supported by ApsaraDB RDS for PostgreSQL

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

    • If you want to use the sql_firewall extension and the pg_stat_statements extension at the same time, you must add sql_firewall and pg_stat_statements to the value of the shared_preload_libraries parameter. Make sure that pg_stat_statements is followed by sql_firewall.

  • 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 x86 architecture and the ARM architecture. For more information about the x86 architecture and the ARM architecture, see Architectures.

Important

The extensions that are supported for ApsaraDB RDS for PostgreSQL instances are changed. Starting April 17, 2023, some extensions can no longer be created for ApsaraDB RDS for PostgreSQL instances that run minor engine versions earlier than 20230330. The existing extensions are not affected. For more information, see [Notice] Starting April 17, 2023, some extensions can no longer be created for ApsaraDB RDS for PostgreSQL instances that run earlier minor engine versions.

x86

Manage the parameters of an ApsaraDB RDS for PostgreSQL instance.

The following tables describe the extensions that are supported by the x86 architecture and the ARM architecture. For more information about the x86 architecture and the ARM architecture, see Manage the parameters of an ApsaraDB RDS for PostgreSQL instance.

The following tables describe the extensions that are supported by the x86 architecture and the ARM architecture. For more information about the x86 architecture and the ARM architecture, see Architectures.

Important

The extensions that are supported for ApsaraDB RDS for PostgreSQL instances are changed. Starting April 17, 2023, some extensions can no longer be created for ApsaraDB RDS for PostgreSQL instances that run minor engine versions earlier than 20230330. The existing extensions are not affected. For more information, see [Notice] Starting April 17, 2023, some extensions can no longer be created for ApsaraDB RDS for PostgreSQL instances that run earlier minor engine versions.

x86

Architectures.

Important

The extensions that are supported for ApsaraDB RDS for PostgreSQL instances are changed. Starting April 17, 2023, some extensions can no longer be created for ApsaraDB RDS for PostgreSQL instances that run minor engine versions earlier than 20230330. The existing extensions are not affected. For more information, see Manage the parameters of an ApsaraDB RDS for PostgreSQL instance.

The following tables describe the extensions that are supported by the x86 architecture and the ARM architecture. For more information about the x86 architecture and the ARM architecture, see Architectures.

Important

The extensions that are supported for ApsaraDB RDS for PostgreSQL instances are changed. Starting April 17, 2023, some extensions can no longer be created for ApsaraDB RDS for PostgreSQL instances that run minor engine versions earlier than 20230330. The existing extensions are not affected. For more information, see [Notice] Starting April 17, 2023, some extensions can no longer be created for ApsaraDB RDS for PostgreSQL instances that run earlier minor engine versions.

x86

[Notice] Starting April 17, 2023, some extensions can no longer be created for ApsaraDB RDS for PostgreSQL instances that run earlier minor engine versions.

x86

Extension

15

14

13

12

11

10

Description

address_standardizer

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

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

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

This extension provides sample Generalized Inverted Index (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.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 or all enumerated data types.

chkpass

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

1.4

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

cube

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

This extension is used to manage tables across databases.

decoderbufs

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

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

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

encdb

1.1.12

1.1.12

1.1.12

1.1.12

1.1.12

1.1.12

This extension is used to support fully encrypted databases.

fuzzystrmatch

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

5.4

5.4

5.4

5.4

5.3

5.3

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

5.4

5.4

5.4

5.4

5.3

5.3

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

ganos_geometry

5.4

5.4

5.4

5.4

5.3

5.3

This extension is used to compute and analyze spatial geometries.

ganos_geometry_pyramid

5.4

5.4

5.4

5.4

5.3

5.3

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

ganos_geometry_pyramid

5.4

5.4

5.4

5.4

5.3

5.3

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

ganos_geometry_pyramid

5.4

5.4

5.4

5.4

5.3

5.3

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

ganos_geometry_sfcgal

5.4

5.4

5.4

5.4

5.3

5.3

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

ganos_geometry_topology

5.4

5.4

5.4

5.4

5.3

Was this helpful?

open