All Products
Search
Document Center

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

Last Updated:Aug 30, 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 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.