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. As a result, some extensions can no longer be created for RDS instances that run earlier 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 ApsaraDB RDS for PostgreSQL instance to use the extensions. Existing extensions are not affected.
Extensions that can no longer be created
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, and ganos_trajectory |
20230830 | pg_cron |
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 |
PostgreSQL 11 to 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 |
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, 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.