Help Center/ Relational Database Service/ User Guide/ Working with RDS for PostgreSQL/ Extension Management/ Supported Extensions
Updated on 2024-10-14 GMT+08:00
View PDF
Share

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, pgsql-ogr-fdw, 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 of RDS for PostgreSQL 13, 14, and 15 are available only for users with the open beta test (OBT) permission. You can contact customer service to apply for the permission.

Table 1 Supported extensions

Extension Name

PostgreSQL 9.5

PostgreSQL 9.6

PostgreSQL 10

PostgreSQL 11

PostgreSQL 12

PostgreSQL 13

PostgreSQL 14

PostgreSQL 15

PostgreSQL 16

address_standardizer

2.5.1

2.5.1

2.5.1

2.5.1

3.0.0

3.1.0

3.2.6

3.4.1

3.4.1

address_standardizer_data_us

2.5.1

2.5.1

2.5.1

2.5.1

3.0.0

3.1.0

3.2.6

3.4.1

3.4.1

amcheck

-

-

-

1.1

1.2

1.2

1.3

1.3

1.3

auth_delay

-

-

-

-

2

2

2

2

2

auto_explain

2

2

2

2

2

2

2

2

2

autoinc

-

-

-

-

1

1

1

1

1

bloom

-

-

-

1.0

1.0

1.0

1.0

1.0

1

btree_gin

1.0

1.0

1.2

1.3

1.3

1.3

1.3

1.3

1.3

btree_gist

1.1

1.2

1.5

1.5

1.5

1.5

1.6

1.7

1.7

citext

1.1

1.3

1.4

1.5

1.6

1.6

1.6

1.6

1.6

cube

For details, see cube.

1.0

1.2

1.2

1.4

1.4

1.4

1.5

1.5

1.5

dblink

1.1

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

dict_int

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1

dict_xsyn

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1

earthdistance

For details, see earthdistance.

1.0

1.1

1.1

1.1

1.1

1.1

1.1

1.1

1.1

fuzzystrmatch

1.0

1.1

1.1

1.1

1.1

1.1

1.1

1.1

1.2

hll

2.12

2.12

2.12

2.12

2.14

2.18

2.18

2.18

2.18

hstore

1.3

1.4

1.4

1.5

1.6

1.7

1.8

1.8

1.8

hypopg

-

-

-

1.4.0

1.4.0

1.4.0

1.4.0

1.4.0

1.4.0

icu

-

-

-

1.0

1.0

1.0

1.0

1.0

1

insert_username

-

-

-

-

1

1

1

1

1

intagg

1.0

1.1

1.1

1.1

1.1

1.1

1.1

1.1

1.1

intarray

1.0

1.2

1.2

1.2

1.2

1.3

1.5

1.5

1.5

ip4r

-

-

-

-

2.4.2

2.4.2

2.4.2

2.4.2

2.4.2

isn

1.0

1.1

1.1

1.2

1.2

1.2

1.2

1.2

1.2

jsonb_plperl

-

-

-

-

1

1

1

1

1

lo

-

-

-

-

1.1

1.1

1.1

1.1

1.1

ltree

1.0

1.1

1.1

1.1

1.1

1.2

1.2

1.2

1.2

moddatetime

-

-

-

-

1

1

1

1

1

mysql_fdw

-

-

-

2.9.1

2.9.1

2.9.1

2.9.1

2.9.1

2.9.1

old_snapshot

-

-

-

-

-

-

1.0

1.0

1

orafce

3.8.0

3.8.0

3.8.0

3.8.0

3.8.0

3.14.0

3.21.1

4.4.0

4.4.0

pageinspect

1.3

1.5

1.6

1.7

1.7

1.8

1.9

1.11

1.12

passwordcheck

2

2

2

2

2

2

2

2

2

pgAudit

-

-

-

-

1.6.2

1.6.2

1.6.2

1.7.0

16

pg_bigm

-

-

-

1.2_20200228

1.2_20200228

1.2_20200228

1.2_20200228

1.2_20200228

-

pg_buffercache

1.1

1.2

1.3

1.3

1.3

1.3

1.3

1.3

1.4

pg_cron

-

-

-

-

1.6.2

1.6.2

1.6.2

1.6.2

1.6.2

pg_freespacemap

1.0

1.1

1.2

1.2

1.2

1.2

1.2

1.2

1.2

pg_hint_plan

1.1.5

1.2.0

1.3.0

1.3.5

1.3.9

1.3.9

1.4.2

1.5.1

1.6.0

pg_jieba

1.1.0

1.1.0

1.1.0

1.1.0

1.1.0

2.0.1

1.1.0

1.1.0

-

pg_partman

-

-

-

-

-

-

5.0.1

5.0.1

5.0.1

pg_pathman

1.5.8

1.5.8

1.5.8

1.5.8

1.5.12

1.5.12

-

-

-

pg_prewarm

1.0

1.1

1.1

1.2

1.2

1.2

1.2

1.2

1.2

pg_qualstats

-

-

-

2.1.0

2.1.0

2.1.0

2.1.0

2.1.0

2.1.0

pg_repack

1.5.0

1.5.0

1.5.0

1.5.0

1.5.0

1.5.0

1.5.0

1.5.0

1.5.0

pg_roaringbitmap

-

-

-

0.5.4

0.5.4

0.5.4

0.5.4

0.5.4

0.5.4

pg_stat_kcache

-

-

-

2.2.3

2.2.3

2.2.3

2.2.3

2.2.3

2.2.3

pg_stat_statements

1.3

1.4

1.6

1.6

1.7

1.8

1.9

1.10

1.1

pg_surgery

-

-

-

-

-

-

1.0

1.0

1

pg_tle

-

-

-

-

-

1.2.0

1.2.0

1.2.0

1.2.0

pg_track_settings

-

-

-

2.1.2

2.1.2

2.1.2

2.1.2

2.1.2

2.1.2

pg_trgm

1.1

1.3

1.3

1.4

1.4

1.5

1.6

1.6

1.6

pg_visibility

-

-

-

1.2

1.2

1.2

1.2

1.2

1.2

pg_wait_sampling

-

-

-

1.1.5

1.1.5

1.1.5

1.1.5

1.1.5

1.1.5

pgcrypto

1.2

1.3

1.3

1.3

1.3

1.3

1.3

1.3

1.3

pgl_ddl_deploy

-

-

-

-

2.1.0

2.1.0

2.1.0

2.1.0

2.2.1

pglogical

-

-

-

2.4.4

2.4.4

2.4.4

2.4.4

2.4.4

2.4.4

pg_profile_pro

For details, see pg_profile_pro.

-

-

-

-

1.0

-

-

-

-

pgrouting

-

-

-

3.1.0

3.1.0

3.1.4

3.3.1

3.5.0

3.6.1

pgrowlocks

1.1

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

pg_sql_history

For details, see •pg_sql_history.

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

pgsql-ogr-fdw

-

-

-

1.1.3

1.1.3

1.1.3

-

1.1.3

1.1.4

pgstattuple

1.3

1.4

1.5

1.5

1.5

1.5

1.5

1.5

1.5

pgvector

-

-

-

-

0.6.1

0.6.1

0.6.1

0.6.1

0.6.1

plpgsql

For details, see plpgsql.

1.0

1.0

1.0

1.0

1.0

1.0

1

1.0

1

plperl

-

-

-

1.0

1.0

1.0

1.0

1.0

1

plprofiler

-

-

-

-

4.2.4

4.2.4

4.2.4

4.2.4

4.2.4

plproxy

-

-

-

2.11.0

2.11.0

2.11.0

2.11.0

2.11.0

2.11.0

plv8

-

-

-

2.3.15

2.3.15

2.3.15

-

-

-

postgis

For details, see postgis.

2.5.1

2.5.1

2.5.1

2.5.1

3.0.0

3.1.0

3.2.6

3.4.1

3.4.1

postgis_raster

Integrated to postgis

Integrated to postgis

Integrated to postgis

Integrated to postgis

3.0.0

3.1.0

3.2.6

3.4.1

3.4.1

postgis_sfcgal

2.5.1

2.5.1

2.5.1

2.5.1

3.0.0

3.1.0

3.2.6

3.4.1

3.4.1

postgis_tiger_geocoder

2.5.1

2.5.1

2.5.1

2.5.1

3.0.0

3.1.0

3.2.6

3.4.1

3.4.1

postgis_topology

2.5.1

2.5.1

2.5.1

2.5.1

3.0.0

3.1.0

3.2.6

3.4.1

3.4.1

postgres_fdw

1.0

1.0

1.0

1.0

1.0

1.0

1.1

1.1

1.1

postgres-decoderbufs

-

-

-

1.7.0

1.7.0

1.7.0

1.7.0

-

-

postgresql_anonymizer

-

-

-

0.7.1

0.7.1

0.7.1

1.1.0

1.1.0

1.1.0

q3c

-

-

-

2.0.1

2.0.1

2.0.1

2.0.1

2.0.1

2.0.1

rum

-

-

-

1.3.13

1.3.13

1.3.13

1.3.13

1.3.13

1.3.13

seg

-

-

-

-

1.3

1.3

1.4

1.4

1.4

sslinfo

-

-

-

1.2

1.2

1.2

1.2

1.2

1.2

tablefunc

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1

tcn

-

-

-

-

1

1

1

1

1

tds_fdw

-

-

2.0.3

2.0.3

2.0.3

2.0.3

2.0.3

2.0.3

2.0.3

test_decoding

2

2

2

2

2

2

2

2

2

TimescaleDB

For details, see TimescaleDB.

0

1.3.2

1.3.2

1.3.2

1.7.0

2.1.0

2.7.0

2.11.1

2.14.2

tsm_system_rows

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1

tsm_system_time

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1

unaccent

1.0

1.1

1.1

1.1

1.1

1.1

1.1

1.1

1.1

uuid-ossp

1.0

1.1

1.1

1.1

1.1

1.1

1.1

1.1

1.1

wal2json

For details, see wal2json.

-

-

-

2.5

2.5

2.5

2.5

2.5

2.5

xml2

-

-

-

1.1

1.1

1.1

1.1

1.1

1.1

zhparser

2.2

2.2

2.2

2.2

2.2

2.2

2.2

2.2

2.2

pg_stat_monitor

-

-

-

-

2.0.4

2.0.4

2.0.4

2.0.4

2.0.4

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 TimescaleDB Apache 2 and TimescaleDB Community Edition.

  • wal2json

    This extension is a logical replication extension. You can directly use it without installing it through control_extension.

    This extension cannot be queried from the pg_available_extensions view. You can run the following statement to check whether wal2json is supported. If no error is reported, wal2json is supported.

    select pg_create_logical_replication_slot('tst_wal2json', 'wal2json');

    After the statement is executed successfully, delete the slot to prevent stacked WAL logs.

    select pg_drop_replication_slot('tst_wal2json');

  • pg_profile_pro

    This extension is not supported temporarily due to its defects. It will be open to you after the defects are rectified. We are sorry for any inconvenience caused.

  • pg_sql_history

    This extension is used by Database Security Service (DBSS) to audit SQL operations of RDS for PostgreSQL instances. The SQL statements queried by this extension can be truncated because the space allocated to each record is fixed at 4 KB, which covers not only the SQL statement, but also information such as the database name, username, and SQL type.

Parent Topic: Extension Management