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 Enhanced Edition (1.0) |
PostgreSQL 12 |
PostgreSQL 13 |
|---|---|---|---|---|---|---|---|
address_standardizer |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
3.0.0 |
3.1.0 |
address_standardizer_data_us |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
3.0.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.5 |
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.12 |
2.14 |
2.15.1 |
hstore |
1.3 |
1.4 |
1.4 |
1.5 |
1.5 |
1.6 |
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.2 |
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.1 |
1.2 |
oracle_fdw |
- |
- |
2.1.0 |
2.1.0 |
2.1.0 |
2.2.0 |
2.3.0 |
orafce |
3.8.0 |
3.8.0 |
3.8.0 |
3.8.0 |
0 |
3.8.0 |
3.14.0 |
pg_cron |
- |
- |
- |
- |
- |
1.2.0 |
1.3.0 |
pg_hint_plan |
1.1.5 |
1.2.0 |
1.3.0 |
1.3.5 |
1.3.5 |
1.3.7 |
1.3.7 |
pg_jieba |
1.1.0 |
1.1.0 |
1.1.0 |
1.1.0 |
1.1.0 |
1.1.0 |
2.0.1 |
pg_pathman |
1.5.8 |
1.5.8 |
1.5.8 |
1.5.8 |
1.5.8 |
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.0 |
3.1.3 |
pg_stat_statements |
1.3 |
1.4 |
1.6 |
1.6 |
1.6 |
1.7 |
1.8 |
pg_trgm |
1.1 |
1.3 |
1.3 |
1.4 |
1.4 |
1.4 |
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 |
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 |
2.5.1 |
3.0.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 |
Integrated to postgis |
3.0.0 |
3.1.0 |
postgis_sfcgal |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
3.0.0 |
3.1.0 |
postgis_tiger_geocoder |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
3.0.0 |
3.1.0 |
postgis_topology |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
3.0.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.1 |
2.0.2 |
timescaledb For details, see timescaledb. |
- |
1.3.2 |
1.3.2 |
1.3.2 |
1.3.2 |
1.7.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_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.
- For PostgreSQL Enhanced Edition DB instances, you need to set empty_is_null to OFF on the console before creating the postgis plugin.
- When postgis is created, the following plugins are created at the same time:
- 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