All Products
Search
Document Center

ApsaraDB RDS:Limits on extension creation for ApsaraDB RDS for PostgreSQL instances

Last Updated:Feb 26, 2024

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

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.