All Products
Search
Document Center

ApsaraDB RDS:AliPG minor engine version release notes (PostgreSQL 9.4 to 13)

Last Updated:Dec 23, 2025

This topic describes the updates to the AliPG kernel for ApsaraDB RDS for PostgreSQL versions 9.4 through 13.

Important

PostgreSQL 13

Minor version

Description

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

    Adds support for the SQL throttling (rds_ccl) extension, version 1.2.

  • 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.

    • 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 GanosBase 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 features

    None

  • Bug fixes

    Fixes known issues.

20230530

Compatible with PostgreSQL community version 13.9.

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 GanosBase extension to version 4.9. For more information, see Spatio-temporal 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.

20220130

Compatible with PostgreSQL community version 13.5.

New features

20211130

Compatible with PostgreSQL community version 13.5.

  • New features

    • Upgrades the GanosBase extension to version 4.4. For more information, see Spatio-temporal 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.

  • New features

    Adds detection for EncDB SDK and EncJDBC versions in confidential databases.

  • Feature optimizations

    • Enables audit log optimization by default.

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

  • Bug fixes

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

20210930

Compatible with PostgreSQL community version 13.1.

  • New features

    • Upgrades the GanosBase extension to version 4.1, adding and enhancing multiple functions. For more information, see Spatio-temporal 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 GanosBase 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 GanosBase 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 13.1.

  • New features

    • Upgrades the GanosBase 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

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

    Upgrades the pg_hint_plan extension to version 1.3.9.

  • 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 GanosBase 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 features

    None

  • 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 GanosBase extension to version 4.9. For more information, see Spatio-temporal 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.

20220130

Compatible with PostgreSQL community version 12.8.

New features

20211130

Compatible with PostgreSQL community version 12.8.

  • New features

    • Upgrades the GanosBase extension to version 4.4. For more information, see Spatio-temporal 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.

  • New features

    Adds detection for EncDB SDK and EncJDBC versions in confidential databases.

  • Feature optimizations

    • Enables audit log optimization by default.

    • The GanosBase plugin is optimized, and the plugin description now identifies the GanosBase plugin and provides an upgrade method. For more information, see How to upgrade the spatio-temporal engine plugin.

  • Bug fixes

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

20210930

Compatible with PostgreSQL community version 12.8.

  • New features

    • Upgrades the GanosBase extension to version 4.1, adding and enhancing multiple functions. For more information, see Spatio-temporal 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 GanosBase 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 GanosBase 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 GanosBase 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 GanosBase 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 spatio-temporal in-memory topology index support to GanosBase.

    • Upgrades the GanosBase 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 GanosBase 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 GanosBase 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

    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 GanosBase extension to version 2.6.

  • Bug fixes

    Fixes some permission issues.

20191230

New features

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

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

PostgreSQL 11

Minor version

Description

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

    Upgrades the pg_hint_plan extension to version 1.3.9.

  • 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 GanosBase 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 features

    None

  • 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 GanosBase extension to version 4.9. For more information, see Spatio-temporal 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.

20220130

Compatible with PostgreSQL community version 11.13.

New features

20211130

Compatible with PostgreSQL community version 11.13.

  • New features

    • Upgrades the GanosBase extension to version 4.4. For more information, see Spatio-temporal 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.

  • New features

    Adds detection for EncDB SDK and EncJDBC versions in confidential databases.

  • Feature optimizations

    • Enables audit log optimization by default.

    • The GanosBase plugin is optimized, identifying the GanosBase plugin in the plugin description and providing an upgrade method. For more information, see How to upgrade the spatio-temporal engine plugin.

  • Bug fixes

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

20210930

Compatible with PostgreSQL community version 11.13.

  • New features

    • Upgrades the GanosBase extension to version 4.1, adding and enhancing multiple functions. For more information, see Spatio-temporal 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 GanosBase 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 GanosBase 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 GanosBase 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 GanosBase 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 spatio-temporal in-memory topology index support to GanosBase.

    • Upgrades the GanosBase 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 GanosBase 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 GanosBase extension to version 2.8.

  • Bug fixes

    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

  • 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 the community version 10.23.

  • New features

    None

  • Bug fixes

    Fixes known issues.

20230830

Compatible with PostgreSQL community version 10.23.

20230630

It is compatible with community version 10.23.

  • New features

    None

  • 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 the 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 GanosBase extension to version 4.9. For more information, see Spatio-temporal 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.

20220130

Compatible with PostgreSQL community version 10.19.

New features

20211130

Compatible with PostgreSQL community version 10.19.

  • New features

    • Upgrades the GanosBase extension to version 4.4. For more information, see Spatio-temporal 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.

  • New features

    Adds detection for EncDB SDK and EncJDBC versions in confidential databases.

  • Feature optimizations

    • Enables audit log optimization by default.

    • The GanosBase plugin is optimized. The plugin description now identifies the GanosBase plugin and provides an upgrade method. For more information, see How to upgrade the spatio-temporal engine plugin.

  • Bug fixes

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

20210930

Compatible with PostgreSQL community version 10.14.

  • New features

    • Upgrades the GanosBase extension to version 4.1, adding and enhancing multiple functions. For more information, see Spatio-temporal 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 GanosBase 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 GanosBase 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 GanosBase 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 spatio-temporal in-memory topology index support to GanosBase.

    • Upgrades the GanosBase 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 GanosBase 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 GanosBase extension to version 2.6.

  • Bug fixes

    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 optimizations

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.

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

    Fixes a memory exhaustion issue caused using the wal2json extension.

20200210

New features

Reserves 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.