Updated on 2026-09-18 GMT+08:00

Supported Extensions

The following table lists the extensions supported by the latest minor versions of RDS for PostgreSQL. You can use SELECT name FROM pg_available_extensions; to view the extensions supported by your DB instance. If any of the following extensions is not supported by your PostgreSQL version, migrate your data to an RDS for PostgreSQL instance of the latest version.

The extensions mysql_fdw, dblink, postgres_fdw, and tds_fdw are used to access data stored in remote database servers. Before using any of them, ensure that the server IP addresses of the two DB instances are in the same VPC and subnet.

Extensions Supported by PostgreSQL

Table 1 Supported extensions

Extension Name

Description

Whether to Preload Parameter Values and Reboot the Instance Before Installing the Extension

13

14

15

16

17

18

address_standardizer

An address standardization extension based on the PAGC standard

No

3.1.11

3.2.7

3.4.3

3.4.3

3.5.0

3.6.3

address_standardizer_data_us

An address standardization (US) data extension based on the PAGC standard

No

3.1.11

3.2.7

3.4.3

3.4.3

3.5.0

3.6.3

amcheck

Verifies the consistency between tables and indexes.

No

1.2

1.3

1.3

1.3

1.4

1.5

anon

Provides a data anonymization tool.

Yes

0.7.1

1.3.2

1.3.2

1.3.2

1.3.2

1.3.2

auth_delay

Causes the server to pause briefly before reporting authentication failure.

Yes

2

2

2

2

2

2

auto_explain

Records the execution plan of slow queries.

No

2

2

2

2

2

2

autoinc

A function used for auto-increment fields

No

1

1

1

1

1

1

bloom

Provides index access methods based on Bloom filters.

No

1.0

1.0

1.0

1.0

1.0

1.0

btree_gin

Provides GIN operator classes that implement B-tree equivalent behavior.

No

1.3

1.3

1.3

1.3

1.3

1.3

btree_gist

Provides GiST operator classes that implement B-tree equivalent behavior.

No

1.5

1.6

1.7

1.7

1.7

1.8

citext

Provides a case-insensitive string type.

No

1.6

1.6

1.6

1.6

1.6

1.8

cube

For details, see cube.

Provides a data type to represent multidimensional cubes.

No

1.4

1.5

1.5

1.5

1.5

1.5

dblink

Performs cross-database operations on tables.

No

1.2

1.2

1.2

1.2

1.2

1.2

dict_int

Adds an example of a full-text search dictionary template.

No

1.0

1.0

1.0

1

1

1.0

dict_xsyn

Adds an example of a full-text search synonym dictionary template.

No

1.0

1.0

1.0

1

1

1.0

earthdistance

For details, see earthdistance.

Provides two different approaches to calculating great circle distances on the surface of the Earth.

No

1.1

1.1

1.1

1.2

1.2

1.2

fuzzystrmatch

Determines the similarity and distance between strings.

No

1.1

1.1

1.1

1.2

1.2

1.2

h3

Provides Uber's H3 hierarchical hexagonal geospatial indexing.

No

4.2.3

4.2.3

4.2.3

4.2.3

4.2.3

4.2.3

hll

Quickly estimates service metrics such as PV and UV.

No

2.18

2.18

2.18

2.18

2.18

2.19

hstore

Stores key-value pairs in a single PostgreSQL instance.

No

1.7

1.8

1.8

1.8

1.8

1.8

hypopg

Creates virtual indexes.

No

1.4.1

1.4.2

1.4.2

1.4.2

1.4.2

1.4.2

icu

Precisely controls string collation, case conversion, and other behaviors.

No

1.0

1.0

1.0

1.0

1.0

1.0

insert_username

Tracks the username used to modify a table.

No

1

1

1

1

1

1

intagg

Provides an integer aggregator and an enumerator.

No

1.1

1.1

1.1

1.1

1.1

1.1

intarray

Provides some useful functions and operators to manipulate integer arrays that do not contain null values.

No

1.3

1.5

1.5

1.5

1.5

1.5

ip4r

Enables PostgreSQL to support the IP address range type.

No

2.4.2

2.4.2

2.4.2

2.4.2

2.4.2

2.4.2

isn

Validates input against a hard-coded list of prefixes, and also used to connect numbers during output.

No

1.2

1.2

1.2

1.2

1.2

1.3

jsonb_plperl

Establishes a conversion mechanism between JSONB and PL/Perl.

No

1

1

1

1

1

1.0

lo

Manages large objects.

No

1.1

1.1

1.1

1.1

1.1

1.2

ltree

Represents a label for data stored in a hierarchical tree structure.

No

1.2

1.2

1.2

1.2

1.3

1.3

moddatetime

Tracks the last modification time.

No

1

1

1

1

1

1

mysql_fdw

Queries the foreign data wrapper of the MySQL server.

No

2.9.2

2.9.3

2.9.3

2.9.3

2.9.3

2.9.3

obs_fdw

Queries the foreign data wrapper of OBS.

No

1.0.0

1.0.0

1.0.0

1.0.0

1.0.0

1.0.0

old_snapshot

Checks and debugs the mapping status from the internal timestamp to the transaction ID of the server.

No

-

1

1

1

-

-

oracle_fdw

Synchronizes PostgreSQL table updates to the tables in the Oracle database.

No

2.3.0

-

-

-

-

-

orafce

Provides a series of Oracle-compatible functions.

No

3.14.0

3.21.1

4.14

4.14

4.14

4.16.5

pageinspect

Performs low-level checks on database pages.

No

1.8

1.9

1.11

1.12

1.12

1.13

passwordcheck

Verifies the password strength.

No

2

2

2

2

2

2

pgaudit

Provides detailed session and object audit logs.

No

1.5.2

1.6.2

1.7.0

16.0

17.0

18.0

pg_bigm

Creates a 2-gram GIN index to accelerate the full-text search process.

No

1.2

1.2

1.2

1.2

1.2

1.2

pg_buffercache

Provides a method to check the shared buffer in real time.

No

1.3

1.3

1.3

1.4

1.5

1.6

pg_cron

Sets scheduled tasks.

Yes

1.6.7

1.6.7

1.6.7

1.6.7

1.6.7

1.6.7

pg_freespacemap

Checks the free space map (FSM).

No

1.2

1.2

1.2

1.2

1.2

1.3

pg_hint_plan

Uses special comment statements to prompt PostgreSQL to change its established execution plan.

Yes

1.3.10

1.4.3

1.5.2

1.6.1

1.7.0

1.8.0

pg_jieba

Implements word segmentation for on the entire Chinese text.

No

2.0.1

1.1.0

1.1.0

-

-

-

pg_partman

Creates and manages time- and sequence-based table partitioning sets.

No

-

5.0.1

5.0.1

5.0.1

5.2.2

5.4.3

pg_pathman

Provides optimized partitioning mechanism and functions to manage partitions.

Yes

1.5.12

-

-

-

-

-

pg_prewarm

Provides a convenient method to load data into the OS buffer or PostgreSQL buffer.

No

1.2

1.2

1.2

1.2

1.2

1.2

pg_qualstats

Collects statistics about predicates in the WHERE and JOIN clauses.

Yes

2.1.1

2.1.1

2.1.1

2.1.1

2.1.1

2.1.3

pg_repack

Cleans tablespaces online.

No

1.5.2

1.5.2

1.5.2

1.5.2

1.5.2

1.5.3

roaringbitmap

Uses the bitmap function to improve query performance.

No

0.5.4

0.5.4

0.5.4

0.5.4

0.5.4

1.1.0

pg_stat_kcache

Collects statistics about system read and write information.

Yes

2.3.0

2.3.0

2.3.0

2.3.0

2.3.0

2.3.1

pg_stat_statements

Provides a method for tracking execution statistics of all SQL statements executed by a server.

No

1.8

1.9

1.10

1.1

1.11

1.12

pg_surgery

Performs surgery on a damaged relation.

No

-

1.0

1.0

1.0

1.0

1.0

pg_tle

Provides trusted language extensions for PostgreSQL.

Yes

1.4.0

1.4.0

1.4.0

1.4.0

1.4.0

1.5.2

pg_track_settings

Traces the change history of database parameter settings.

No

2.1.2

2.1.2

2.1.2

2.1.2

-

-

pg_trgm

Provides functions and operators for measuring the similarity of alphanumeric text, as well as index operator classes that support fast similarity searching.

No

1.5

1.6

1.6

1.6

1.6

1.6

pg_visibility

Provides a means for examining the visibility map (VM) and page-level visibility information of a table.

No

1.2

1.2

1.2

1.2

1.2

1.2

pg_wait_sampling

Monitors and analyzes the waiting status of the database.

Yes

1.1.6

1.1.6

1.1.6

1.1.6

1.1.6

1.1.9

pg_walinspect

Provides functions to check the contents of PostgreSQL write-ahead logs.

No

-

-

1

1.1

1.1

1.1

pgcrypto

Provides cryptographic functions for PostgreSQL.

No

1.3

1.3

1.3

1.3

1.3

1.4

pgl_ddl_deploy

Enables PostgreSQL to support transparent logical DDL replication.

No

2.1.0

2.1.0

2.1.0

2.2.1

2.2.1

-

pglogical

Provides logical streaming replication using a publisher and subscriber model.

Yes

2.4.5

2.4.5

2.4.5

2.4.5

2.4.5

2.4.6

pgrouting

Provides the calculation and analysis functions for spatial geometric networks.

No

3.1.4

3.3.1

3.5.0

3.6.1

3.7.1

4.0.1

pgrowlocks

Provides a function to display row locking information about a specified table.

No

1.2

1.2

1.2

1.2

1.2

1.2

pg_sql_history

For details, see pg_sql_history.

An extension for SQL audit

No

1.2

1.2

1.2

1.2

1.2

1.2

pgstattuple

Provides multiple functions to obtain statistics at the tuple layer.

No

1.5

1.5

1.5

1.5

1.5

1.5

pgvector

An extension for high-dimensional vector similarity search

No

0.8.0

0.8.0

0.8.0

0.8.0

0.8.0

0.8.2

plpgsql

For details, see plpgsql.

Provides the SQL procedural language.

No

1.0

1.0

1.0

1.0

1.0

1.0

plperl

Provides the Perl procedural language.

No

1.0

1.0

1.0

1.0

1.0

1.0

plprofiler

Analyzes and tunes the performance of PL/pgSQL.

No

4.2.4

4.2.4

4.2.4

4.2.4

4.2.4

4.2.5

plproxy

Includes the CLUSTER and CONNECT modes, which help access the database in different ways.

No

2.11.0

2.11.0

2.11.0

2.11.0

2.11.0

2.11.0

postgis

For details, see postgis.

PostGIS extension that adds support for spatial and geographic information

No

3.1.11

3.2.7

3.4.3

3.4.3

3.5.0

3.6.3

postgis_raster

Processes raster spatial data.

No

3.1.11

3.2.7

3.4.3

3.4.3

3.5.0

3.6.3

postgis_sfcgal

PostGIS SFCGAL extension for spatial and geographic information

No

3.1.11

3.2.7

3.4.3

3.4.3

3.5.0

3.6.3

postgis_tiger_geocoder

PostGIS TIGER extension for spatial and geographic information

No

3.1.11

3.2.7

3.4.3

3.4.3

3.5.0

3.6.3

postgis_topology

PostGIS topology extension for spatial and geographic information

No

3.1.11

3.2.7

3.4.3

3.4.3

3.5.0

3.6.3

postgres_fdw

Performs cross-database operations on tables.

No

1.0

1.1

1.1

1.1

1.1

1.2

postgres-decoderbufs

For details, see postgres-decoderbufs.

An extension for logical decoding output

No

1.7.0

1.7.0

-

-

-

-

powa

PostgreSQL workload analyzer

No

4.2.2

4.2.2

4.2.2

4.2.2

5.0.0

5.1.1

rds_hwdrs_ddl

An extension for DRS migration

No

1

1

1

1

1

1

rds_hwdrs_privs

Escalates permissions for a version without root privilege escalation.

No

1

1

1

1

1

1

rds_pg_sql_ccl

Controls the number of concurrent SQL statements that can be executed.

No

1

1

1

1

1

1

rds_performance_statements

Monitors QPS-related metrics.

No

1.0

1.0

1.0

1.0

1.0

1.0

rum

Performs high-speed full-text search.

No

1.3.14

1.3.14

1.3.14

1.3.14

1.3.14

1.3.15

seg

Provides data types that represent line segments or floating-point ranges.

No

1.3

1.4

1.4

1.4

1.4

1.4

sslinfo

Obtains the SSL information of the client.

No

1.2

1.2

1.2

1.2

1.2

1.2

tablefunc

Provides functions that return tables (multiple rows).

No

1.0

1.0

1.0

1.0

1.0

1.0

tcn

Provides a trigger function to notify listeners of changes in table contents.

No

1

1

1

1

1

1

tds_fdw

Queries data in other types of databases.

No

2.0.4

2.0.4

2.0.4

2.0.4

2.0.4

2.0.5

test_decoding

Provides the SQL-based WAL logical decoding.

No

2

2

2

2

2

2

TimescaleDB

For details, see TimescaleDB.

Supports automatic sharding, efficient write, retrieval, and quasi-real-time aggregation of time series data.

Yes

2.1.0

2.7.0

2.11.1

2.14.2

2.17.2

2.27.0

tsm_system_rows

Provides the SYSTEM_ROWS sampling method for tables.

No

1.0

1.0

1.0

1.0

1.0

1.0

tsm_system_time

Provides the SYSTEM_TIME sampling method for tables.

No

1.0

1.0

1.0

1.0

1.0

1.0

unaccent

A text search dictionary that removes accents (diacritical marks) from lexemes

No

1.1

1.1

1.1

1.1

1.1

1.1

uuid-ossp

Provides functions that generate universally unique identifiers (UUIDs) using one of several standard algorithms.

No

1.1

1.1

1.1

1.1

1.1

1.1

wal2json

For details, see wal2json.

Outputs logical log files in JSON format.

No

2.5

2.5

2.5

2.5

2.5

2.6

xml2

Provides XPath query and XSLT functions.

No

1.1

1.1

1.1

1.1

1.1

1.2

zhparser

Performs full-text search in Chinese.

No

2.2

2.2

2.2

2.2

2.2

2.3

pg_stat_monitor

A query performance monitoring tool for PostgreSQL, which can provide aggregate statistics, client information, execution plans, and histograms

Yes

2.1

2.1

2.1

2.1

2.1

2.3.2

pg_tm_aux

Allows the creation of a logical replication slot at a past log sequence number (LSN).

No

1.1

1.1

1.1

1.1

1.1

1.1

pg_net

Initiates HTTP requests asynchronously.

Yes

-

-

-

-

0.20.2

0.20.2

recyclebin

Provides the table recycle bin function.

Yes

0.4

0.4

0.4

0.4

0.4

0.4

supabase_vault

Encrypts, stores, and manages sensitive character strings securely within a database.

Yes

-

-

-

-

0.3.1

0.3.1

Table 2 Supported extensions

Extension Name

Description

Whether to Preload Parameter Values and Reboot the Instance Before Installing the Extension

9.5

9.6

10

11

12

address_standardizer

An address standardization extension based on the PAGC standard

No

2.5.1

2.5.1

2.5.1

2.5.1

3.0.0

address_standardizer_data_us

An address standardization (US) data extension based on the PAGC standard

No

2.5.1

2.5.1

2.5.1

2.5.1

3.0.0

amcheck

Verifies the consistency between tables and indexes.

No

-

-

-

1.1

1.2

anon

Provides a data anonymization tool.

Yes

-

-

-

-

0.7.1

auth_delay

Causes the server to pause briefly before reporting authentication failure.

Yes

-

-

-

-

2

auto_explain

Records the execution plan of slow queries.

No

2

2

2

2

2

autoinc

A function used for auto-increment fields

No

-

-

-

-

1

bloom

Provides index access methods based on Bloom filters.

No

-

-

-

1.0

1.0

btree_gin

Provides GIN operator classes that implement B-tree equivalent behavior.

No

1.0

1.0

1.2

1.3

1.3

btree_gist

Provides GiST operator classes that implement B-tree equivalent behavior.

No

1.1

1.2

1.5

1.5

1.5

citext

Provides a case-insensitive string type.

No

1.1

1.3

1.4

1.5

1.6

cube

For details, see cube.

Provides a data type to represent multidimensional cubes.

No

1.0

1.2

1.2

1.4

1.4

dblink

Performs cross-database operations on tables.

No

1.1

1.2

1.2

1.2

1.2

dict_int

Adds an example of a full-text search dictionary template.

No

1.0

1.0

1.0

1.0

1.0

dict_xsyn

Adds an example of a full-text search synonym dictionary template.

No

1.0

1.0

1.0

1.0

1.0

earthdistance

For details, see earthdistance.

Provides two different approaches to calculating great circle distances on the surface of the Earth.

No

1.0

1.1

1.1

1.1

1.1

fuzzystrmatch

Determines the similarity and distance between strings.

No

1.0

1.1

1.1

1.1

1.1

hll

Quickly estimates service metrics such as PV and UV.

No

2.12

2.12

2.12

2.12

2.14

hstore

Stores key-value pairs in a single PostgreSQL instance.

No

1.3

1.4

1.4

1.5

1.6

hypopg

Creates virtual indexes.

No

-

-

-

1.4.0

1.4.1

icu

Precisely controls string collation, case conversion, and other behaviors.

No

-

-

-

1.0

1.0

insert_username

Tracks the username used to modify a table.

No

-

-

-

-

1

intagg

Provides an integer aggregator and an enumerator.

No

1.0

1.1

1.1

1.1

1.1

intarray

Provides some useful functions and operators to manipulate integer arrays that do not contain null values.

No

1.0

1.2

1.2

1.2

1.2

ip4r

Enables PostgreSQL to support the IP address range type.

No

-

-

-

-

2.4.2

isn

Validates input against a hard-coded list of prefixes, and also used to connect numbers during output.

No

1.0

1.1

1.1

1.2

1.2

jsonb_plperl

Establishes a conversion mechanism between JSONB and PL/Perl.

No

-

-

-

-

1

lo

Manages large objects.

No

-

-

-

-

1.1

ltree

Represents a label for data stored in a hierarchical tree structure.

No

1.0

1.1

1.1

1.1

1.1

moddatetime

Tracks the last modification time.

No

-

-

-

-

1

mysql_fdw

Queries the foreign data wrapper of the MySQL server.

No

-

-

-

2.9.1

2.9.2

obs_fdw

Queries the foreign data wrapper of OBS.

No

-

-

-

-

1.0.0

old_snapshot

Checks and debugs the mapping status from the internal timestamp to the transaction ID of the server.

No

-

-

-

-

-

oracle_fdw

Synchronizes PostgreSQL table updates to the tables in the Oracle database.

No

-

-

2.1.0

2.1.0

2.2.0

orafce

Provides a series of Oracle-compatible functions.

No

3.8.0

3.8.0

3.8.0

3.8.0

3.8.0

pageinspect

Performs low-level checks on database pages.

No

1.3

1.5

1.6

1.7

1.7

passwordcheck

Verifies the password strength.

No

2

2

2

2

2

pgaudit

Provides detailed session and object audit logs.

No

-

-

-

-

1.4.3

pg_bigm

Creates a 2-gram GIN index to accelerate the full-text search process.

No

-

-

-

1.2_20200228

1.2

pg_buffercache

Provides a method to check the shared buffer in real time.

No

1.1

1.2

1.3

1.3

1.3

pg_cron

Sets scheduled tasks.

Yes

-

-

-

-

1.6.7

pg_freespacemap

Checks the free space map (FSM).

No

1.0

1.1

1.2

1.2

1.2

pg_hint_plan

Uses special comment statements to prompt PostgreSQL to change its established execution plan.

Yes

1.1.5

1.2.0

1.3.0

1.3.5

1.3.9

pg_jieba

Implements word segmentation for on the entire Chinese text.

No

1.1.0

1.1.0

1.1.0

1.1.0

1.1.0

pg_partman

Creates and manages time- and sequence-based table partitioning sets.

No

-

-

-

-

-

pg_pathman

Provides optimized partitioning mechanism and functions to manage partitions.

Yes

1.5.8

1.5.8

1.5.8

1.5.8

1.5.12

pg_prewarm

Provides a convenient method to load data into the OS buffer or PostgreSQL buffer.

No

1.0

1.1

1.1

1.2

1.2

pg_qualstats

Collects statistics about predicates in the WHERE and JOIN clauses.

Yes

-

-

-

2.1.0

2.1.0

pg_repack

Cleans tablespaces online.

No

1.5.0

1.5.0

1.5.0

1.5.0

1.5.0

roaringbitmap

Uses the bitmap function to improve query performance.

No

-

-

-

0.5.4

0.5.4

pg_stat_kcache

Collects statistics about system read and write information.

Yes

-

-

-

2.2.3

2.2.3

pg_stat_statements

Provides a method for tracking execution statistics of all SQL statements executed by a server.

No

1.3

1.4

1.6

1.6

1.7

pg_surgery

Performs surgery on a damaged relation.

No

-

-

-

-

-

pg_tle

Provides trusted language extensions for PostgreSQL.

Yes

-

-

-

-

-

pg_track_settings

Traces the change history of database parameter settings.

No

-

-

-

2.1.2

2.1.2

pg_trgm

Provides functions and operators for measuring the similarity of alphanumeric text, as well as index operator classes that support fast similarity searching.

No

1.1

1.3

1.3

1.4

1.4

pg_visibility

Provides a means for examining the visibility map (VM) and page-level visibility information of a table.

No

-

-

-

1.2

1.2

pg_wait_sampling

Monitors and analyzes the waiting status of the database.

Yes

-

-

-

1.1.5

1.1.5

pg_walinspect

Provides functions to check the contents of PostgreSQL write-ahead logs.

No

-

-

-

-

-

pgcrypto

Provides cryptographic functions for PostgreSQL.

No

1.2

1.3

1.3

1.3

1.3

pgl_ddl_deploy

Enables PostgreSQL to support transparent logical DDL replication.

No

-

-

-

-

2.1.0

pglogical

Provides logical streaming replication using a publisher and subscriber model.

Yes

-

-

-

2.4.4

2.4.4

pgrouting

Provides the calculation and analysis functions for spatial geometric networks.

No

-

-

-

3.1.0

3.1.0

pgrowlocks

Provides a function to display row locking information about a specified table.

No

1.1

1.2

1.2

1.2

1.2

pg_sql_history

For details, see pg_sql_history.

An extension for SQL audit

No

1.2

1.2

1.2

1.2

1.2

pgstattuple

Provides multiple functions to obtain statistics at the tuple layer.

No

1.3

1.4

1.5

1.5

1.5

pgvector

An extension for high-dimensional vector similarity search

No

-

-

-

-

0.7.0

plpgsql

For details, see plpgsql.

Provides the SQL procedural language.

No

1.0

1.0

1.0

1.0

1.0

plperl

Provides the Perl procedural language.

No

-

-

-

1.0

1.0

plprofiler

Analyzes and tunes the performance of PL/pgSQL.

No

-

-

-

-

4.2.4

plproxy

Includes the CLUSTER and CONNECT modes, which help access the database in different ways.

No

-

-

-

2.11.0

2.11.0

postgis

For details, see postgis.

PostGIS extension that adds support for spatial and geographic information

No

2.5.1

2.5.1

2.5.1

2.5.1

3.0.0

postgis_raster

Processes raster spatial data.

No

Integrated to postgis

Integrated to postgis

Integrated to postgis

Integrated to postgis

3.0.0

postgis_sfcgal

PostGIS SFCGAL extension for spatial and geographic information

No

2.5.1

2.5.1

2.5.1

2.5.1

3.0.0

postgis_tiger_geocoder

PostGIS TIGER extension for spatial and geographic information

No

2.5.1

2.5.1

2.5.1

2.5.1

3.0.0

postgis_topology

PostGIS topology extension for spatial and geographic information

No

2.5.1

2.5.1

2.5.1

2.5.1

3.0.0

postgres_fdw

Performs cross-database operations on tables.

No

1.0

1.0

1.0

1.0

1.0

postgres-decoderbufs

For details, see postgres-decoderbufs.

An extension for logical decoding output

No

-

-

-

1.7.0

1.7.0

powa

PostgreSQL workload analyzer

No

-

-

-

-

4.2.2

rds_hwdrs_ddl

An extension for DRS migration

No

1

1

1

1

1

rds_hwdrs_privs

Escalates permissions for a version without root privilege escalation.

No

1

1

1

1

1

rds_pg_sql_ccl

Controls the number of concurrent SQL statements that can be executed.

No

-

-

-

-

1

rum

Performs high-speed full-text search.

No

-

-

-

1.3

1.3.14

seg

Provides data types that represent line segments or floating-point ranges.

No

-

-

-

-

1.3

sslinfo

Obtains the SSL information of the client.

No

-

-

-

1.2

1.2

tablefunc

Provides functions that return tables (multiple rows).

No

1.0

1.0

1.0

1.0

1.0

tcn

Provides a trigger function to notify listeners of changes in table contents.

No

-

-

-

-

1

tds_fdw

Queries data in other types of databases.

No

-

-

2.0.3

2.0.3

2.0.3

test_decoding

Provides the SQL-based WAL logical decoding.

No

2

2

2

2

2

TimescaleDB

For details, see TimescaleDB.

Supports automatic sharding, efficient write, retrieval, and quasi-real-time aggregation of time series data.

Yes

0

1.3.2

1.3.2

1.3.2

1.7.0

tsm_system_rows

Provides the SYSTEM_ROWS sampling method for tables.

No

1.0

1.0

1.0

1.0

1.0

tsm_system_time

Provides the SYSTEM_TIME sampling method for tables.

No

1.0

1.0

1.0

1.0

1.0

unaccent

A text search dictionary that removes accents (diacritical marks) from lexemes

No

1.0

1.1

1.1

1.1

1.1

uuid-ossp

Provides functions that generate universally unique identifiers (UUIDs) using one of several standard algorithms.

No

1.0

1.1

1.1

1.1

1.1

wal2json

For details, see wal2json.

Outputs logical log files in JSON format.

No

-

-

-

2.5

2.5

xml2

Provides XPath query and XSLT functions.

No

-

-

-

1.1

1.1

zhparser

Performs full-text search in Chinese.

No

2.2

2.2

2.2

2.2

2.2

pg_stat_monitor

A query performance monitoring tool for PostgreSQL, which can provide aggregate statistics, client information, execution plans, and histograms

Yes

-

-

-

-

2.1

pg_tm_aux

Allows the creation of a logical replication slot at a past log sequence number (LSN).

No

-

-

-

-

1.1

pg_net

Initiates HTTP requests asynchronously.

Yes

-

-

-

-

-

recyclebin

Provides the table recycle bin function.

Yes

-

-

-

-

0.4

supabase_vault

Encrypts, stores, and manages sensitive character strings securely within a database.

Yes

-

-

-

-

-

Extension Description

  • postgis
    • Creating postgis_topology and postgis_tiger_geocoder will change the search_path settings. However, this change will not take effect for established connections. To use the two extensions, re-establish a connection to update the search_path settings.
  • plpgsql

    plpgsql 1.0 provides the SQL procedural language and is installed by default.

  • earthdistance

    To install the earthdistance extension, you must install the cube extension first.

  • cube

    If the earthdistance extension has been installed, deleting the cube extension will cause the earthdistance extension to be unavailable.

  • TimescaleDB

    The TimescaleDB extension of RDS for PostgreSQL supports only the features of the Apache protocol. It does not support the features of the TSL protocol. For details, see APIs Not Supported by TimescaleDB.

  • wal2json, postgres-decoderbufs

    They are logical replication extensions. You can use them directly without installing them through control_extension.

    They are not listed in the pg_available_extensions view. To check whether the two extensions are supported, run the statements below. If no error is reported during the execution, the extensions are supported.

    • wal2json
      select pg_create_logical_replication_slot('tst_wal2json', 'wal2json');
    • postgres-decoderbufs
      select pg_create_logical_replication_slot('tst_decoderbufs', 'decoderbufs');
    After the execution, delete the slot to prevent WAL log accumulation.
    • Delete the slot tst_wal2json.
      select pg_drop_replication_slot('tst_wal2json');
    • Delete the slot tst_decoderbufs.
      select pg_drop_replication_slot('tst_decoderbufs');
  • pg_sql_history

    This extension is used by Database Security Service (DBSS) to audit SQL operations of RDS for PostgreSQL instances. SQL statements retrieved by this extension may be truncated because each record is allocated a fixed space of 4 KB. This space includes a retrieved SQL statement along with information such as the database name, username, and SQL type.