Extension versions for Amazon Aurora PostgreSQL
Following, you can find version information for each extension supported by currently available Amazon Aurora PostgreSQL releases.
Topics
- Extensions supported for Aurora PostgreSQL 15
- Extensions supported for Aurora PostgreSQL 14
- Extensions supported for Aurora PostgreSQL 13
- Extensions supported for Aurora PostgreSQL 12
- Extensions supported for Aurora PostgreSQL 11
- Extensions supported for Aurora PostgreSQL 10
- Extensions supported for Aurora PostgreSQL 9.6
- Aurora PostgreSQL apg_plan_mgmt extension versions
To upgrade an extension in your Aurora PostgreSQL DB cluster, see Upgrading PostgreSQL extensions in the Amazon Aurora User Guide.
For information about installing extensions, see Working with extensions and foreign data wrappers in the Amazon Aurora User Guide.
Extensions supported for Aurora PostgreSQL 15
The following table shows the PostgreSQL extension versions that are currently
supported on Aurora PostgreSQL 15 versions. "NA" indicates that the extension isn't
available for that PostgreSQL version. For more information about PostgreSQL
extensions, see Packaging
Related Objects into an Extension
Extension | 15.2 |
---|---|
address_standardizer |
3.3.2 |
address_standardizer_data_us |
3.3.2 |
1.3 | |
2.4 | |
aurora_stat_utils | 1.0 |
auto_explain | Yes |
1.0 | |
aws_commons | 1.2 |
aws_lambda | 1.0 |
1.0 | |
1.1 | |
bloom |
1.0 |
bool_plperl | 1.3 |
btree_gin |
1.3 |
btree_gist |
1.6 |
citext |
1.6 |
cube |
1.5 |
dblink |
1.2 |
dict_int |
1.0 |
dict_xsyn |
1.0 |
earthdistance |
1.1 |
fuzzystrmatch |
1.1 |
hll | 2.17 |
hstore |
1.8 |
hstore_plperl |
1.0 |
ICU module | 60.2 |
1.0 | |
intagg |
1.1 |
intarray |
1.5 |
ip4r |
2.4 |
isn |
1.2 |
jsonb_plperl | 1.0 |
lo |
1.1 |
log_fdw | 1.3 |
ltree |
1.2 |
1.0 | |
oracle_fdw | 2.5.0 |
orafce |
4.0.0 |
pg_bigm |
1.2 |
pg_buffercache |
1.3 |
pg_cron | 1.4.2 |
pg_freespacemap |
1.2 |
pg_hint_plan |
1.5.0 |
pg_partman | 4.6.0 |
pg_prewarm |
1.2 |
pg_proctab | 0.0.9 |
pg_repack |
1.4.8 |
pg_similarity | 1.0 |
pg_stat_statements |
1.10 |
pg_trgm |
1.6 |
pg_visibility |
1.2 |
pgAudit |
1.7.0 |
pgcrypto |
1.3 |
pglogical |
2.4.2 |
pglogical_origin |
1.0.0 |
pgrouting |
3.4.1 |
pgrowlocks |
1.2 |
pgstattuple |
1.5 |
pgtap |
1.2.0 |
plcoffee | 3.1.4 |
plls | 3.1.4 |
plperl |
1.0 |
plpgsql |
1.0 |
plprofiler |
4.1 |
pltcl |
1.0 |
plv8 |
3.1.4 |
PostGIS | 3.3.2 |
postgis_raster | 3.3.2 |
postgis_tiger_geocoder |
3.3.2 |
postgis_topology |
3.3.2 |
postgres_fdw |
1.1 |
prefix |
1.2.0 |
rdkit |
4.2 |
rds_activity_stream | 1.6 |
rds_tools | 1.0 |
1.0 | |
SEG |
1.0 |
sslinfo |
1.2 |
tablefunc |
1.0 |
TCN |
1.0 |
tds_fdw | 2.0.3 |
test_parser |
1.0 |
tsm_system_rows |
1.0 |
tsm_system_time |
1.0 |
unaccent |
1.1 |
uuid-ossp |
1.1 |
wal2json |
2.5 |
Extensions supported for Aurora PostgreSQL 14
The following table shows the PostgreSQL extension versions that are currently
supported on Aurora PostgreSQL 14 versions. "NA" indicates that the extension isn't
available for that PostgreSQL version. For more information about PostgreSQL
extensions, see Packaging
Related Objects into an Extension
Extension | 14.7 | 14.6 | 14.5 | 14.4 | 14.3 |
---|---|---|---|---|---|
address_standardizer |
3.3.2 | 3.2.3 | 3.2.3 | 3.2.3 | 3.1.7 |
address_standardizer_data_us |
3.3.2 | 3.2.3 | 3.2.3 | 3.2.3 | 3.1.7 |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | |
2.4 | 2.4 | 2.3 | 2.2 | 2.2 | |
aurora_stat_utils | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
auto_explain | Yes | Yes | Yes | Yes | Yes |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | |
aws_commons | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
aws_lambda | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | |
bloom |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
bool_plperl | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
btree_gin |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
btree_gist |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 |
citext |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 |
cube |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
dblink |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
dict_int |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
dict_xsyn |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
earthdistance |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
fuzzystrmatch |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
hll | 2.17 | 2.16 | 2.16 | 2.16 | 2.16 |
hstore |
1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
hstore_plperl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
ICU module | 60.2 | 60.2 | 60.2 | 60.2 | 60.2 |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | |
intagg |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
intarray |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
ip4r |
2.4 | 2.4 | 2.4 | 2.4 | 2.4 |
isn |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
jsonb_plperl | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
lo |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
log_fdw | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
ltree |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | |
oracle_fdw | 2.5.0 | 2.4.0 | 2.4.0 | 2.4.0 | 2.4.0 |
orafce |
4.0.0 | 3.16 | 3.16 | 3.16 | 3.16 |
pg_bigm |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pg_buffercache |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pg_cron | 1.4.2 | 1.4 | 1.4 | 1.4 | 1.4 |
pg_freespacemap |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pg_hint_plan |
1.4.1 | 1.4 | 1.4 | 1.4 | 1.4 |
pg_partman | 4.6.0 | 4.6.0 | 4.6.0 | 4.6.0 | 4.6.0 |
pg_prewarm |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pg_proctab | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 |
pg_repack |
1.4.7 | 1.4.7 | 1.4.7 | 1.4.7 | 1.4.7 |
pg_similarity | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
pg_stat_statements |
1.9 | 1.9 | 1.9 | 1.9 | 1.9 |
pg_tle | 1.0.1 | 1.0.1 | N/A | N/A | |
pg_trgm |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 |
pg_visibility |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pgAudit |
1.7.0 | 1.6.1 | 1.6.1 | 1.6.1 | 1.6.1 |
pgcrypto |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pglogical |
2.4.2 | 2.4.1 | 2.4.1 | 2.4.1 | 2.4.1 |
pglogical_origin |
1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 |
pgrouting |
3.4.1 | 3.2.0 | 3.2.0 | 3.2.0 | 3.2.0 |
pgrowlocks |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pgstattuple |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
pgtap |
1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 |
plcoffee | 3.1.4 | 2.3.15 | 2.3.15 | 2.3.15 | 2.3.15 |
plls | 3.1.4 | 2.3.15 | 2.3.15 | 2.3.15 | 2.3.15 |
plperl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plpgsql |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plprofiler |
4.1 | 4.1 | 4.1 | 4.1 | 4.1 |
pltcl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plv8 |
3.1.4 | 3.0.0 | 3.0.0 | 3.0.0 | 2.3.15 |
PostGIS | 3.3.2 | 3.2.3 | 3.2.3 | 3.2.3 | 3.1.7 |
postgis_raster | 3.3.2 | 3.2.3 | 3.2.3 | 3.2.3 | 3.1.7 |
postgis_tiger_geocoder |
3.3.2 | 3.2.3 | 3.2.3 | 3.2.3 | 3.1.7 |
postgis_topology |
3.3.2 | 3.2.3 | 3.2.3 | 3.2.3 | 3.1.7 |
postgres_fdw |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
prefix |
1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 |
rdkit |
4.2 | 4.2 | 3.8 | 3.8 | 3.8 |
rds_activity_stream | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
rds_tools | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | |
SEG |
1.0 | NA | NA | NA | NA |
sslinfo |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
tablefunc |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
TCN |
1.0 | NA | NA | NA | NA |
tds_fdw | 2.0.2 | 2.0.2 | 2.0.2 | 2.0.2 | 2.0.2 |
test_parser |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
tsm_system_rows |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
tsm_system_time |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
unaccent |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
uuid-ossp |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
wal2json |
2.5 | 2.4 | 2.4 | 2.4 | 2.4 |
Extensions supported for Aurora PostgreSQL 13
The following table shows the PostgreSQL extension versions that are currently
supported on Aurora PostgreSQL 13 versions. "NA" indicates that the extension isn't
available for that PostgreSQL version. For more information about PostgreSQL
extensions, see Packaging
Related Objects into an Extension
Extension | 13.10 | 13.9 | 13.8 | 13.7 | 13.6 | 13.5 | 13.4 | 13.3 |
---|---|---|---|---|---|---|---|---|
address_standardizer |
3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1.7 | 3.0.3 |
address_standardizer_data_us |
3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1.7 | 3.0.3 |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | |
2.4 | 2.4 | 2.3 | 2.2 | 2.2 | 2.2 | 2.2 | 2.1 | |
aurora_stat_utils | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | N/A | |
auto_explain |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
aws_commons | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
aws_lambda | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | |
bloom |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
bool_plperl | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
btree_gin |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
btree_gist |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
citext |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 |
cube |
1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
dblink |
1.2 | 1.2 | 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 | 1.0 |
dict_xsyn |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
earthdistance |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
fuzzystrmatch |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
hll | 2.17 | 2.15 | 2.15 | 2.15 | 2.15 | 2.15 | 2.15 | 2.15 |
hstore |
1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 |
hstore_plperl |
1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.0 | 1.0 | 1.0 |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | N/A | |
intagg |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
intarray |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
ip4r |
2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 |
isn |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
jsonb_plperl | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
lo |
1.1 | 1.1 | 1.1 | 1.1 | NA | NA | NA | NA |
log_fdw | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
ltree |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | N/A | |
oracle_fdw | 2.5.0 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.0 |
orafce |
4.0.0 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 |
pg_bigm |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pg_buffercache |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pg_cron | 1.4.2 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.3 | 1.3 |
pg_freespacemap |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pg_hint_plan |
1.3.8 | 1.3.7 | 1.3.7 | 1.3.7 | 1.3.7 | 1.3.7 | 1.3.7 | 1.3.7 |
pg_partman | 4.5.1 | 4.5.1 | 4.5.1 | 4.5.1 | 4.5.1 | 4.5.1 | 4.5.1 | 4.5.1 |
pg_prewarm |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pg_proctab | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 |
pg_repack |
1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 | 1.4.6 |
pg_similarity | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
pg_stat_statements |
1.8 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
pg_trgm |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
pg_visibility |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pgAudit |
1.5.1 | 1.5.1 | 1.5.1 | 1.5.1 | 1.5.1 | 1.5 | 1.5 | 1.5 |
pgcrypto |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pglogical |
2.4.2 | 2.4.1 | 2.4.1 | 2.4.1 | 2.4.0 | 2.4.0 | 2.4.0 | 2.3.3 |
pglogical_origin |
1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 |
pgrouting |
3.4.1 | 3.1.3 | 3.1.3 | 3.1.3 | 3.1.3 | 3.1.3 | 3.1.0 | 3.1.0 |
pgrowlocks |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pgstattuple |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
pgtap |
1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 |
plcoffee | 3.1.4 | 3.0.0 | 3.0.0 | 2.3.15 | 2.3.15 | 2.3.15 | 2.3.15 | 2.3.15 |
plls | 3.1.4 | 3.0.0 | 3.0.0 | 2.3.15 | 2.3.15 | 2.3.15 | 2.3.15 | 2.3.15 |
plperl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plpgsql |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plprofiler |
4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 |
pltcl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plv8 |
3.1.4 | 3.0.0 | 3.0.0 | 2.3.15 | 2.3.15 | 2.3.15 | 2.3.15 | 2.3.15 |
PostGIS | 3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1.7 | 3.0.3 |
postgis_raster | 3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1.7 | 3.0.3 |
postgis_tiger_geocoder |
3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1.7 | 3.0.3 |
postgis_topology |
3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1.7 | 3.0.3 |
postgres_fdw |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
prefix |
1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 |
rdkit |
4.2 | 4.2 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 |
rds_activity_stream | 1.4 | 1.4 | 1.4 | 1.4 | 1.3 | 1.3 | 1.3 | 1.3 |
rds_tools | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | N/A | |
SEG |
1.0 | NA | NA | NA | NA | NA | NA | NA |
sslinfo |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
tablefunc |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
TCN |
1.0 | NA | NA | NA | NA | NA | NA | NA |
tds_fdw | 2.0.2 | 2.0.2 | 2.0.2 | 2.0.2 | 2.0.2 | N/A | N/A | N/A |
test_parser |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
tsm_system_rows |
1.0 | 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 | 1.0 |
unaccent |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
uuid-ossp |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
wal2json |
2.5 | 2.4 | 2.4 | 2.4 | 2.3 | 2.3 | 2.3 | 2.3 |
Extensions supported for Aurora PostgreSQL 12
The following table shows the PostgreSQL extension versions that are currently
supported on Aurora PostgreSQL 12 versions. "NA" indicates that the extension isn't
available for that PostgreSQL version. For more information about PostgreSQL
extensions, see Packaging
Related Objects into an Extension
Extension | 12.14 | 12.13 | 12.12 | 12.11 | 12.10 | 12.9 | 12.8 | 12.7 | 12.6 | 12.4 |
---|---|---|---|---|---|---|---|---|---|---|
address_standardizer |
3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 3.0.2 | 3.0.2 | 3.0.2 |
address_standardizer_data_us |
3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 3.0.2 | 3.0.2 | 3.0.2 |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | |
2.4 | 2.4 | 2.3 | 2.2 | 2.2 | 2.2 | 2.2 | 2.0 | 2.0 | 2.0 | |
aurora_stat_utils | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
auto_explain | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
aws_commons | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
aws_lambda | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | |
bloom |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
btree_gin |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
btree_gist |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
citext |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 |
cube |
1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
dblink |
1.2 | 1.2 | 1.2 | 1.2 | 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 | 1.0 | 1.0 | 1.0 |
dict_xsyn |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
earthdistance |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
fuzzystrmatch |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
hll | 2.17 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 |
hstore |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 |
hstore_plperl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
intagg |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
intarray |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
ip4r |
2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 |
isn |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
jsonb_plperl | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
lo |
1.1 | 1.1 | 1.1 | 1.1 | NA | NA | NA | NA | NA | NA |
log_fdw | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
ltree |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
oracle_fdw | 2.5.0 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.0 | NA | NA |
orafce |
4.0.0 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 | 3.8 | 3.8 |
pg_bigm |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | NA |
pg_buffercache |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pg_cron | 1.4.2 | 1.4 | 1.4 | 1.4 | 1.3.1 | 1.3.1 | 1.3.1 | 1.3.1 | 1.3 | NA |
pg_freespacemap |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pg_hint_plan |
1.3.8 | 1.3.7 | 1.3.7 | 1.3.7 | 1.3.7 | 1.3.5 | 1.3.5 | 1.3.5 | 1.3.5 | 1.3.5 |
pg_partman | 4.5.1 | 4.5.1 | 4.5.1 | 4.5.1 | 4.5.1 | 4.5.1 | 4.5.1 | 4.5.1 | 4.5.1 | NA |
pg_prewarm |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pg_proctab | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | NA |
pg_repack |
1.4.5 | 1.4.5 | 1.4.5 | 1.4.5 | 1.4.5 | 1.4.5 | 1.4.5 | 1.4.5 | 1.4.5 | 1.4.5 |
pg_similarity | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
pg_stat_statements |
1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 |
pg_trgm |
1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
pg_visibility |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pgAudit |
1.4.2 | 1.4.2 | 1.4.2 | 1.4.2 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
pgcrypto |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pglogical |
2.4.2 | 2.4.1 | 2.4.1 | 2.4.0 | 2.4.0 | 2.4.0 | 2.3.2 | 2.3.2 | 2.3.2 | 2.3.2 |
pglogical_origin |
1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 |
pgrouting |
3.4.1 | 3.0.3 | 3.0.3 | 3.0.3 | 3.0.3 | 3.0.3 | 3.0.3 | 3.0.3 | 3.0.3 | 3.0.3 |
pgrowlocks |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pgstattuple |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
pgTAP |
1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 |
plcoffee | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 |
plls | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 |
plperl |
1.2 | 1.2 | 1.2 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plpgsql |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plprofiler |
4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 |
pltcl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plv8 |
2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 |
PostGIS | 3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 3.0.2 | 3.0.2 | 3.0.3 |
postgis_raster | 3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 3.0.2 | 3.0.2 | 3.0.3 |
postgis_tiger_geocoder |
3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 3.0.2 | 3.0.2 | 3.0.3 |
postgis_topology |
3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 3.0.2 | 3.0.2 | 3.0.3 |
postgres_fdw |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
prefix |
1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 |
rdkit |
4.2 | 4.2 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 |
rds_activity_stream | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
SEG |
1.0 | NA | NA | NA | NA | NA | NA | NA | NA | NA |
sslinfo |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
tablefunc |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
TCN |
1.0 | NA | NA | NA | NA | NA | NA | NA | NA | NA |
test_parser |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
tsm_system_rows |
1.0 | 1.0 | 1.0 | 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 | 1.0 | 1.0 | 1.0 |
unaccent |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
uuid-ossp |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
wal2json |
2.5 | 2.4 | 2.4 | 2.4 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 |
Extensions supported for Aurora PostgreSQL 11
The following table shows PostgreSQL extension versions currently supported on
Aurora PostgreSQL 11 versions. "NA" indicates that the extension isn't available for
that PostgreSQL version. For more information about PostgreSQL extensions, see
Packaging
Related Objects into an Extension
Extension | 11.19 | 11.18 | 11.17 | 11.16 | 11.15 | 11.14 | 11.13 | 11.12 | 11.11 | 11.9 | 11.8 | 11.7 | 11.6 | 11.4 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
address_standardizer |
3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.1 |
address_standardizer_data_us |
3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.1 |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | |
apg_plan_mgmt | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 |
aurora_stat_utils | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
auto_explain | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
aws_commons | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.1 | 1.1 | 1.1 | 1.0 |
aws_lambda | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | NA | NA | NA | NA |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | NA | NA | NA | NA | |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.0 | |
bloom |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
btree_gin |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
btree_gist |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
citext |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
cube |
1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
dblink |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 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 | 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 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
earthdistance |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
fuzzystrmatch |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
hll | 2.17 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 |
hstore |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
hstore_plperl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
intagg |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
intarray |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
ip4r |
2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 |
isn |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
jsonb_plperl | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
lo |
1.1 | 1.1 | 1.1 | 1.1 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
log_fdw | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
ltree |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
orafce |
4.0.0 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 | 3.8 | 3.8 | 3.8 | 3.8 | 3.7 | 3.7 |
pg_bigm |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | NA | NA | NA | NA | NA |
pg_buffercache |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pg_freespacemap |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pg_hint_plan |
1.3.8 | 1.3.7 | 1.3.7 | 1.3.7 | 1.3.7 | 1.3.7 | 1.3.5 | 1.3.5 | 1.3.5 | 1.3.5 | 1.3.5 | 1.3.4 | 1.3.4 | 1.3.4 |
pg_prewarm |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pg_proctab | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | 0.0.9 | NA | NA | NA | NA | NA |
pg_repack |
1.4.4 | 1.4.4 | 1.4.4 | 1.4.4 | 1.4.4 | 1.4.4 | 1.4.4 | 1.4.4 | 1.4.4 | 1.4.4 | 1.4.4 | 1.4.4 | 1.4.4 | 1.4.4 |
pg_similarity | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
pg_stat_statements |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 |
pg_trgm |
1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
pg_visibility |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pgAudit |
1.3.3 | 1.3.3 | 1.3.3 | 1.3.3 | 1.3.3 | 1.3.1 | 1.3.1 | 1.3.1 | 1.3.1 | 1.3.1 | 1.3 | 1.3 | 1.3 | 1.3 |
pgcrypto |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pglogical |
2.4.2 | 2.4.1 | 2.4.1 | 2.4.1 | 2.4.0 | 2.4.0 | 2.4.0 | 2.2.2 | 2.2.2 | 2.2.2 | 2.2.2 | NA | NA | NA |
pglogical_origin |
1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | NA | NA | NA |
pgrouting |
3.4.1 | 2.6.3 | 2.6.3 | 2.6.3 | 2.6.3 | 2.6.3 | 2.6.3 | 2.6.1 | 2.6.1 | 2.6.1 | 2.6.1 | 2.6.1 | 2.6.1 | 2.6.1 |
pgrowlocks |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pgstattuple |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
pgTAP |
1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.0.0 | 1.0.0 |
plcoffee | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.8 | 2.3.8 | 2.3.8 |
plls | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.8 | 2.3.8 | 2.3.8 |
plperl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plpgsql |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plprofiler |
4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | NA |
pltcl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plv8 |
2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 |
PostGIS | 3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.1 |
postgis_tiger_geocoder |
3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.1 |
postgis_topology |
3.3.2 | 3.2.3 | 3.2.3 | 3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.1 |
postgres_fdw |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
prefix |
1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 |
rdkit |
4.2 | 4.2 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | NA | NA | NA |
rds_activity_stream | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
SEG |
1.0 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
sslinfo |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
tablefunc |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
TCN |
1.0 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
test_parser |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
tsm_system_rows |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 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 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
unaccent |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
uuid-ossp |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
wal2json |
2.5 | 2.4 | 2.4 | 2.4 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 |
Extensions supported for Aurora PostgreSQL 10
The following table shows PostgreSQL extension versions currently supported on
Aurora PostgreSQL 10 versions. "NA" indicates that the extension isn't available
for that PostgreSQL version. For more information about PostgreSQL extensions, see
Packaging
Related Objects into an Extension
Note
-
The
adminpack
extension is no longer supported because it accesses the file system. -
The
plperlu
extension is no longer supported because it is an untrusted language extension. -
The
pltclu
extension is no longer supported because it is an untrusted language extension.
Extension | 10.21 | 10.20 | 10.19 | 10.18 | 10.17 | 10.16 | 10.14 | 10.13 | 10.12 | 10.11 | 10.7 | 10.6 | 10.5 | 10.4 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
address_standardizer |
3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 2.4.7 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 |
address_standardizer_data_us |
3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 2.4.7 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 |
NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 1.1 | 1.1 | 1.1 | |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | |
apg_plan_mgmt | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 1.0.1 | 1.0.1 | 1.0.1 | 0.1 |
aurora_stat_utils |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
auto_explain |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
aws_commons |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.1 | 1.1 | 1.1 | 1.1 | 1.0 | 1.0 | NA | NA |
aws_ml | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | NA | NA | NA | NA | NA | NA | NA |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.0 | 1.0 | NA | NA | |
bloom |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
btree_gin |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
btree_gist |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
chkpass |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
citext |
1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
cube |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
dblink |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 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 | 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 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
earthdistance |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
fuzzystrmatch |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
hll | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 |
hstore |
1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
hstore_plperl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
hstore_plperlu | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
intagg |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
intarray |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
ip4r |
2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 |
isn |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
lo |
1.1 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
log_fdw | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
ltree |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
orafce |
3.16 | 3.16 | 3.16 | 3.16 | 3.16 | 3.8 | 3.8 | 3.8 | 3.8 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 |
pg_buffercache |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pg_freespacemap |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pg_hint_plan |
1.3.6 | 1.3.6 | 1.3.6 | 1.3.5 | 1.3.5 | 1.3.5 | 1.3.5 | 1.3.5 | 1.3.3 | 1.3.3 | 1.3.1 | 1.3.1 | 1.3.1 | 1.3.0 |
pg_prewarm |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
pg_repack |
1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 |
pg_similarity | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | NA |
pg_stat_statements |
1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.5 | 1.5 |
pg_trgm |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pg_visibility |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pgAudit |
1.2.3 | 1.2.3 | 1.2.1 | 1.2.1 | 1.2.1 | 1.2.1 | 1.2.1 | 1.2.1 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pgcrypto |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pglogical |
2.4.1 | 2.4.0 | 2.4.0 | 2.4.0 | 2.2.2 | 2.2.2 | 2.2.2 | 2.2.2 | NA | NA | NA | NA | NA | NA |
pglogical_origin | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | NA | NA | NA | NA | NA | NA |
pgrouting |
2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 | 2.5.2 |
pgrowlocks |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pgstattuple |
1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
plcoffee | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 |
plls | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 |
plperl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plperlu | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 1.0 | 1.0 | 1.0 |
plpgsql |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plprofiler |
4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | NA | NA | NA | NA |
pltcl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
pltclu | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 1.0 | 1.0 | 1.0 |
plv8 |
2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 |
PostGIS | 3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 2.4.7 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 |
postgis_tiger_geocoder |
3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 2.4.7 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 |
postgis_topology |
3.1.7 | 3.1.7 | 3.1.7 | 3.1 | 2.4.7 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 | 2.4.4 |
postgres_fdw |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
prefix |
1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 |
rdkit |
3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 | NA | NA | NA | NA | NA | NA |
rds_activity_stream | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | NA |
sslinfo |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
tablefunc |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
test_parser |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
tsearch2 |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
tsm_system_rows |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 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 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
unaccent |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
uuid-ossp |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
wal2json |
2.4 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.1 | 2.1 | NA | NA | NA |
Extensions supported for Aurora PostgreSQL 9.6
The following table shows PostgreSQL extension versions supported on
Aurora PostgreSQL 9.6 versions. "NA" indicates that the extension isn't available for
that PostgreSQL version. For more information about PostgreSQL extensions, see
Packaging
Related Objects into an Extension
Note
-
The
apgcc
RDS for PostgreSQL internal extension is no longer supported. -
The
apgunit
RDS for PostgreSQL internal extension is no longer supported. -
The
pageinspect
extension is no longer publicly supported by RDS for PostgreSQL. -
The
xml2
extension is no longer supported by PostgreSQL.
Extension | 9.6.22 | 9.6.21 | 9.6.19 | 9.6.18 | 9.6.17 | 9.6.16 | 9.6.12 | 9.6.11 | 9.6.0 | 9.6.8 | 9.6.6 | 9.6.3 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
address_standardizer |
2.3.9 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.4 | 2.3.4 | 2.3.4 |
address_standardizer_data_us |
2.3.9 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.4 | 2.3.4 | 2.3.4 |
apg_plan_mgmt | 1.0.1 | 1.0.1 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | NA | NA | NA | 0.1 |
apgcc | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 1.0 | 1.0 |
apgunit | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 1.0 | 1.0 |
aurora_stat_utils | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
auto_explain | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
bloom |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
btree_gin |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
btree_gist |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
chkpass |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
citext |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
cube |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
dblink |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 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 | 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 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
earthdistance |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
fuzzystrmatch |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
hll | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | 2.10 | NA |
hstore |
1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
hstore_plperl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
intagg |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
intarray |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
ip4r |
2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.0 | 2.0 | 2.0 |
isn |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
log_fdw | 1.0 | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
ltree |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
orafce |
3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 3.8 | 3.8 | 3.8 | 3.8 | 3.16 | NA |
pageinspect |
NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 1.5 | 1.5 |
pg_buffercache |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pg_cron | 1.3.1 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
pg_freespacemap |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
pg_hint_plan |
1.2.2 | 1.2.2 | 1.2.3 | 1.2.3 | 1.2.5 | 1.2.5 | 1.2.6 | 1.2.6 | 1.2.6 | 1.2.6 | 1.1.3 | 1.1.3 |
pg_prewarm |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
pg_repack |
1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.3 | 1.4.2 | 1.4.2 | 1.4.0 |
pg_similarity | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | NA | NA | NA | NA |
pg_stat_statements |
1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
pg_trgm |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pg_visibility |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
pgAudit |
1.1.1 | 1.1.1 | 1.1.1 | 1.1.1 | 1.1.1 | 1.1.1 | 1.1.2 | 1.1.2 | 1.1.2 | 1.0 | 1.0 | 1.0 |
pgcrypto |
1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
pgrouting |
2.4.2 | 2.4.2 | 2.4.2 | 2.4.2 | 2.4.2 | 2.4.2 | 2.4.2 | 2.4.2 | 2.4.2 | 2.4.2 | 2.4.2 | 2.4.2 |
pgrowlocks |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
pgstattuple |
1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
plcoffee | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.0 | 1.5.3 | 1.5.3 |
plls | 2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.0 | 1.5.3 | 1.5.3 |
plperl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plpgsql |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
pltcl |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
plv8 |
2.3.14 | 2.3.14 | 2.3.14 | 2.3.14 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.0 | 1.5.3 | 1.5.3 |
PostGIS |
2.3.9 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.4 | 2.3.4 | 2.3.4 |
postgis_tiger_geocoder |
2.3.9 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.4 | 2.3.4 | 2.3.4 |
postgis_topology |
2.3.9 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.7 | 2.3.4 | 2.3.4 | 2.3.4 |
postgres_fdw |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
prefix |
1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | 1.2.0 | NA |
sslinfo |
1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
tablefunc |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
test_parser |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
tsearch2 |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
tsm_system_rows |
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 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 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
unaccent |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
uuid-ossp |
1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
xml2 |
NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 1.1 | 1.1 |
Aurora PostgreSQL apg_plan_mgmt extension versions
The Amazon apg_plan_mgmt
extension provides your Aurora PostgreSQL DB cluster with
the query plan management feature. It allows you to manage the query execution
plans generated by the optimizer for your SQL applications for better stability and to
prevent regressions. For more information,
see
Managing query execution plans for Aurora PostgreSQL in the Amazon Aurora User Guide.
Topics
Version 2.4 of the Aurora PostgreSQL apg_plan_mgmt extension
Improvements to the apg_plan_mgmt
extension in version 2.4 include the
following:
New extension features
-
The
apg_plan_mgmt.copy_outline
function can take a new 5th argument,force_update_target_plan_hash
. If it is set to true, the target plan hash will be updated even though the source plan isn't reproducible for the target sql_hash.
Extension improvements
-
The apg_plan_mgmt.copy_outline function now copies environment_variables.
-
The minimum value of apg_plan_mgmt.plan_retention_period changes to 1 from 32.
-
The query plan management can now save plans for queries in read-only transactions from the writer nodes.
-
Fixed an issue in the apg_plan_mgmt.evolve_plan_baselines function.
-
Fixed an issue that could cause unavailability when the apg_plan_mgmt is enabled.
To learn how to install, upgrade, and use the apg_plan_mgmt
extension, see
Managing query execution plans for Aurora PostgreSQL in the Amazon Aurora User Guide.
Version 2.3 of the Aurora PostgreSQL apg_plan_mgmt extension
Improvements to the apg_plan_mgmt
extension in version 2.3 include the
following:
New extension features
Support for a new function, the
apg_plan_mgmt.copy_outline
function. This function allows you to copy a plan hash and a plan outline from one SQL hash and plan hash to another. Use this function when you want to copy a plan that uses hints to other similar statements without using the in-line hint statement at every occurrence. If the update to the query results in an invalid plan, the function raises an error and rolls back the update. For more information, see Function reference for Aurora PostgreSQL query plan management in the Amazon Aurora User Guide.
Extension improvements
-
The query plan management feature now saves plans for queries that are inside procedures and DO-blocks. For versions of
apg_plan_mgmt
older than version 2.3, this has been a limitation.
To learn how to install, upgrade, and use the apg_plan_mgmt
extension, see
Managing query execution plans for Aurora PostgreSQL in the Amazon Aurora User Guide.
Version 2.0 of the Aurora PostgreSQL apg_plan_mgmt extension
The apg_plan_mgmt
extension changes for version 2.0 include the
following:
New extension features
-
You can now manage all queries inside SQL functions, whether they have parameters or not.
-
You can now manage all queries inside PL/pgSQL functions, whether they have parameters or not.
-
You can now manage queries in generic plans, whether they have parameters or not. To learn more about generic plans versus custom plans, see the
PREPARE
statement in the PostgreSQL documentation. -
You can now use query plan management to enforce the use of specific types of aggregate methods in query plans.
Extension improvements
-
You can now save plans with a size up to 8KB times the setting of the
max_worker_processes
parameter. Previously the maximum plan size was 8KB. -
Fixed bugs for unnamed prepared statements such as those from JDBC.
-
Previously, when you tried to do
CREATE EXTENSION apg_plan_mgmt
when it is not loaded in theshared_preload_libraries
, the PostgreSQL backend connection was dropped. Now, an error message prints and the connection is not dropped. -
The default value of the
cardinality_error
in theapg_plan_mgmt.plans table
is NULL, but it can be set to -1 during theapg_plan_mgmt.evolve_plan_baselines
function. NULL is now used consistently. -
Plans are now saved for queries that refer to temporary tables.
-
The default maximum number of plans is increased from 1000 to 10000.
-
The following pgss parameters are deprecated because the automatic plan capture mode should be used instead of those parameters.
-
apg_plan_mgmt.pgss_min_calls
-
apg_plan_mgmt.pgss_min_mean_time_ms
-
apg_plan_mgmt.pgss_min_stddev_time_ms
-
apg_plan_mgmt.pgss_min_total_time_ms
-
Version 1.0.1 of the Aurora PostgreSQL apg_plan_mgmt extension
The apg_plan_mgmt
extension changes for version 1.0.1 include the
following:
New extension features
-
The
validate_plans
function has a newaction
value calledupdate_plan_hash
. This action updates theplan_hash
ID for plans that can't be reproduced exactly. Theupdate_plan_hash
value also allows you to fix a plan by rewriting the SQL. You can then register the good plan as anApproved
plan for the original SQL. Following is an example of using theupdate_plan_hash
action.UPDATE apg_plan_mgmt.plans SET plan_hash =
new _plan_hash
, plan_outline =good_plan_outline
WHERE sql_hash =bad_plan_sql_hash
AND plan_hash =bad_plan_plan_hash
; SELECT apg_plan_mgmt.validate_plans(bad_plan_sql_hash
,bad_plan_plan_hash
, 'update_plan_hash'); SELECT apg_plan_mgmt.reload(); -
A new
get_explain_stmt
function is available that generates the text of anEXPLAIN
statement for the specified SQL statement. It includes the parameterssql_hash
,plan_hash
andexplain_options
.The parameter
explain_options
can be any comma-separated list of validEXPLAIN
options, as shown following.analyze,verbose,buffers,hashes,format json
If the parameter
explain_options
is NULL or an empty string, theget_explain_stmt
function generates a simpleEXPLAIN
statement.To create an
EXPLAIN
script for your workload or a portion of it, use the\a
,\t
, and\o
options to redirect the output to a file. For example, you can create anEXPLAIN
script for the top-ranked (top-K) statements by using the PostgreSQLpg_stat_statements
view sorted bytotal_time
inDESC
order. -
The precise location of the Gather parallel query operator is determined by costing, and may change slightly over time. To prevent these differences from invalidating the entire plan, query plan management now computes the same
plan_hash
even if the Gather operators move to different places in the plan tree. -
Support is added for nonparameterized statements inside pl/pgsql functions.
-
Overhead is reduced when the
apg_plan_mgmt
extension is installed on multiple databases in the same cluster while two or more databases are being accessed concurrently. Also, this release fixed a bug in this area that caused plans to not be stored in shared memory.
Extension improvements
-
Improvements to the
evolve_plan_baselines
function.-
The
evolve_plan_baselines
function now computes acardinality_error
metric over all nodes in the plan. Using this metric, you can identify any plan where the cardinality estimation error is large, and the plan quality is more doubtful. Long-running statements with highcardinality_error
values are high-priority candidates for query tuning. -
Reports generated by
evolve_plan_baselines
now includesql_hash
,plan_hash
, and the planstatus
. -
You can now allow
evolve_plan_baselines
to approve previouslyRejected
plans. -
The meaning of
speedup_factor
forevolve_plan_baselines
is now always relative to the baseline plan. For example, a value of 1.1 now means 10 percent faster than the baseline plan. A value of 0.9 means 10 percent slower than the baseline plan. The comparison is made using running time alone instead of total time. -
The
evolve_plan_baselines
function now warms the cache in a new way. It does this by running the baseline plan, then running the baseline plan one more time, and then running the candidate plan once. Previously,evolve_plan_baselines
ran the candidate plan twice. This approach added significantly to running time, especially for slow candidate plans. However, running the candidate plan twice is more reliable when the candidate plan uses an index that isn't used in the baseline plan.
-
-
Query plan management no longer saves plans that refer to system tables or views, temporary tables, or the query plan management's own tables.
-
Bug fixes include caching a plan immediately when saved and fixing a bug that caused the back end to terminate.