PolarDB PostgreSQL has adjusted its plugin policy. Starting April 27, 2023, some plugins can be created only on specific minor engine versions. For details, see Restricted Plugins. The use of existing plugins is not affected.
Background information
To standardize plugin management and enhance security protection for PolarDB PostgreSQL, some plugins have been optimized. If the cluster's minor engine version is lower than the specified version, you cannot create these plugins. To use these plugins, you must upgrade the minor engine version to the specified version or a later version.
Restriction Effective Time
April 27, 2023
Affected Versions
PolarDB PostgreSQL
Restricted Plugins
Minor Engine Version Range | Restricted Plugins |
Compatible with PostgreSQL 11 Versions before V1.1.31 (excluding V1.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, polar_resource_group |
Compatible with PostgreSQL 14 Versions before V14.6.6.0 (excluding V14.6.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, ganos_fdw |
For versions not listed above | No restrictions on plugin creation. |
Impact
If you have already created the restricted plugins listed above and have not deleted them, your use of these plugins is not affected.
If your cluster's minor engine version is in a restricted range, you cannot create the specified plugins if you have not created them before or if you have previously deleted them. To create these plugins, you must upgrade the minor engine version to a version that is not restricted.
Related References
For more information about how to query and upgrade the minor engine version, see Minor Engine Version Management.