Supported Plugins

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. If any of the following plugins is not supported by your PostgreSQL version, migrate your data to an RDS for PostgreSQL instance of the latest version.

The plugins 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.

RDS for PostgreSQL 13 is available only for users with the open beta test (OBT) permission. You can contact customer service to apply for the permission.

**Table 1** Supported plugins
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.2.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.1
amcheck	-	-	-	1.1	1.2	1.2	1.3
auth_delay	-	-	-	-	2	2	2
auto_explain	2	2	2	2	2	2	2
bloom	-	-	-	1.0	1.0	1.0	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.6
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.5
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.16
hstore	1.3	1.4	1.4	1.5	1.6	1.7	1.8
hypopg	-	-	-	1.2.0	1.2.0	1.2.0	1.3.1
icu	-	-	-	1.0	1.0	1.0	1.0
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.5
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
mysql_fdw	-	-	-	2.5.5	2.5.5	2.5.5	2.8.0
old_snapshot	-	-	-	-	-	-	1.0
orafce	3.8.0	3.8.0	3.8.0	3.8.0	3.8.0	3.14.0	3.21.1
pageinspect	1.3	1.5	1.6	1.7	1.7	1.8	1.9
passwordcheck	2	2	2	2	2	2	2
pg_bigm	-	-	-	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
pg_cron	-	-	-	-	1.4.1	1.3.1	1.4.1
pg_freespacemap	1.0	1.1	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.7	1.3.7	1.4.0
pg_jieba	1.1.0	1.1.0	1.1.0	1.1.0	1.1.0	2.0.1	1.1.0
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
pg_qualstats	-	-	-	2.0.2	2.0.2	2.0.2	2.0.4
pg_repack	1.4.6	1.4.6	1.4.6	1.4.6	1.4.6	1.4.6	1.4.7
pg_roaringbitmap	-	-	-	0.5.2	0.5.2	0.5.2	0.5.4
pg_stat_kcache	-	-	-	2.2.0	2.2.0	2.2.0	2.2.1
pg_stat_statements	1.3	1.4	1.6	1.6	1.7	1.8	1.9
pg_surgery	-	-	-	-	-	-	1.0
pg_track_settings	-	-	-	2.0.1	2.0.1	2.0.1	2.0.1
pg_trgm	1.1	1.3	1.3	1.4	1.4	1.5	1.6
pg_visibility	-	-	-	1.2	1.2	1.2	1.2
pg_wait_sampling	-	-	-	1.1.3	1.1.3	1.1.3	1.1.3
pgcrypto	1.2	1.3	1.3	1.3	1.3	1.3	1.3
pglogical	-	-	-	2.3.3	2.3.3	2.3.3	2.4.1
pg_profile_pro For details, see pg_profile_pro.	-	-	-	-	1.0	-	-
pgrouting	-	-	-	3.1.0	3.1.0	3.1.3	3.3.1
pgrowlocks	1.1	1.2	1.2	1.2	1.2	1.2	1.2
pg_sql_history	1.1	1.1	1.1	1.1	1.1	1.1	1.1
pgsql-ogr-fdw	-	-	-	1.0.12	1.0.12	1.0.12	-
pgstattuple	1.3	1.4	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
plperl	-	-	-	1.0	1.0	1.0	1.0
plproxy	-	-	-	2.10.0	2.10.0	2.10.0	2.10.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.1
postgis_raster	Integrated to postgis	Integrated to postgis	Integrated to postgis	Integrated to postgis	3.0.0	3.1.0	3.2.1
postgis_sfcgal	2.5.1	2.5.1	2.5.1	2.5.1	3.0.0	3.1.0	3.2.1
postgis_tiger_geocoder	2.5.1	2.5.1	2.5.1	2.5.1	3.0.0	3.1.0	3.2.1
postgis_topology	2.5.1	2.5.1	2.5.1	2.5.1	3.0.0	3.1.0	3.2.1
postgres_fdw	1.0	1.0	1.0	1.0	1.0	1.0	1.1
postgres-decoderbufs	-	-	-	1.3.1	1.3.1	1.3.1	1.7.0
postgresql_anonymizer	-	-	-	0.7.1	0.7.1	0.7.1	1.0.0
q3c	-	-	-	2.0.0	2.0.0	2.0.0	2.0.0
rum	-	-	-	1.3.7	1.3.7	1.3.7	1.3.9
sslinfo	-	-	-	1.2	1.2	1.2	1.2
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	2.0.2
test_decoding	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
tsm_system_rows	1.0	1.0	1.0	1.0	1.0	1.0	1.0
tsm_system_time	1.0	1.0	1.0	1.0	1.0	1.0	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 For details, see wal2json.	-	-	-	2.3	2.3	2.3	2.4
xml2	-	-	-	1.1	1.1	1.1	1.1
zhparser	0.2.0	0.2.0	0.2.0	0.2.0	0.2.0	0.2.0	0.2.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
- If the version of postgis to be created is 3.0.0 or later, postgis_raster will be created along with 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 plugins, 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 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.
pg_profile_pro
This plugin 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.