To standardize extension management and improve security, RDS is optimizing extensions that have security risks. These changes will be rolled out in future engine version iterations. As a result, you cannot create certain extensions in specific engine versions. This topic lists the restricted extensions for each engine version. Once an extension is optimized, you can use it by upgrading to the latest minor engine version. These restrictions do not affect extensions that you have already created.
List of restricted extensions
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–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 |
Impact
If you already created one of the listed extensions, you can continue to use it.
If you have not created a restricted extension, or if you have deleted one, you cannot create it again if your instance is running a minor engine version that is listed in the tables. To create the extension, you must upgrade your instance to a minor engine version that supports it.
Related topics
For more information about how to query and upgrade the minor engine version, see Upgrade the minor engine version.