To standardize extension management and enhance extension-related data protection for ApsaraDB RDS for PostgreSQL, ApsaraDB RDS plans to optimize vulnerable extensions in minor engine version iterations in phases. Some extensions can no longer be created for ApsaraDB RDS for PostgreSQL instances that run specific minor engine versions. This topic describes the limits on extension creation for different minor engine versions. After the vulnerable extensions are optimized, you can update the minor engine version of your RDS instance to use the extensions. Existing extensions are not affected.
Extensions that can no longer be created
PostgreSQL 16
Minor engine version | Unsupported extension |
20231030 and after | orafce, ganos_utility, ganos_sfmesh, ganos_raster, ganos_scene, and ganos_trajectory |
PostgreSQL 14 to PostgreSQL 15
Minor engine version | Unsupported extension |
Earlier than 20230228 | pg_cron, cube, earthdistance, ganos_geometry, ganos_geometry_sfcgal, ganos_geometry_topology, ganos_networking, ganos_pointcloud, ganos_pointcloud_geometry, ganos_raster, ganos_spatialref, ganos_trajectory, hstore, hypopg, index_adviser, intarray, ltree, madlib, orafce, pg_bigm, pg_profile, pg_stat_kcache, pglogical, pldebugger, postgis, postgis_sfcgal, postgis_tiger_geocoder, postgis_topology, timescaledb, zhparser, and zombodb |
20230330 to 20230730 | pg_cron, ganos_geometry_sfcgal, ganos_vomesh, ganos_scene, timescaledb, pg_partman, postgis_raster, pljava, ganos_geometry, pgbouncer_fdw, postgis, ganos_raster, ganos_sfmesh, ganos_trajectory, and orafce |
20230830 | pg_cron and orafce |
20230830 and later | orafce, ganos_utility, ganos_sfmesh, ganos_raster, ganos_scene, and ganos_trajectory |
PostgreSQL 13
Minor engine version | Unsupported extension |
Earlier than 20230228 | pg_cron, cube, earthdistance, ganos_geometry, ganos_geometry_sfcgal, ganos_geometry_topology, ganos_networking, ganos_pointcloud, ganos_pointcloud_geometry, ganos_raster, ganos_spatialref, ganos_trajectory, hstore, hypopg, index_adviser, intarray, ltree, madlib, orafce, pg_bigm, pg_profile, pg_stat_kcache, pglogical, pldebugger, postgis, postgis_sfcgal, postgis_tiger_geocoder, postgis_topology, timescaledb, zhparser, and zombodb |
20230330 to 20230730 | pg_cron, ganos_geometry_sfcgal, ganos_vomesh, ganos_scene, pg_partman, postgis_raster, pljava, ganos_geometry, pgbouncer_fdw, postgis, pg_pathman, ganos_raster, ganos_sfmesh, and ganos_trajectory |
20230830 | pg_cron |
20230830 and later | ganos_utility, ganos_sfmesh, ganos_raster, ganos_scene, and ganos_trajectory |
PostgreSQL 12
Minor engine version | Unsupported extension |
Earlier than 20230228 | pg_cron, cube, earthdistance, ganos_geometry, ganos_geometry_sfcgal, ganos_geometry_topology, ganos_networking, ganos_pointcloud, ganos_pointcloud_geometry, ganos_raster, ganos_spatialref, ganos_trajectory, hstore, hypopg, index_adviser, intarray, ltree, madlib, orafce, pg_bigm, pg_profile, pg_stat_kcache, pglogical, pldebugger, postgis, postgis_sfcgal, postgis_tiger_geocoder, postgis_topology, timescaledb, zhparser, and zombodb |
20230330 to 20230730 | ganos_geometry_sfcgal, ganos_vomesh, ganos_scene, c, postgis_raster, ganos_sfmesh, pljava, ganos_geometry, pgbouncer_fdw, madlib, pg_pathman, ganos_raster, postgis, and ganos_trajectory |
20230830 and later | ganos_utility, ganos_sfmesh, ganos_raster, ganos_scene, and ganos_trajectory |
PostgreSQL 11
Minor engine version | Unsupported extension |
Earlier than 20230228 | pg_cron, cube, earthdistance, ganos_geometry, ganos_geometry_sfcgal, ganos_geometry_topology, ganos_networking, ganos_pointcloud, ganos_pointcloud_geometry, ganos_raster, ganos_spatialref, ganos_trajectory, hstore, hypopg, index_adviser, intarray, ltree, madlib, orafce, pg_bigm, pg_profile, pg_stat_kcache, pglogical, pldebugger, postgis, postgis_sfcgal, postgis_tiger_geocoder, postgis_topology, timescaledb, zhparser, and zombodb |
20230330 to 20230730 | ganos_geometry_sfcgal, ganos_vomesh, ganos_scene, c, postgis_raster, ganos_sfmesh, pljava, ganos_geometry, pgbouncer_fdw, madlib, pg_pathman, ganos_raster, postgis, ganos_trajectory, and orafce |
20230830 and later | orafce, ganos_utility, ganos_sfmesh, ganos_raster, ganos_scene, and ganos_trajectory |
PostgreSQL 10
Minor engine version | Unsupported extension |
Earlier than 20230228 | pg_cron, cube, earthdistance, ganos_geometry, ganos_geometry_sfcgal, ganos_geometry_topology, ganos_networking, ganos_pointcloud, ganos_pointcloud_geometry, ganos_raster, ganos_spatialref, ganos_trajectory, hstore, hypopg, index_adviser, intarray, ltree, madlib, orafce, pg_bigm, pg_profile, pg_stat_kcache, pglogical, pldebugger, postgis, postgis_sfcgal, postgis_tiger_geocoder, postgis_topology, timescaledb, zhparser, and zombodb |
20230330 to 20230730 | ganos_geometry_sfcgal, ganos_vomesh, ganos_scene, postgis_raster, ganos_sfmesh, pljava, ganos_geometry, pgbouncer_fdw, madlib, pg_pathman, ganos_raster, postgis, ganos_trajectory, and orafce |
20230830 and later | orafce, ganos_utility, ganos_sfmesh, ganos_raster, ganos_scene, and ganos_trajectory |
Impacts
If you created the extensions that are listed in the preceding table and do not delete the extensions, the extensions can run as expected.
If you did not create the extensions that are listed in the preceding table or you created the extensions but deleted the extensions, the extensions can no longer be created for RDS instances that run the corresponding major and minor engine versions. To create the extensions, you must update the minor engine version of your RDS instance to a version for which no limits are imposed on the creation of the extensions.
References
For more information about how to view and update the minor engine version of your RDS instance, see Update the minor engine version.