To standardize extension management and improve security for RDS for PostgreSQL extensions, RDS is optimizing extensions with security risks across minor engine version iterations. Because of this, some extensions cannot be created on certain minor engine versions. This topic describes the restricted extensions for different minor engine versions. After the vulnerable extensions are optimized, upgrade to the latest minor engine version to use them. Existing extensions are not affected.
List of restricted extensions
PostgreSQL 18
Minor engine version | Disabled extensions |
20251130 and earlier | plperl, plv8 |
20251130 and later | plv8 |
PostgreSQL 17
minor engine version | Disabled extensions |
20241030 and earlier | plperl, plv8 |
20241230 and later | plv8 |
PostgreSQL 16
Minor Engine Version | Disabled extensions |
20231030 to 20241030 | ganos_raster, ganos_scene, ganos_sfmesh, ganos_trajectory, ganos_utility, pg_cron, plperl, plv8 |
20241230 to 20250228 | pg_cron |
20250430 and later | ganos_raster, ganos_scene, ganos_sfmesh, ganos_trajectory, ganos_utility, orafce, plv8 |
PostgreSQL 14 to 15
minor engine version | Disabled extensions |
20230228 and earlier | cube, earthdistance, ganos_geometry, ganos_geometry_sfcgal, ganos_geometry_topology, ganos_networking, ganos_pointcloud, ganos_pointcloud_geometry, ganos_raster, ganos_scene, ganos_sfmesh, ganos_spatialref, ganos_trajectory, ganos_utility, hstore, hypopg, index_adviser, intarray, ltree, madlib, orafce, pg_bigm, pg_cron, pg_profile, pg_stat_kcache, pglogical, pldebugger, plperl, plv8, postgis, postgis_sfcgal, postgis_tiger_geocoder, postgis_topology, timescaledb, zhparser, zombodb |
20230330 to 20230630 | ganos_geometry, ganos_geometry_sfcgal, ganos_vomesh, pg_partman, pgbouncer_fdw, pljava, postgis, postgis_raster, timescaledb |
20230830 to 20241030 | plperl |
20241230 to 20250228 | pg_cron |
20250430 and later | ganos_raster, ganos_scene, ganos_sfmesh, ganos_trajectory, ganos_utility, orafce, plv8 |
PostgreSQL 13
minor engine version | Disabled extensions |
20230228 and earlier | cube, earthdistance, ganos_geometry, ganos_geometry_sfcgal, ganos_geometry_topology, ganos_networking, ganos_pointcloud, ganos_pointcloud_geometry, ganos_raster, ganos_scene, ganos_sfmesh, ganos_spatialref, ganos_trajectory, ganos_utility, hstore, hypopg, index_adviser, intarray, ltree, madlib, orafce, pg_bigm, pg_cron, pg_profile, pg_stat_kcache, pglogical, pldebugger, plperl, plv8, postgis, postgis_sfcgal, postgis_tiger_geocoder, postgis_topology, timescaledb, zhparser, zombodb |
20230330 to 20230630 | ganos_geometry, ganos_geometry_sfcgal, ganos_vomesh, pg_partman, pg_pathman, pgbouncer_fdw, pljava, postgis, postgis_raster |
20230830 to 20241030 | plperl |
20241230 to 20250228 | pg_cron |
20250430 and later | ganos_raster, ganos_scene, ganos_sfmesh, ganos_trajectory, ganos_utility, plv8 |
PostgreSQL 12
Minor Engine Version | Disabled extensions |
20230228 and earlier | cube, earthdistance, ganos_geometry, ganos_geometry_sfcgal, ganos_geometry_topology, ganos_networking, ganos_pointcloud, ganos_pointcloud_geometry, ganos_raster, ganos_scene, ganos_sfmesh, ganos_spatialref, ganos_trajectory, ganos_utility, hstore, hypopg, index_adviser, intarray, ltree, madlib, orafce, pg_bigm, pg_cron, pg_profile, pg_stat_kcache, pglogical, pldebugger, plperl, plv8, postgis, postgis_sfcgal, postgis_tiger_geocoder, postgis_topology, timescaledb, zhparser, zombodb |
20230330 to 20230630 | ganos_geometry, ganos_geometry_sfcgal, ganos_vomesh, madlib, pg_partman, pg_pathman, pgbouncer_fdw, pljava, postgis, postgis_raster |
20230830 to 20241030 | plperl |
20241230 to 20250228 | pg_cron |
20250430 and later | ganos_utility, ganos_sfmesh, ganos_raster, ganos_scene, ganos_trajectory, madlib |
PostgreSQL 11
Minor engine version | Disabled extensions |
20230228 and earlier | cube, earthdistance, ganos_geometry, ganos_geometry_sfcgal, ganos_geometry_topology, ganos_networking, ganos_pointcloud, ganos_pointcloud_geometry, ganos_raster, ganos_scene, ganos_sfmesh, ganos_spatialref, ganos_trajectory, ganos_utility, hstore, hypopg, index_adviser, intarray, ltree, madlib, orafce, pg_bigm, pg_cron, pg_profile, pg_stat_kcache, pglogical, pldebugger, plv8, postgis, postgis_sfcgal, postgis_tiger_geocoder, postgis_topology, timescaledb, zhparser, zombodb |
20230330 to 20230630 | ganos_geometry, ganos_geometry_sfcgal, ganos_vomesh, madlib, pg_pathman, pgbouncer_fdw, pljava, postgis, postgis_raster |
20230830 to 20250228 | pg_cron |
20250430 and later | ganos_raster, ganos_scene, ganos_sfmesh, ganos_trajectory, ganos_utility, orafce, plv8 |
PostgreSQL 10
Minor engine version | Disabled extensions |
20230228 and earlier | cube, earthdistance, ganos_geometry, ganos_geometry_sfcgal, ganos_geometry_topology, ganos_networking, ganos_pointcloud, ganos_pointcloud_geometry, ganos_raster, ganos_scene, ganos_sfmesh, ganos_spatialref, ganos_trajectory, ganos_utility, hstore, hypopg, index_adviser, intarray, ltree, madlib, orafce, pg_bigm, pg_cron, pg_profile, pg_stat_kcache, pglogical, pldebugger, plv8, postgis, postgis_sfcgal, postgis_tiger_geocoder, postgis_topology, timescaledb, zhparser, zombodb |
20230330 to 20230630 | ganos_geometry, ganos_geometry_sfcgal, ganos_vomesh, pg_pathman, pljava, postgis, postgis_raster |
20230830 and later | ganos_raster, ganos_scene, ganos_sfmesh, ganos_trajectory, ganos_utility, orafce, pg_cron, plv8 |
Impacts
If you created the extensions listed in the preceding tables and did not delete them, their use is not affected.
If you have not created the extensions listed in the preceding tables, or if you created them and later deleted them, you cannot create them again if your instance runs a major and minor engine version listed in the tables. To create a restricted extension, upgrade the minor engine version of your instance to a version that supports the extension.
Related references
For information about how to query and upgrade the minor engine version, see Update the minor engine version.