Help Center/ Relational Database Service/ User Guide (Ankara Region)/ Working with RDS for PostgreSQL/ Plugin Management/ Supported Plugins
Updated on 2024-04-11 GMT+08:00
View PDF
Share

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.

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.

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

Pgaudit

-

-

-

-

1.6.2

1.6.2

1.6.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

pgl_ddl_deploy

-

-

-

-

2.1.0

2.1.0

2.1.0

pglogical

-

-

-

2.4.1

2.4.1

2.4.1

2.4.1

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

pgvector

-

-

-

-

0.4.1

0.4.1

0.4.1

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

2.2

2.2

2.2

2.2

2.2

2.2

2.2

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

    • 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.

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
Parent topic: Plugin Management