As of April 27, 2023, some extensions can be created only in specified minor versions of PolarDB for PostgreSQL (Compatible with Oracle). For more information, see Affected extensions. Those extensions that you have created are not affected.
Background information
To strengthen extension management and protect extension security in PolarDB for PostgreSQL (Compatible with Oracle), some extensions cannot be created if the minor versions of your clusters are earlier than the specified versions. To create such extensions, you must upgrade your clusters to the specified versions or later.
Effective date
April 27, 2023
Affected clusters
PolarDB for PostgreSQL (Compatible with Oracle)
Affected extensions
Minor version | Extension |
Minor version | Extension |
PolarDB for Oracle 1.0 Earlier than V 1.1.31 | pg_cron, cube, earthdistance, ganos_raster, ganos_geometry_sfcgal, ganos_geometry_topology, ganos_geometry, ganos_networking, ganos_spatialref, ganos_pointcloud_geometry, ganos_pointcloud, ganos_trajectory, ganos_geomgrid, ganos_geometry_pyramid, ganos_fdw, postgis, postgis_sfcgal, postgis_topology, postgis_tiger_geocoder, address_standardizer_data_us, encdb, index_advisor, pg_wait_sampling, pldbgapi, polar_tz_offset, dbms_job, fastann, polar_monitor, pase, polar_outline, pg_bigm, hypopg, zombodb, polar_anydata, polar_nvl, polar_nvl2, polar_from_tz, polar_dba_views, polar_to_char, polar_utility, and polar_resource_group |
PolarDB for Oracle 2.0 Earlier than V2.0.14.6.0 | hypopg, pg_bigm, polar_monitor, zhparser, earthdistance, ganos_raster, ganos_geometry_sfcgal, ganos_geometry_topology, ganos_geometry, ganos_networking, ganos_spatialref, ganos_pointcloud_geometry, ganos_pointcloud, ganos_trajectory, ganos_geomgrid, ganos_geometry_pyramid, and ganos_fdw |
Other than preceding versions | Not affected |
Impacts
If you have created extensions that are listed in the preceding table and they still exist, the extensions are not affected.
If you have not created extensions that are listed in the preceding table or have deleted such extensions, and if the minor versions of your clusters are earlier than the specified versions, you cannot create those extensions. To create such extensions, you must upgrade your clusters to the specified versions or later.
References
For more information about how to view and update minor versions, see Upgrade the cluster version.
