Plugins Supported By RDS for PostgreSQL
The following table lists the plugins supported by the latest minor versions of RDS for PostgreSQL. If the current PostgreSQL version does not support a plug-in, contact customer service to upgrade the PostgreSQL minor version to the latest.
Plugin Name |
PostgreSQL 9.5 |
PostgreSQL 9.6 |
PostgreSQL 10 |
PostgreSQL 11 |
PostgreSQL Enhanced Edition |
PostgreSQL 12 |
---|---|---|---|---|---|---|
address_standardizer |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
3.0.0 |
address_standardizer_data_us |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
3.0.0 |
btree_gin |
1.0 |
1.0 |
1.2 |
1.3 |
1.3 |
1.3 |
btree_gist |
1.1 |
1.2 |
1.5 |
1.5 |
1.5 |
1.5 |
cube |
1.0 |
1.2 |
1.2 |
1.4 |
1.4 |
1.4 |
dict_int |
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 |
earthdistance |
1.0 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
fuzzystrmatch |
1.0 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
hll |
2.12 |
2.12 |
2.12 |
2.12 |
2.12 |
2.14 |
hstore |
1.3 |
1.4 |
1.4 |
1.5 |
1.5 |
1.6 |
intagg |
1.0 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
intarray |
1.0 |
1.2 |
1.2 |
1.2 |
1.2 |
1.2 |
ltree |
1.0 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
ora_migrator |
- |
- |
0.9.3 |
0.9.3 |
0.9.3 |
- |
pg_cron |
- |
- |
- |
- |
- |
1.2 |
pg_trgm |
1.1 |
1.3 |
1.3 |
1.4 |
1.4 |
1.4 |
pgcrypto |
1.2 |
1.3 |
1.3 |
1.3 |
1.3 |
1.3 |
pgstattuple |
- |
- |
1.5 |
1.5 |
1.5 |
1.5 |
plpgsql |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
postgis |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
3.0.0 |
postgres_fdw |
- |
- |
- |
1.0 |
1.0 |
1.0 |
postgis_raster |
Integrated to postgis |
Integrated to postgis |
Integrated to postgis |
Integrated to postgis |
Integrated to postgis |
- |
postgis_tiger_geocoder |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
3.0.0 |
postgis_topology |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
2.5.1 |
3.0.0 |
tablefunc |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
timescaledb |
- |
1.3.2 |
1.3.2 |
1.3.2 |
1.3.2 |
1.7.0 |
unaccent |
1.0 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
uuid-ossp |
1.0 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
zhparser |
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 mor information, see APIs Not Supported by the timescaledb Plugin.
- pgstattuple
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
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot