Updated on 2022-12-08 GMT+08:00

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.

Table 1 Supported plugins

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

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

    Only PostgreSQL 10, 11, and 12 are supported.

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