Supported Plugins¶
Note
The following table lists the plugins supported by the latest minor versions of RDS for PostgreSQL. You can use SELECT name FROM pg_available_extensions; to view the plugins supported by your DB instance.
Before using the mysql_fdw, oracle_fdw, pgsql-ogr-fdw, postgres_fdw, and tds_fdw plugins, ensure that the server IP addresses of the two PostgreSQL DB instances are in the same VPC and subnet.
Plugin Name | PostgreSQL 9.5 | PostgreSQL 9.6 | PostgreSQL 10 | PostgreSQL 11 | PostgreSQL 12 | PostgreSQL 13 | PostgreSQL 14 |
|---|---|---|---|---|---|---|---|
address_standardizer | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 | 3.1.0 | 3.1.0 |
address_standardizer_data_us | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 | 3.1.0 | 3.1.0 |
btree_gin | 1.0 | 1.0 | 1.2 | 1.3 | 1.3 | 1.3 | 1.3 |
btree_gist | 1.1 | 1.2 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
citext | 1.1 | 1.3 | 1.4 | 1.5 | 1.6 | 1.6 | 1.6 |
cube For details, see cube. | 1.0 | 1.2 | 1.2 | 1.4 | 1.4 | 1.4 | 1.4 |
dblink | 1.1 | 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 |
dict_xsyn | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
earthdistance For details, see earthdistance. | 1.0 | 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 |
hll | 2.12 | 2.12 | 2.12 | 2.12 | 2.14 | 2.15.1 | 2.15.1 |
hstore | 1.3 | 1.4 | 1.4 | 1.5 | 1.6 | 1.7 | 1.7 |
intagg | 1.0 | 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.3 |
isn | 1.0 | 1.1 | 1.1 | 1.2 | 1.2 | 1.2 | 1.2 |
ltree | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 | 1.2 | 1.2 |
oracle_fdw |
|
| 2.1.0 | 2.1.0 | 2.2.0 | 2.3.0 | 2.3.0 |
orafce | 3.8.0 | 3.8.0 | 3.8.0 | 3.8.0 | 3.8.0 | 3.14.0 | 3.14.0 |
pg_cron |
|
|
|
| 1.2.0 | 1.3.0 | 1.3.0 |
pg_hint_plan | 1.1.5 | 1.2.0 | 1.3.0 | 1.3.5 | 1.3.7 | 1.3.7 | 1.3.7 |
pg_jieba | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 2.0.1 | 2.0.1 |
pg_pathman | 1.5.8 | 1.5.8 | 1.5.8 | 1.5.8 | 1.5.12 | 1.5.12 | 1.5.12 |
pg_repack | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 |
pgrouting |
|
|
| 3.1.0 | 3.1.0 | 3.1.3 | 3.1.3 |
pg_stat_statements | 1.3 | 1.4 | 1.6 | 1.6 | 1.7 | 1.8 | 1.8 |
pg_trgm | 1.1 | 1.3 | 1.3 | 1.4 | 1.4 | 1.5 | 1.5 |
pgcrypto | 1.2 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pgstattuple |
|
| 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
pgvector |
|
|
|
| 0.4.1 | 0.4.1 | 0.4.1 |
plpgsql | 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.0 | 3.1.0 |
postgres_fdw |
|
| 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
postgis_raster | Integrated to postgis | Integrated to postgis | Integrated to postgis | Integrated to postgis | 3.0.0 | 3.1.0 | 3.1.0 |
postgis_sfcgal | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 | 3.1.0 | 3.1.0 |
postgis_tiger_geocoder | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 | 3.1.0 | 3.1.0 |
postgis_topology | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 | 3.1.0 | 3.1.0 |
tablefunc | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
tds_fdw |
|
|
| 2.0.1 | 2.0.1 | 2.0.2 | 2.0.2 |
timescaledb For details, see timescaledb. |
| 1.3.2 | 1.3.2 | 1.3.2 | 1.7.0 | 2.1.0 | 2.1.0 |
unaccent | 1.0 | 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 |
wal2json |
|
|
| 2.3 | 2.3 | 2.3 | 2.3 |
zhparser | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
Plugin Description¶
postgis
When postgis is created, the following plugins are created at the same time:
postgis
postgis_topology
fuzzystrmatch
postgis_tiger_geocoder
address_standardizer
address_standardizer_data_us
After the postgis plugin is created on the primary DB instance, you need to disconnect the connection from the standby DB instance first and re-establish a connection to update the search_path setting.
earthdistance
To install the earthdistance plugin, you must install the cube plugin first.
cube
If the earthdistance plugin has been installed, deleting the cube plugin will cause the earthdistance plugin to be unavailable.
timescaledb
The timescaledb plugin does not support the TSL protocol. For more information, see APIs Not Supported by the timescaledb Plugin.
wal2json
This plugin is a logical replication plugin. You can directly use it without installing it through control_extension.
APIs Not Supported by the timescaledb Plugin¶
add_compress_chunks_policy
add_drop_chunks_policy
add_reorder_policy
alter_job_schedule
compress_chunk
decompress_chunk
drop_chunks
interpolate
locf
move_chunk
remove_compress_chunks_policy
remove_drop_chunks_policy
remove_reorder_policy
reorder_chunk
set_integer_now_func
time_bucket_gapfill