DocsICP FilingConsole
官方文档
首页

AliPG kernel minor versions (PostgreSQL 9.4–13)

更新时间：
复制 MD 格式
产品详情
我的收藏

This topic describes the AliPG kernel updates for ApsaraDB RDS for PostgreSQL minor engine versions 9.4 through 13, including new features, performance optimizations, and bug fixes for each release.

__

Important

PostgreSQL 13

Minor version Description
20260630 Compatible with PostgreSQL community version 13.23.

  • Bug fixes

    Fixes known issues.
20260530 Compatible with PostgreSQL community version 13.23.

  • New features

    • Upgraded the wal2json extension to v2.6.

    • The wal2json extension now supports polar-include-unchanged-toast.

  • Bug fixes

    Fixes known issues.
20251130 Compatible with PostgreSQL community version 13.22.

  • New features

    • Adds support for the online partitioning extension (rds_online_migrate), version 1.0.

    • Adds support for the clickhouse_fdw extension, version 1.4.

  • Bug fixes

    • Fixes known issues.

20250830| Compatible with PostgreSQL community version 13.22.

  • New features

    • Adds support for the Online DDL (rds_online_ddl) extension, version 1.0.

  • Bug fixes

    • Fixes known issues.

20250630| Compatible with PostgreSQL community version 13.21.

  • New features

    • None.

  • Bug fixes

    • Fixes known issues.

20250430| Compatible with PostgreSQL community version 13.20.

  • New features

  • Bug fixes

    • Fixes a security vulnerability in the scheduled task (pg_cron) extension and re-enables creating this extension from scratch.

    • Fixes other known issues.

20250228| Compatible with PostgreSQL community version 13.20.

  • New features

    • None.

  • Bug fixes

    • Fixes known issues.

20241230| Compatible with PostgreSQL community version 13.16.

  • New features

    • Upgrades the pg_hint_plan extension to version 1.3.9.

    • Added support for the encdb_btree plugin, version 1.0.0, to accelerate ciphertext queries in a fully encrypted database.

    • Added support for the encdb_btree plugin, version 1.0.0, to accelerate ciphertext queries in a fully encrypted database.

    • Now supports the encdb_btree extension, version 1.0.0, which accelerates ciphertext queries on a fully encrypted database.

    • Added support for the encdb_btree plugin version 1.0.0, which accelerates ciphertext queries in Encrypted Database.

    • Optimizes memory usage for the WALSender process in logical replication.

  • Bug fixes

    • Fixes known issues.

20241030| Compatible with PostgreSQL community version 13.16.

20240830| Compatible with PostgreSQL community version 13.16.

  • New features

    • Upgrades the encdb extension to version 1.1.14.

  • Bug fixes

    • Fixes known issues.

20240730| Compatible with PostgreSQL community version 13.15.

  • New features

    • None.

  • Bug fixes

    • Fixes known issues.

20240530| Compatible with PostgreSQL community version 13.14.

  • New features

  • Bug fixes

    • Fixes known issues.

20240229| Compatible with PostgreSQL community version 13.14.

20231230| Compatible with PostgreSQL community version 13.13.

20231030| Compatible with PostgreSQL community version 13.12.

  • New features

    • None.

  • Bug fixes

    • Upgrades the extension to version 5.9 and fixes known issues.

20230830| Compatible with PostgreSQL community version 13.12.

20230630| Compatible with PostgreSQL community version 13.9.

  • New featuresNone

  • Bug fixes

    • Fixes known issues.

20230530| Compatible with PostgreSQL community version 13.9.

  • New features

  • Bug fixes

    • Fixes an issue where the profile database fails to connect to the server database when using the pg_profile extension.

20230430| Compatible with PostgreSQL community version 13.9.

20230330| Compatible with PostgreSQL community version 13.9.

  • New features

    • None.

  • Bug fixes

    • Fixes some known issues.

20230228| Compatible with PostgreSQL community version 13.9.

20221230| Compatible with PostgreSQL community version 13.9.

20221030| Compatible with PostgreSQL community version 13.8.

20220830| Compatible with PostgreSQL community version 13.7.

  • New features

    • Upgrades the encdb extension to version 1.1.1.

    • Optimizes memory usage for the index_adviser extension.

  • Bug fixes

    • Fixes a memory overflow issue in the index_adviser extension during complex queries.

20220730| Compatible with PostgreSQL community version 13.6.

  • New features

    • Upgrades the extension to version 4.9. For more information, see Spatiotemporal engine version release notes.

      • Adds the ST_Intersection aggregate function to support aggregation operations on Geometry object arrays.

      • Adds the ST_AddZ function to convert Geometry 2D/3DM to Geometry 3D/4D by passing an array of Z coordinates as a parameter.

      • Enhances the ST_SetValue function to set pixel values based on a specified geometric spatial range.

      • Enhances the ST_ExportTo function to export Raster objects as COG files.

      • Enhances the ST_CreateRast function to convert regular grid point records or arrays into raster objects.

      • Enhances the ST_Split function to support specifying a start time for time-based splitting and splitting by trajectory point sequence number.

      • Enhances the ST_Union function to execute in batches based on memory usage to avoid out-of-memory (OOM) errors with large data volumes.

      • Adds support for HDFS file systems in raster data.

    • Enhances the pg_jieba extension to support custom dictionaries, dictionary switching, and displaying tokenization results by field offset.

  • Bug fixes

    • Fixes a crash in the index_adviser extension when all recommended indexes already exist.

20220228| Compatible with PostgreSQL community version 13.5.

  • New features

  • Bug fixes

    • Fixes missing parameter values in slow SQL logs.

20220130| Compatible with PostgreSQL community version 13.5.New features

20211130| Compatible with PostgreSQL community version 13.5.

  • New features

    • Upgrades the extension to version 4.4. For more information, see Spatiotemporal engine version release notes.

    • Upgrades the PostGIS extension to version 3.1.4.

    • Adds support for the pg_jieba Chinese text segmentation extension.

    • Adds support for the pldebugger extension for debugging stored procedures.

    • Adds support for the timescaledb extension, version 2.5.0.

    • Allows setting the log_statement parameter at the session, user, and database levels.

  • Bug fixes

    • Fixes an issue where privileged accounts cannot run show shared_preload_libraries;.

    • Fixes an issue where standard accounts can run pg_stat_reset().

20211031| Compatible with PostgreSQL community version 13.1.

  • Enhanced the Encrypted Database feature to support Intel SGX security-enhanced instances. For more information, see Encrypted Database overview.

  • New features

  • Feature optimizations

    • Enables audit log optimization by default.

    • The GanosBase extension is optimized, identifying the GanosBase extension in the extension description and providing an upgrade method. For more information, see GanosGanosGanosGanosGanosGanosHow to upgrade the spatiotemporal engine extension.

  • Bug fixes

    • Fixes an issue in the extension where functions fail if the extension is not upgraded.

20210930| Compatible with PostgreSQL community version 13.1.

  • New features

    • Upgrades the extension to version 4.1, adding and enhancing multiple functions. For more information, see Spatiotemporal engine version release notes.

    • Adds the self-developed rdsutils extension, which includes the failove_slots view feature.

    • Upgrades the rum extension to version 1.3.8.

    • Upgrades the pglogical extension to version 2.4.0.

    • Upgrades the plv8 extension to version 2.3.15.

  • Feature optimizations

    • Upgrades gcc to version 9.2 and glibc to version 2.30, enables LTO (Link Time Optimization), and improves overall performance by 5%.

    • Optimizes audit logs to improve performance by about 4× in high-concurrency scenarios (active_conn > 50) when the log_statement parameter is set to all.

    • Changes the default value of the rds_failover_slot_mode parameter to async, enabling Logical Replication Slot Failover by default.

  • Bug fixes

    • Fixes memory leaks in the mysql_fdw extension in certain scenarios.

    • Fixes memory leaks in the pg_cron extension in certain scenarios.

20210531| Compatible with PostgreSQL community version 13.1.

  • New features

    • Upgrades the extension to version 3.8.

      • Adds the ST_AsDatasetFile function to return raster objects within a specified range as binary streams in a specified file format.

      • Adds the ST_RasterDrivers function to query the status of all raster data drivers.

      • Fixes an issue where the ST_Clip function fails during reprojection with a specified spatial reference.

    • Adds support for the pglogical extension to provide logical streaming replication publishing and subscription capabilities.

    • Adds support for the pgAudit extension to generate audit logs.

  • Feature optimizations

    • Optimizes user permissions so that role2 no longer inherits the CREATEDB and CREATEROLE permissions from role1 when running GRANT role1 TO role2.__Important Roles granted via GRANT commands historically also lose CREATEDB and CREATEROLE permissions.

    • Grants privileged accounts access to the pg_ls_waldir() function.

    • Optimizes monitoring scan methods to improve CPU performance.

    • Optimizes major engine version upgrades. Supports smooth upgrades for extensions such as postgis and pgrouting, and smooth migration of account permissions from PostgreSQL 9.4 to higher versions.

    • Increases the log length limit from 1024 bytes to 4096 bytes when SQL causes out-of-memory errors or process crashes.

  • Bug fixes

    • Fixes a memory overflow defect in the oss_fdw extension in certain scenarios.

20210331| Compatible with PostgreSQL community version 13.1.

  • New features

    • Upgrades the extension to version 3.7.

    • Adds support for the pg_repack extension to clean up tablespace online and effectively resolve table bloat.

    • Upgrades the mysql_fdw extension to version 1.1.

    • Supports seamless migration of user permissions, the mysql_fdw extension, the oss_fdw extension, and extension permissions during major engine version upgrades.

    • Increased the length limit for SQL Audit statements to 8,000 bytes to prevent SQL statements longer than 2,000 bytes from being truncated.

    • Increased the length limit for SQL audit statements to 8,000 bytes, preventing statements longer than 2,000 bytes from being truncated.

    • The length limit for SQL audit statements is increased to 8,000 bytes to prevent SQL statements that are longer than 2,000 bytes from being truncated.

  • Bug fixes

    • Fixes an issue where the oss_fdw extension fails after minor or major engine version upgrades.

20210228| Compatible with PostgreSQL community version 13.1.

  • New features

    • Upgrades the extension to version 3.6.

    • Adds support for the decoderbufs extension to output data compatible with the Debezium platform based on the Protocol Buffers protocol.

    • Adds support for the pg_pathman high-performance partitioned table extension.

    • Adds support for the plv8 trusted JavaScript language extension.

    • Adds support for the oss_fdw extension to read and write OSS data.

    • Adds support for the mysql_fdw extension to read and write data from ApsaraDB RDS for MySQL instances or self-managed MySQL databases.

    • Allows privileged users to create event triggers and configure the maximum log length.

  • Bug fixes

    • Fixes an issue where slow logs fail to display properly.

    • Fixes an issue where privileged users lack permissions to use custom dictionaries with the zhparser extension.

    • Fixes an online alert issue related to archive_mode in logs.

20201230| Compatible with PostgreSQL community version 13.1.

  • New features

    • Adds parallel cleanup support for indexes.

    • Adds support for more data types from diverse sources.

    • Improves partitioning. Partitioned tables can now be directly joined, reducing total query execution time. Also supports before-row-level triggers and full logical replication.

    • Enables more aggregation and grouping types to leverage PostgreSQL's efficient hash aggregation, allowing queries with large aggregations to avoid being fully loaded into memory.

    • Adds support for the Logical Replication Slot Failover feature.

  • Performance optimizations

    • Optimizes indexing and lookup features for better suitability with large database systems.

For more information about PostgreSQL 13, see the official PostgreSQL documentation.

PostgreSQL 12

Minor version Description
20260630 Compatible with PostgreSQL community version 12.20.

  • Bug fixes

    Fixes known issues.
20251130 Compatible with PostgreSQL community version 12.20.

  • New features

    • None.

  • Bug fixes

    • Fixes known issues.

20250830| Compatible with PostgreSQL community version 12.20.

  • New features

    • Adds support for the Online DDL (rds_online_ddl) extension, version 1.0.

  • Bug fixes

    • Fixes known issues.

20250630| Compatible with PostgreSQL community version 12.20.

  • New features

    • None.

  • Bug fixes

    • Fixes known issues.

20250430| Compatible with PostgreSQL community version 12.20.

  • New features

    • None.

  • Bug fixes

    • Fixes a security vulnerability in the scheduled task (pg_cron) extension and re-enables creating this extension from scratch.

    • Fixes other known issues.

20250228| Compatible with PostgreSQL community version 12.20.

  • New features

    • None.

  • Bug fixes

    • Fixes known issues.

20241230| Compatible with PostgreSQL community version 12.20.

  • New features

  • Bug fixes

    • Fixes known issues.

20241030| Compatible with PostgreSQL community version 12.20.

20240830| Compatible with PostgreSQL community version 12.20.

  • New features

    • Upgrades the encdb extension to version 1.1.14.

  • Bug fixes

    • Fixes known issues.

20240730| Compatible with PostgreSQL community version 12.19.

  • New features

    • Upgrades the tds_fdw extension to version 2.0.3.

  • Bug fixes

    • Fixes known issues.

20240530| Compatible with PostgreSQL community version 12.18.

  • New features

  • Bug fixes

    • Fixes known issues.

20240229| Compatible with PostgreSQL community version 12.18.

20231230| Compatible with PostgreSQL community version 12.17.

20231030| Compatible with PostgreSQL community version 12.16.

  • New features

    • None.

  • Bug fixes

    • Upgrades the extension to version 5.9 and fixes known issues.

20230830| Compatible with PostgreSQL community version 12.16.

20230630| Compatible with PostgreSQL community version 12.13.

  • New featuresNone

  • Bug fixes

    • Fixes known issues.

20230530| Compatible with PostgreSQL community version 12.13.

20230430| Compatible with PostgreSQL community version 12.13.

20230330| Compatible with PostgreSQL community version 12.13.

  • New features

    • None.

  • Bug fixes

    • Fixes some known issues.

20230228| Compatible with PostgreSQL community version 12.13.

20221230| Compatible with PostgreSQL community version 12.13.

20221030| Compatible with PostgreSQL community version 12.12.

20220830| Compatible with PostgreSQL community version 12.11.

  • New features

    • Upgrades the encdb extension to version 1.1.1.

    • Optimizes memory usage for the index_adviser extension.

  • Bug fixes

    • Fixes a memory overflow issue in the index_adviser extension during complex queries.

20220730| Compatible with PostgreSQL community version 12.8.

  • New features

    • Upgrades the extension to version 4.9. For more information, see Spatiotemporal engine version release notes.

      • Adds the ST_Intersection aggregate function to support aggregation operations on Geometry object arrays.

      • Adds the ST_AddZ function to convert Geometry 2D/3DM to Geometry 3D/4D by passing an array of Z coordinates as a parameter.

      • Enhances the ST_SetValue function to set pixel values based on a specified geometric spatial range.

      • Enhances the ST_ExportTo function to export Raster objects as COG files.

      • Enhances the ST_CreateRast function to convert regular grid point records or arrays into raster objects.

      • Enhances the ST_Split function to support specifying a start time for time-based splitting and splitting by trajectory point sequence number.

      • Enhances the ST_Union function to execute in batches based on memory usage to avoid out-of-memory (OOM) errors with large data volumes.

      • Adds support for HDFS file systems in raster data.

    • Enhances the pg_jieba extension to support custom dictionaries, dictionary switching, and displaying tokenization results by field offset.

  • Bug fixes

    • Fixes a crash in the index_adviser extension when all recommended indexes already exist.

20220228| Compatible with PostgreSQL community version 12.8.

  • New features

  • Bug fixes

    • Fixes missing parameter values in slow SQL logs.

20220130| Compatible with PostgreSQL community version 12.8.New features

20211130| Compatible with PostgreSQL community version 12.8.

  • New features

    • Upgrades the extension to version 4.4. For more information, see Spatiotemporal engine version release notes.

    • Upgrades the PostGIS extension to version 3.1.4.

    • Adds support for the pg_jieba Chinese text segmentation extension.

    • Adds support for the pldebugger extension for debugging stored procedures.

    • Allows setting the log_statement parameter at the session, user, and database levels.

  • Bug fixes

    • Fixes a memory leak in the pg_cron extension when viewing task logs (cron.job_log).

    • Fixes an issue where privileged accounts cannot run show shared_preload_libraries;.

    • Fixes an issue where standard accounts can run pg_stat_reset().

20211031| Compatible with PostgreSQL community version 12.8.

  • Enhanced the fully encrypted database feature to support instances that use Intel Software Guard Extensions (SGX). For more information, see Overview of the fully encrypted database feature.

  • New features

  • Feature optimizations

    • Enables audit log optimization by default.

    • The GanosBase extension is optimized, and the extension description now identifies the GanosBase extension and provides an upgrade method. For more information, see How to upgrade the spatiotemporal engine extension.

  • Bug fixes

    • Fixes an issue in the extension where functions fail if the extension is not upgraded.

20210930| Compatible with PostgreSQL community version 12.8.

  • New features

    • Upgrades the extension to version 4.1, adding and enhancing multiple functions. For more information, see Spatiotemporal engine version release notes.

    • Adds the self-developed rdsutils extension, which includes the failove_slots view feature.

    • Upgrades the rum extension to version 1.3.8.

    • Upgrades the pg_pathman extension to version 1.5.12.

    • Upgrades the pglogical extension to version 2.4.0.

    • Upgrades the plv8 extension to version 2.3.15.

    • Upgrades the rdkit extension to version 2020_09_05.

  • Feature optimizations

    • Upgrades gcc to version 9.2 and glibc to version 2.30, enables LTO (Link Time Optimization), and improves overall performance by 5%.

    • Optimizes audit logs to improve performance by about 4× in high-concurrency scenarios (active_conn > 50) when the log_statement parameter is set to all.

    • Changes the default value of the rds_failover_slot_mode parameter to async, enabling Logical Replication Slot Failover by default.

  • Bug fixes

    • Fixes a bug where TimescaleDB loses system table metadata after running VACUUM FULL pg_catalog.pg_attribute.

    • Fixes memory leaks in the mysql_fdw extension in certain scenarios.

    • Fixes memory leaks in the pg_cron extension in certain scenarios.

20210531| Compatible with PostgreSQL community version 12.4.

  • New features

    • Upgrades the extension to version 3.8.

      • Adds the ST_AsDatasetFile function to return raster objects within a specified range as binary streams in a specified file format.

      • Adds the ST_RasterDrivers function to query the status of all raster data drivers.

      • Fixes an issue where the ST_Clip function fails during reprojection with a specified spatial reference.

    • Adds support for the pglogical extension to provide logical streaming replication publishing and subscription capabilities.

    • Adds support for the pgAudit extension to generate audit logs.

  • Feature optimizations

    • Optimizes user permissions so that role2 no longer inherits the CREATEDB and CREATEROLE permissions from role1 when running GRANT role1 TO role2.__Important Roles granted via GRANT commands historically also lose CREATEDB and CREATEROLE permissions.

    • Grants privileged accounts access to the pg_ls_waldir() function.

    • Optimizes monitoring scan methods to improve CPU performance.

    • Optimizes major engine version upgrades. Supports smooth upgrades for extensions such as postgis and pgrouting, and smooth migration of account permissions from PostgreSQL 9.4 to higher versions.

    • Increases the log length limit from 1024 bytes to 4096 bytes when SQL causes out-of-memory errors or process crashes.

  • Bug fixes

    • Fixes a memory overflow defect in the oss_fdw extension in certain scenarios.

20210331| Compatible with PostgreSQL community version 12.4.

  • New features

    • Upgrades the extension to version 3.7.

    • Adds support for the pg_repack extension to clean up tablespace online and effectively resolve table bloat.

    • Upgrades the mysql_fdw extension to version 1.1.

    • Supports seamless migration of user permissions, the mysql_fdw extension, the oss_fdw extension, and extension permissions during major engine version upgrades.

  • Bug fixes

    • Fixes an issue where the oss_fdw extension fails after minor or major engine version upgrades.

20210228| Compatible with PostgreSQL community version 12.4.

  • New features

    • Upgrades the extension to version 3.6.

    • Adds support for the decoderbufs extension to output data compatible with the Debezium platform based on the Protocol Buffers protocol.

    • Adds support for the pg_pathman high-performance partitioned table extension.

    • Adds support for the plv8 trusted JavaScript language extension.

    • Adds support for the oss_fdw extension to read and write OSS data.

  • Bug fixes

    • Fixes an issue where privileged users lack permissions to use custom dictionaries with the zhparser extension.

    • Fixes an online alert issue related to archive_mode in logs.

20201230| Compatible with PostgreSQL community version 12.4.

  • New features

    • Upgrades the extension to version 3.3.

    • Adds support for the pg_hint_plan extension, which uses special comment hints to change PostgreSQL's default execution plan.

    • Adds support for the zhparser extension.

    • Adds support for the RUM extension to enable high-speed full-text search.

    • Adds support for the bloom extension.

    • Adds support for the Logical Replication Slot Failover feature.

  • Bug fixes

    • Fixes a kernel issue caused by a conflict between tds_fdw and plancache.

20201130| Compatible with PostgreSQL community version 12.4.

  • New features

    • Allows privileged accounts to create accounts with REPLICATION privileges.

    • Allows privileged users to create event triggers.

    • Allows configuring the maximum audit log length (rds_auditlog_max_query_length).

    • Upgrades the pg_cron extension to allow creating and executing cross-database tasks and viewing task execution records via the cron.job_log table.

    • Adds support for the pg_freespacemap extension.

    • Adds spatiotemporal in-memory topology index support to .

    • Upgrades the extension to version 3.2.

  • Bug fixes

    • Fixes a check exception caused by opening or committing multiple sub-transactions during DTS migration.

    • Fixes the community security vulnerability CVE-2020-14349 (failure to properly clean up search paths during logical replication).

    • Fixes the community security vulnerability CVE-2020-14350 (uncontrolled search path elements in CREATE EXTENSION).

    • Fixes the community security vulnerability CVE-2020-25695 (creating non-temporary objects and executing arbitrary SQL functions as a superuser).

20200830| Compatible with PostgreSQL community version 12.2.

  • New features

    • Upgrades the extension to version 3.0.

    • Adds support for the SQL firewall extension to prevent malicious SQL injection.

    • Adds support for the bigm extension for fuzzy queries.

  • Bug fixes

    • Fixes an error where a background parameter with the rds_ prefix is not recognized.

    • Fixes an error where the pg_cron extension cannot be created or used properly.

    • Packages several dependencies for the RDKit extension and fixes an error where missing dependencies prevent loading.

20200421| Compatible with PostgreSQL community version 12.2.

  • New features

    • Upgrades the extension to version 2.7.

    • Adds the hll extension, version 2.14.

    • Adds the plproxy extension, version 2.9.0.

    • Adds the tsm_system_rows extension, version 1.0.

    • Adds the tsm_system_time extension, version 1.0.

    • Adds the smlar extension, version 1.0.

    • Adds the tds_fdw extension, version 1.0.

  • Bug fixes an issue where logical subscription timeouts cause instance restarts.

20200221|

  • New features

    • Reserves a specified number of connections for the rds_superuser role to allow troubleshooting when connection limits are reached.

    • Adds support for the wal2json extension.

    • Upgrades the extension to version 2.6.

  • Bug fixes some permission issues.

20191230| New features

  • Adds support for the pg_roaringbitmap, rdkit, mysql_fdw, and extensions.

  • Allows privileged accounts to publish all tables and create subscriptions in one operation.

PostgreSQL 11

Minor version Description
20260630 Compatible with PostgreSQL community version 11.23.

  • Bug fixes

    Fixes known issues.
20250630 Compatible with PostgreSQL community version 11.22.

  • New features

    • None.

  • Bug fixes

    • Fixes known issues.

20250430| Compatible with PostgreSQL community version 11.22.

  • New features

    • None.

  • Bug fixes

    • Fixes a security vulnerability in the scheduled task (pg_cron) extension and re-enables creating this extension from scratch.

    • Fixes other known issues.

20250228| Compatible with PostgreSQL community version 11.22.

  • New features

    • None.

  • Bug fixes

    • Fixes known issues.

20241230| Compatible with PostgreSQL community version 11.22.

  • New features

  • Bug fixes

    • Fixes known issues.

20241030| Compatible with PostgreSQL community version 11.22.

  • Bug fixes

    • Fixes known issues.

20240830| Compatible with PostgreSQL community version 11.22.

  • New features

    • Upgrades the encdb extension to version 1.1.14.

  • Bug fixes

    • Fixes known issues.

20240730| Compatible with PostgreSQL community version 11.22.

  • New features

    • Upgrades the tds_fdw extension to version 2.0.3.

  • Bug fixes

    • Fixes known issues.

20240530| Compatible with PostgreSQL community version 11.22.

  • New features

  • Bug fixes

    • Fixes known issues.

20240229| Compatible with PostgreSQL community version 11.22.

20231230| Compatible with PostgreSQL community version 11.22.

20231030| Compatible with PostgreSQL community version 11.21.

  • New features

    • None.

  • Bug fixes

    • Upgrades the extension to version 5.9 and fixes known issues.

20230830| Compatible with PostgreSQL community version 11.21.

20230630| Compatible with PostgreSQL community version 11.18.

  • New featuresNone

  • Bug fixes

    • Fixes known issues.

20230530| Compatible with PostgreSQL community version 11.18.

20230430| Compatible with PostgreSQL community version 11.18.

20230330| Compatible with PostgreSQL community version 11.18.

  • New features

    • None.

  • Bug fixes

    • Fixes some known issues.

20221230| Compatible with PostgreSQL community version 11.18.

20221030| Compatible with PostgreSQL community version 11.17.

20220830| Compatible with PostgreSQL community version 11.16.

  • New features

    • Upgrades the encdb extension to version 1.1.1.

    • Optimizes memory usage for the index_adviser extension.

  • Bug fixes

    • Fixes a memory overflow issue in the index_adviser extension during complex queries.

20220730| Compatible with PostgreSQL community version 11.13.

  • New features

    • Upgrades the extension to version 4.9. For more information, see Spatiotemporal engine version release notes.

      • Adds the ST_Intersection aggregate function to support aggregation operations on Geometry object arrays.

      • Adds the ST_AddZ function to convert Geometry 2D/3DM to Geometry 3D/4D by passing an array of Z coordinates as a parameter.

      • Enhances the ST_SetValue function to set pixel values based on a specified geometric spatial range.

      • Enhances the ST_ExportTo function to export Raster objects as COG files.

      • Enhances the ST_CreateRast function to convert regular grid point records or arrays into raster objects.

      • Enhances the ST_Split function to support specifying a start time for time-based splitting and splitting by trajectory point sequence number.

      • Enhances the ST_Union function to execute in batches based on memory usage to avoid out-of-memory (OOM) errors with large data volumes.

      • Adds support for HDFS file systems in raster data.

    • Enhances the pg_jieba extension to support custom dictionaries, dictionary switching, and displaying tokenization results by field offset.

  • Bug fixes

    • Fixes a crash in the index_adviser extension when all recommended indexes already exist.

20220228| Compatible with PostgreSQL community version 11.13.

  • New features

  • Bug fixes

    • Fixes missing parameter values in slow SQL logs.

20220130| Compatible with PostgreSQL community version 11.13.New features

20211130| Compatible with PostgreSQL community version 11.13.

  • New features

    • Upgrades the extension to version 4.4. For more information, see Spatiotemporal engine version release notes.

    • Upgrades the PostGIS extension to version 3.1.4.

    • Adds support for the pg_jieba Chinese text segmentation extension.

    • Adds support for the pldebugger extension for debugging stored procedures.

    • Allows setting the log_statement parameter at the session, user, and database levels.

  • Bug fixes

    • Fixes a memory leak in the pg_cron extension when viewing task logs (cron.job_log).

    • Fixes an issue where privileged accounts cannot run show shared_preload_libraries;.

    • Fixes an issue where standard accounts can run pg_stat_reset().

20211031| Compatible with PostgreSQL community version 11.13.

  • Enhanced the fully encrypted database feature to support instances that use Intel Software Guard Extensions (SGX). For more information, see Overview of the fully encrypted database feature.

  • New features

  • Feature optimizations

    • Enables audit log optimization by default.

    • The GanosBase extension is optimized, identifying the GanosBase extension in the extension description and providing an upgrade method. For more information, see How to upgrade the spatiotemporal engine extension.

  • Bug fixes

    • Fixes an issue in the extension where functions fail if the extension is not upgraded.

20210930| Compatible with PostgreSQL community version 11.13.

  • New features

    • Upgrades the extension to version 4.1, adding and enhancing multiple functions. For more information, see Spatiotemporal engine version release notes.

    • Adds the self-developed rdsutils extension, which includes the failove_slots view feature.

    • Upgrades the rum extension to version 1.3.8.

    • Upgrades the pg_pathman extension to version 1.5.12.

    • Upgrades the pglogical extension to version 2.4.0.

    • Upgrades the plv8 extension to version 2.3.15.

  • Feature optimizations

    • Upgrades gcc to version 9.2 and glibc to version 2.30, enables LTO (Link Time Optimization), and improves overall performance by 5%.

    • Optimizes audit logs to improve performance by about 4× in high-concurrency scenarios (active_conn > 50) when the log_statement parameter is set to all.

    • Changes the default value of the rds_failover_slot_mode parameter to async, enabling Logical Replication Slot Failover by default.

    • Optimizes the incomplete startup packet log triggered by empty packets so it no longer outputs.

  • Bug fixes

    • Fixes memory leaks in the mysql_fdw extension in certain scenarios.

    • Fixes memory leaks in the pg_cron extension in certain scenarios.

20210531| Compatible with PostgreSQL community version 11.9.

  • New features

    • Upgrades the extension to version 3.8.

      • Adds the ST_AsDatasetFile function to return raster objects within a specified range as binary streams in a specified file format.

      • Adds the ST_RasterDrivers function to query the status of all raster data drivers.

      • Fixes an issue where the ST_Clip function fails during reprojection with a specified spatial reference.

    • Adds support for the pglogical extension to provide logical streaming replication publishing and subscription capabilities.

    • Adds support for the pgAudit extension to generate audit logs.

    • Adds support for the confidential database feature. Data is encrypted on the client side before being sent to the cloud database, effectively defending against external and internal security threats from the cloud platform and protecting user data at all times.

  • Feature optimizations

    • Optimizes user permissions so that role2 no longer inherits the CREATEDB and CREATEROLE permissions from role1 when running GRANT role1 TO role2.__Important Roles granted via GRANT commands historically also lose CREATEDB and CREATEROLE permissions.

    • Grants privileged accounts access to the pg_ls_waldir() function.

    • Optimizes monitoring scan methods to improve CPU performance.

    • Optimizes major engine version upgrades. Supports smooth upgrades for extensions such as postgis and pgrouting, and smooth migration of account permissions from PostgreSQL 9.4 to higher versions.

    • Increases the log length limit from 1024 bytes to 4096 bytes when SQL causes out-of-memory errors or process crashes.

  • Bug fixes

    • Fixes an index out-of-bounds issue in the PASE extension.

    • Fixes a memory overflow defect in the oss_fdw extension in certain scenarios.

20210331| Compatible with PostgreSQL community version 11.9.

  • New features

    • Upgrades the extension to version 3.7.

    • Adds support for the pg_repack extension to clean up tablespace online and effectively resolve table bloat.

    • Upgrades the mysql_fdw extension to version 1.1.

    • Supports seamless migration of user permissions, the mysql_fdw extension, the oss_fdw extension, and extension permissions during major engine version upgrades.

  • Bug fixes

    • Fixes an issue where the oss_fdw extension fails after minor or major engine version upgrades.

20210228| Compatible with PostgreSQL community version 11.9.

  • New features

    • Upgrades the extension to version 3.6.

    • Adds support for the mysql_fdw extension to read and write data from ApsaraDB RDS for MySQL instances or self-managed MySQL databases.

  • Bug fixes

    • Fixes an online alert issue related to archive_mode in logs.

20201230| Compatible with PostgreSQL community version 11.9.

  • New features

    • Upgrades the extension to version 3.3.

    • Adds support for the pg_hint_plan extension, which uses special comment hints to change PostgreSQL's default execution plan.

    • Adds support for the bloom extension.

  • Bug fixes

    • Optimizes Failover Slot to ensure no data loss even in extreme cases under synchronous mode.

    • Fixes a kernel issue caused by a conflict between tds_fdw and plancache.

20201130| Compatible with PostgreSQL community version 11.9.

  • New features

    • Allows privileged accounts to create accounts with REPLICATION privileges.

    • Allows privileged users to create event triggers.

    • Allows configuring the maximum audit log length (rds_auditlog_max_query_length).

    • Upgrades the pg_cron extension to allow creating and executing cross-database tasks and viewing task execution records via the cron.job_log table.

    • Adds support for the pg_freespacemap extension.

    • Adds spatiotemporal in-memory topology index support to .

    • Upgrades the extension to version 3.2.

  • Bug fixes

    • Fixes a check exception caused by opening or committing multiple sub-transactions during DTS migration.

    • Fixes the community security vulnerability CVE-2020-14349 (failure to properly clean up search paths during logical replication).

    • Fixes the community security vulnerability CVE-2020-14350 (uncontrolled search path elements in CREATE EXTENSION).

    • Fixes the community security vulnerability CVE-2020-25695 (creating non-temporary objects and executing arbitrary SQL functions as a superuser).

20200830|

  • New features

    • Upgrades the extension to version 3.0.

    • Adds support for the SQL firewall extension to prevent malicious SQL injection.

    • Adds support for the bigm extension for fuzzy queries.

    • Adds support for the ZomboDB extension for text search and analysis.

  • Bug fixes

    • Fixes an error where a background parameter with the rds_ prefix is not recognized.

    • Fixes an error where duplicate-named streaming replication slots cause standby database crashes.

    • Fixes an error where the pg_cron extension cannot be created or used properly.

    • Fixes a correctness error in the PASE extension caused by a global variable.

20200610| New features

  • Allows rds_superuser to use the pageinspect extension.

  • Allows rds_superuser to grant replication permissions to other users.

May 11, 2020|

  • New features Upgrades the extension to version 2.8.

  • Bug fixes a slow insert issue with HNSW indexes in the PASE extension.

20200421| New features

  • Adds support for the Logical Replication Slot Failover feature.

  • Adds the plproxy extension, version 2.9.0.

  • Adds the tsm_system_rows extension, version 1.0.

  • Adds the tsm_system_time extension, version 1.0.

  • Adds the smlar extension, version 1.0.

20200402|

  • New features

    • Adds support for the hll extension (version 2.14), which adds the hll data type. This extension provides millisecond-level responses for approximate data analytics, such as real-time PV/UV queries or feature tag containment checks, offering a low-cost, high-efficiency solution for approximate analysis.

    • Adds support for the oss_fdw extension (version 1.1) for extended database storage on OSS. You can store historical data with low query volume on OSS to reduce storage costs while still meeting infrequent query needs.

    • Adds support for the tds_fdw extension (version 2.0.1) to query Sybase and SQL Server data in real time from a PostgreSQL database without an ETL program, meeting cross-database query and data migration needs.

  • Extension upgrades

    • Upgrades to version 2.7.

    • Upgrades wal2json to version 2.2.

  • Performance optimizations Optimizes the shutdown -m fast command.

20191218| New features

  • Adds support for the PASE index extension, which provides image recognition indexing.

  • Allows privileged accounts to publish all tables and create subscriptions in one operation.

PostgreSQL 10

Minor version Description
20231230 Compatible with PostgreSQL community version 10.23.

  • New featuresNone

  • Bug fixes

    • Fixes known issues.

20230830| Compatible with PostgreSQL community version 10.23.

20230630| It is compatible with community version 10.23.

  • New featuresNone

  • Bug fixes

    • Fixes known issues.

20230430| Compatible with PostgreSQL community version 10.23.

20230330| It is compatible with community version 10.23.

  • New features

    • None.

  • Bug fixes

    • Fixes some known issues.

20221230| Compatible with PostgreSQL community version 10.23.

20221030| It is compatible with community version 10.22.

20220830| Compatible with PostgreSQL community version 10.21.

  • New features

    • Upgrades the encdb extension to version 1.1.1.

    • Optimizes memory usage for the index_adviser extension.

  • Bug fixes

    • Fixes a memory overflow issue in the index_adviser extension during complex queries.

20220730| Compatible with PostgreSQL community version 10.19.

  • New features

    • Upgrades the extension to version 4.9. For more information, see Spatiotemporal engine version release notes.

      • Adds the ST_Intersection aggregate function to support aggregation operations on Geometry object arrays.

      • Adds the ST_AddZ function to convert Geometry 2D/3D to Geometry 3D/4D by passing an array of Z coordinates as a parameter.

      • Enhances the ST_SetValue function to set pixel values based on a specified geometric spatial range.

      • Enhances the ST_ExportTo function to export Raster objects as COG files.

      • Enhances the ST_CreateRast function to convert regular grid point records or arrays into raster objects.

      • Enhances the ST_Split function to support specifying a start time for time-based splitting and splitting by trajectory point sequence number.

      • Enhances the ST_Union function to execute in batches based on memory usage to avoid out-of-memory (OOM) errors with large data volumes.

      • Adds support for HDFS file systems in raster data.

    • Enhances the pg_jieba extension to support custom dictionaries, dictionary switching, and displaying tokenization results by field offset.

  • Bug fixes

    • Fixes a crash in the index_adviser extension when all recommended indexes already exist.

    • Allows privileged roles to run the CREATE PUBLICATION xxx FOR ALL TABLES; command.

20220228| Compatible with PostgreSQL community version 10.19.

  • New features

  • Bug fixes

    • Fixes missing parameter values in slow SQL logs.

20220130| Compatible with PostgreSQL community version 10.19.New features

20211130| Compatible with PostgreSQL community version 10.19.

  • New features

    • Upgrades the extension to version 4.4. For more information, see Spatiotemporal engine version release notes.

    • Upgrades the PostGIS extension to version 3.1.4 and adds support for ApsaraDB RDS for PostgreSQL.

    • Adds support for the pg_jieba Chinese text segmentation extension.

    • Adds support for the pldebugger extension for debugging stored procedures.

    • Allows setting the log_statement parameter at the session, user, and database levels.

  • Bug fixes

    • Fixes a memory leak in the pg_cron extension when viewing task logs (cron.job_log).

    • Fixes an issue where standard accounts can run pg_stat_reset().

20211031| Compatible with PostgreSQL community version 10.14.

  • Enhanced the fully encrypted database feature to support instances that use Intel SGX. For more information, see Overview of the fully encrypted database feature.

  • New features

  • Feature optimizations

    • Enables audit log optimization by default.

    • The GanosBase extension is optimized. The extension description now identifies the GanosBase extension and provides an upgrade method. For more information, see How to upgrade the spatiotemporal engine extension.

  • Bug fixes

    • Fixes an issue in the extension where functions fail if the extension is not upgraded.

20210930| Compatible with PostgreSQL community version 10.14.

  • New features

    • Upgrades the extension to version 4.1, adding and enhancing multiple functions. For more information, see Spatiotemporal engine version release notes.

    • Adds the self-developed rdsutils extension, which includes the failove_slots view feature.

    • Upgrades the rum extension to version 1.3.8.

    • Upgrades the pglogical extension to version 2.4.0.

    • Upgrades the plv8 extension to version 2.3.15.

  • Feature optimizations

    • Upgrades gcc to version 9.2 and glibc to version 2.30, enables LTO (Link Time Optimization), and improves overall performance by 5%.

    • Optimizes audit logs to improve performance by about 4× in high-concurrency scenarios (active_conn > 50) when the log_statement parameter is set to all.

    • Changes the default value of the rds_failover_slot_mode parameter to async, enabling Logical Replication Slot Failover by default.

    • Optimizes the incomplete startup packet log triggered by empty packets so it no longer outputs.

  • Bug fixes

    • Fixes memory leaks in the mysql_fdw extension in certain scenarios.

    • Fixes memory leaks in the pg_cron extension in certain scenarios.

20210531| Compatible with PostgreSQL community version 10.14.

  • New features

    • Upgrades the extension to version 3.8.

      • Adds the ST_AsDatasetFile function to return raster objects within a specified range as binary streams in a specified file format.

      • Adds the ST_RasterDrivers function to query the status of all raster data drivers.

      • Fixes an issue where the ST_Clip function fails during reprojection with a specified spatial reference.

    • Adds support for the pglogical extension to provide logical streaming replication publishing and subscription capabilities.

    • Adds support for the pgAudit extension to generate audit logs.

  • Feature optimizations

    • Optimizes user permissions so that role2 no longer inherits the CREATEDB and CREATEROLE permissions from role1 when running GRANT role1 TO role2.__Important Roles granted via GRANT commands historically also lose CREATEDB and CREATEROLE permissions.

    • Grants privileged accounts access to the pg_ls_waldir() function.

    • Optimizes monitoring scan methods to improve CPU performance.

    • Optimizes major engine version upgrades. Supports smooth upgrades for extensions such as postgis and pgrouting, and smooth migration of account permissions from PostgreSQL 9.4 to higher versions.

    • Increases the log length limit from 1024 bytes to 4096 bytes when SQL causes out-of-memory errors or process crashes.

  • Bug fixes

    • Fixes a memory overflow defect in the oss_fdw extension in certain scenarios.

20210331| Compatible with PostgreSQL community version 10.14.

  • New features

    • Upgrades the extension to version 3.7.

    • Adds support for the pg_repack extension to clean up tablespace online and effectively resolve table bloat.

    • Adds support for the mysql_fdw extension in PostgreSQL 10.

    • Upgrades the mysql_fdw extension to version 1.1.

    • Supports seamless migration of user permissions, the mysql_fdw extension, the oss_fdw extension, and extension permissions during major engine version upgrades.

  • Bug fixes

    • Fixes an issue where the oss_fdw extension fails after minor or major engine version upgrades.

20210228| Compatible with PostgreSQL community version 10.14.

  • New features

    • Upgrades the extension to version 3.6.

  • Bug fixes

    • Fixes an online alert issue related to archive_mode in logs.

20201230| This product is compatible with community version 10.14.New features

20201130| Compatible with PostgreSQL community version 10.14.

  • New features

    • Allows privileged accounts to create accounts with REPLICATION privileges.

    • Allows privileged users to create event triggers.

    • Allows configuring the maximum audit log length (rds_auditlog_max_query_length).

    • Upgrades the pg_cron extension to allow creating and executing cross-database tasks and viewing task execution records via the cron.job_log table.

    • Adds support for the pg_freespacemap extension.

    • Adds spatiotemporal in-memory topology index support to .

    • Upgrades the extension to version 3.2.

  • Bug fixes

    • Fixes a check exception caused by opening or committing multiple sub-transactions during DTS migration.

    • Fixes the community security vulnerability CVE-2020-14349 (failure to properly clean up search paths during logical replication).

    • Fixes the community security vulnerability CVE-2020-14350 (uncontrolled search path elements in CREATE EXTENSION).

    • Fixes the community security vulnerability CVE-2020-25695 (creating non-temporary objects and executing arbitrary SQL functions as a superuser).

20200830| Compatible with PostgreSQL community version 10.9.

  • New features

    • Upgrades the extension to version 3.0.

    • Adds support for the SQL firewall extension to prevent malicious SQL injection.

    • Adds support for the bigm extension for fuzzy queries.

  • Bug fixes

    • Fixes an error where the pg_cron extension cannot be created or used properly.

20200212| Compatible with PostgreSQL community version 10.9.

  • New features

    • Reserves a specified number of connections for the rds_superuser role to allow troubleshooting when connection limits are reached.

    • Upgrades the extension to version 2.6.

  • Bug fixes long wait times in streaming replication.

20190703| Compatible with PostgreSQL community version 10.9.

  • New features

    • Updates version to 10.9.

    • Supports changing synchronous replication to asynchronous replication on timeout.

  • Bug fixes

    • Fixes a make pg_hint_plan error.

PostgreSQL 9.4

Minor version Description
20210531 Feature optimizationsOptimizes major engine version upgrades. Supports smooth upgrades for extensions such as postgis and pgrouting, and smooth migration of account permissions from PostgreSQL 9.4 to higher versions.
20201130 Bug fixes

  • Fixes the community security vulnerability CVE-2020-25694 (potential loss of security parameters during connection switching, leading to attacks).

  • Fixes the community security vulnerability CVE-2020-25695 (creating non-temporary objects and executing arbitrary SQL functions as a superuser).

  • Fixes the community security vulnerability CVE-2020-25696 (gset allows overwriting specially handled variables).

20200623|

  • New features

    • Upgrades wal2json to version 2.2.

    • Adds support for the xml2 extension, version 1.0.

  • Bug fixes a memory exhaustion issue caused using the wal2json extension.

20200210| New featuresReserves a specified number of connections for the rds_superuser role to allow troubleshooting when connection limits are reached. 20190601| Updates version to 9.4.19.

Previous：AliPG kernel minor version releases (PostgreSQL 14-18)Next：Functional modules of AliPG