The following table lists the extensions supported by the latest minor versions across RDS for PostgreSQL engine versions. You can use SELECT name FROM pg_available_extensions; to view the extensions supported by your DB instance.
The mysql_fdw, dblink, postgres_fdw, and tds_fdw extensions allow access across DB instances. Before using them, ensure that the server IP addresses of the two DB instances are in the same VPC and subnet.
Extension Name | PostgreSQL 9.5 | PostgreSQL 9.6 | PostgreSQL 10 | PostgreSQL 11 | PostgreSQL 12 | PostgreSQL 13 | PostgreSQL 14 | PostgreSQL 15 | PostgreSQL 16 | PostgreSQL 17 | PostgreSQL 18 |
|---|---|---|---|---|---|---|---|---|---|---|---|
address_standardize | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 | 3.1.0 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
address_standardizer_data_us | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 | 3.1.0 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
auth_delay | None | None | None | None | 1.0 | 1.0 | 2 | 2 | 2 | 2 | 2 |
btree_gin | 1.0 | 1.0 | 1.2 | 1.3 | 1.3 | 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 | 1.7 | 1.8 |
citext | 1.1 | 1.3 | 1.4 | 1.5 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.8 |
cube For details, see cube. | 1.0 | 1.2 | 1.2 | 1.4 | 1.4 | 1.4 | 1.5 | 1.5 | 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 | 1.2 | 1.2 |
dict_int | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1 | 1 | 1.0 |
dict_xsyn | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1 | 1 | 1.0 |
earthdistance For details, see earthdistance. | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.2 | 1.2 | 1.2 |
fuzzystrmatch | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.2 | 1.2 | 1.2 |
hll | 2.12 | 2.12 | 2.12 | 2.12 | 2.14 | 2.15.1 | 2.18 | 2.18 | 2.18 | 2.18 | 2.19 |
intagg | 1.0 | 1.1 | 1.1 | 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 | 1.5 | 1.5 |
isn | 1.0 | 1.1 | 1.1 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.3 |
ltree | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 | 1.2 | 1.2 | 1.2 | 1.2 | 1.3 | 1.3 |
oracle_fdw | None | None | 1.1 | 1.1 | 1.1 | 2.3.0 | 1.0.0 | 1.0.0 | 1.0.0 | None | None |
orafce | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.14.0 | 3.21.1 | 4.14 | 4.14 | 4.14 | 4.16.5 |
pgaudit | None | None | None | None | 1.6.2 | 1.6.2 | 1.6.2 | 1.7.0 | 16.0 | 17.0 | 18.0 |
pg_hint_plan | 1.1.5 | 1.2.0 | 1.3.0 | 1.3.0 | None | 1.3.7 | 1.4.3 | 1.5.2 | 1.6.1 | 1.7.0 | 1.8.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 | None | None | None |
pg_pathman | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5.12 | None | None | None | None | None |
pg_repack | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | 1.5.2 | 1.5.2 | 1.5.2 | 1.5.2 | 1.5.3 |
pgrouting | None | None | None | 3.1.0 | 3.1.0 | 3.1.4 | 3.3.1 | 3.5.0 | 3.6.1 | 3.7.1 | 4.0.1 |
pg_stat_statements | 1.3 | 1.4 | 1.6 | 1.6 | 1.7 | 1.8 | 1.9 | 1.10 | 1.1 | 1.11 | 1.12 |
pg_trgm | 1.1 | 1.3 | 1.3 | 1.4 | 1.4 | 1.5 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 |
pgcrypto | 1.2 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.4 |
pgstattuple | None | None | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
plpgsql For details, see plpgsql. | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
postgis For details, see postgis. | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 | 3.1.11 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
postgres_fdw | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 | 1.2 |
postgis_raster | Integrated to postgis | Integrated to postgis | Integrated to postgis | Integrated to postgis | 3.0.0 | 3.1.11 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
postgis_sfcgal | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 | 3.1.11 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
postgis_tiger_geocoder | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 | 3.1.11 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
postgis_topology | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 | 3.1.11 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
pg_qualstats | None | None | None | 2.1.0 | 2.1.0 | 2.1.1 | 2.1.1 | 2.1.1 | 2.1.1 | 2.1.1 | 2.1.3 |
pg_stat_kcache | None | None | None | 2.2.3 | 2.2.3 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.1 |
pg_track_settings | None | None | None | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | None | None |
pg_wait_sampling | None | None | None | 1.1.5 | 1.1.5 | 1.1.5 | 1.1.5 | 1.1.5 | 1.1.5 | 1.1.6 | 1.1.9 |
hypopg | None | None | None | 1.4.0 | 1.4.0 | 1.4.1 | 1.4.2 | 1.4.2 | 1.4.2 | 1.4.2 | 1.4.2 |
tablefunc | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
tds_fdw | None | None | 2.0.3 | 2.0.3 | 2.0.3 | 2.0.4 | 2.0.4 | 2.0.4 | 2.0.4 | 2.0.4 | 2.0.5 |
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 | 2.17.2 | 2.27.0 |
unaccent | 1.0 | 1.1 | 1.1 | 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 | 1.1 | 1.1 |
wal2json | None | None | None | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.6 |
zhparser | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.3 |
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 1.0 provides the SQL procedural language and is installed by default.
To install the earthdistance extension, you must install the cube extension first.
If the earthdistance extension has been installed, deleting the cube extension will cause the earthdistance extension to be unavailable.
The TimescaleDB extension of RDS for PostgreSQL supports only the features of the Apache protocol. It does not support the features of the TLS protocol. For details, see APIs Not Supported by TimescaleDB.
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.
select pg_create_logical_replication_slot('tst_wal2json', 'wal2json');
select pg_create_logical_replication_slot('tst_decoderbufs', 'decoderbufs');
After the execution, delete the slot to prevent WAL log accumulation.