Limits on extension creation for ApsaraDB RDS for PostgreSQL instances

Updated at: 2025-01-06 13:28

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
PostgreSQL 14 to PostgreSQL 15
PostgreSQL 13
PostgreSQL 12
PostgreSQL 11
PostgreSQL 10

Minor engine version

Unsupported extension

20231030 and after

orafce, ganos_utility, ganos_sfmesh, ganos_raster, ganos_scene, ganos_trajectory, and madlib.

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, orafce, and madlib

20230830

pg_cron, orafce, and madlib

20230830 and later

orafce, ganos_utility, ganos_sfmesh, ganos_raster, ganos_scene, ganos_trajectory, and madlib

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, ganos_trajectory, and madlib

20230830

pg_cron and madlib

20230830 and later

ganos_utility, ganos_sfmesh, ganos_raster, ganos_scene, ganos_trajectory, and madlib

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, ganos_trajectory, and madlib

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, ganos_trajectory, and madlib

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, ganos_trajectory, and madlib

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.

  • On this page (1)
  • Extensions that can no longer be created
  • Impacts
  • References
Feedback