All Products
Search
Document Center

ApsaraDB RDS:Versi minor kernel AliPG (PostgreSQL 9.4–13)

Last Updated:Mar 28, 2026

Topik ini berisi catatan rilis untuk kernel AliPG pada RDS for PostgreSQL versi 9.4 hingga 13.

Penting

PostgreSQL 13

Minor version

Description

20260130

Kompatibel dengan community 13.23.

  • New features

    None.

  • Bug fixes

    Resolved known issues.

20251130

Kompatibel dengan community 13.22.

20250830

Kompatibel dengan community 13.22.

20250630

Kompatibel dengan community 13.21.

  • New features

    None.

  • Bug fixes

    Resolved known issues.

20250430

Kompatibel dengan community 13.20.

20250228

Kompatibel dengan community 13.20.

  • New features

    None.

  • Bug fixes

    Resolved known issues.

20241230

Kompatibel dengan community 13.16.

  • New features

    • Upgraded the pg_hint_plan plugin to version 1.3.9.

    • Optimized the memory usage of the WALSender process for logical replication.

  • Bug fixes

    Resolved known issues.

20241030

Kompatibel dengan community 13.16.

20240830

Kompatibel dengan community 13.16.

  • New features

    Upgraded the encdb plugin to version 1.1.14.

  • Bug fixes

    Resolved known issues.

20240730

Kompatibel dengan community 13.15.

  • New features

    None.

  • Bug fixes

    Resolved known issues.

20240530

Kompatibel dengan community 13.14.

  • New features

  • Bug fixes

    Resolved known issues.

20240229

Kompatibel dengan community 13.14.

20231230

Kompatibel dengan community 13.13.

20231030

Kompatibel dengan community 13.12.

  • New features

    None.

  • Bug fixes

    Upgraded the GanosBase plugin to version 5.9, which resolves several known issues.

20230830

Kompatibel dengan community 13.12.

20230630

Kompatibel dengan community 13.9.

  • New features

    None.

  • Bug fixes

    Resolved known issues.

20230530

Kompatibel dengan community 13.9.

  • New features

  • Bug fixes

    Resolved an issue that prevented the profile database from connecting to the server database when using the pg_profile plugin.

20230430

Kompatibel dengan community 13.9.

20230330

Kompatibel dengan community 13.9.

  • New features

    None.

  • Bug fixes

    Resolved some known issues.

20230228

Kompatibel dengan community 13.9.

20221230

Kompatibel dengan community 13.9.

20221030

Kompatibel dengan community 13.8.

20220830

Kompatibel dengan community 13.7.

  • New features

    • Upgraded the encdb plugin to version 1.1.1.

    • Optimized the memory usage of the index_adviser plugin.

  • Bug fixes

    Resolved a memory out-of-bounds issue in the index_adviser plugin that occurred during complex queries.

20220730

Kompatibel dengan community 13.6.

  • New features

    • Upgraded the GanosBase plugin to version 4.9. For more information, see Ganos Engine Release Notes.

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

      • Added the ST_AddZ function to convert Geometry 2D/3DM objects to Geometry 3D/4D objects by using Z-coordinate arrays as parameters.

      • Enhanced the ST_SetValue function to support setting pixel values based on the spatial range of a specified Geometry object.

      • Enhanced the ST_ExportTo function to support exporting Raster objects as COG files.

      • Enhanced the ST_CreateRast function to support converting multiple records or arrays of regular grid points into Raster objects.

      • Enhanced the ST_Split function. When you split data by time, you can specify the start time. You can also split data based on the sequence numbers of trajectory points.

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

      • Added support for HDFS file systems for raster data.

    • Enhanced the pg_jieba plugin to support custom dictionaries, dictionary switching, and displaying word segmentation results with offsets for each field.

  • Bug fixes

    Resolved an issue that caused the index_adviser plugin to crash if all recommended indexes already existed.

20220228

Kompatibel dengan community 13.5.

  • New features

  • Bug fixes

    Resolved an issue where parameter values were missing from slow SQL logs.

20220130

Kompatibel dengan community 13.5.

New features

20211130

Kompatibel dengan community 13.5.

  • New features

    • Upgraded the GanosBase plugin to version 4.4. For more information, see Ganos Engine Release Notes.

    • Upgraded the PostGIS plugin to version 3.1.4.

    • Added support for the pg_jieba Chinese word segmentation plugin.

    • Added support for the pldebugger plugin for debugging stored procedures.

    • Added support for the timescaledb plugin 2.5.0.

    • Added support for setting the log_statement parameter at the session, user, and database levels.

  • Bug fixes

    • Resolved an issue where privileged accounts did not have permission to execute show shared_preload_libraries;.

    • Resolved an issue that incorrectly allowed standard accounts to execute pg_stat_reset().

20211031

Kompatibel dengan community 13.1.

  • New features

    The Encrypted Database feature now checks the versions of the EncDB SDK and EncJDBC.

  • Feature optimizations

    • Enabled optimized audit logs by default.

    • Optimized the GanosBase plugin. The plugin description now identifies GanosBase and provides upgrade instructions. For more information, see How do I upgrade the GanosBase plugin?.

  • Bug fixes

    Resolved an issue in the GanosBase plugin that caused an error if you used a function without first upgrading the plugin.

20210930

Kompatibel dengan community 13.1.

  • New features

    • Upgraded the GanosBase plugin to version 4.1. This release adds and enhances multiple functions. For more information, see Ganos Engine Release Notes.

    • Added the rdsutils plugin, which includes the failover_slots view.

    • Upgraded the rum plugin to version 1.3.8.

    • Upgraded the pglogical plugin to version 2.4.0.

    • Upgraded the plv8 plugin to version 2.3.15.

  • Feature optimizations

    • Upgraded GCC to 9.2 and glibc to 2.30. Enabled Link Time Optimization (LTO) for an overall performance increase of 5%.

    • Optimized audit logs. When the log_statement parameter is set to all, performance improves by approximately four times in high-concurrency scenarios where active connections are greater than 50 (active_conn > 50).

    • Changed the default value of the rds_failover_slot_mode parameter to async. This enables Logical Replication Slot Failover by default.

  • Bug fixes

    • Resolved a memory leak that could occur in some scenarios when using the mysql_fdw plugin.

    • Resolved a memory leak that could occur in some scenarios when using the pg_cron plugin.

20210531

Kompatibel dengan community 13.1.

  • New features

    • Upgraded the GanosBase plugin to version 3.8.

      • Added the ST_AsDatasetFile function, which returns a binary stream of raster objects within a specified range and in a specified file format.

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

      • Fixed an issue where the ST_Clip function failed to perform reprojection with a specified spatial reference.

    • Added support for the pglogical plugin, which provides logical stream replication, publishing, and subscription.

    • Added support for the pgAudit plugin to generate audit logs.

  • Feature optimizations

    • Optimized user permissions. When you run the GRANT role1 TO role2 command, role2 no longer inherits the CREATEDB and CREATEROLE permissions from role1.

      Penting

      Roles that were previously granted permissions by using the GRANT command can no longer use the CREATEDB and CREATEROLE permissions.

    • Privileged accounts can now use the pg_ls_waldir() function.

    • Optimized the monitoring and scanning method to improve CPU performance.

    • Optimized major version upgrade. This optimization supports smooth upgrades for plugins such as PostGIS and pgrouting, and allows seamless upgrades of account permissions from PostgreSQL 9.4 to later versions.

    • Increased the length limit for logs generated by an out-of-memory error or process crash from 1,024 bytes to 4,096 bytes.

  • Bug fixes

    Resolved a memory out-of-bounds issue that could occur in some scenarios when using the oss_fdw plugin.

20210331

Kompatibel dengan community 13.1.

  • New features

    • Upgraded the GanosBase plugin to version 3.7.

    • Added support for the pg_repack plugin to clear table spaces online and address table bloat.

    • Upgraded the mysql_fdw plugin to version 1.1.

    • The major version upgrade feature now supports seamless migration of user permissions, the mysql_fdw plugin, the oss_fdw plugin, and plugin permissions.

  • Bug fixes

    Resolved an issue where the oss_fdw plugin failed after a minor or major version upgrade.

20210228

Kompatibel dengan community 13.1.

  • New features

    • Upgraded the GanosBase plugin to version 3.6.

    • Added support for the decoderbufs plugin, which uses the Protocol Buffers protocol to output data compatible with the Debezium platform.

    • Added support for the pg_pathman high-performance partitioned table plugin.

    • Added support for the plv8 trusted JavaScript language extension plugin.

    • Added support for the oss_fdw plugin to read and write data in Object Storage Service (OSS).

    • Added support for the mysql_fdw plugin to read and write data in ApsaraDB RDS for MySQL instances or self-managed MySQL databases.

    • Privileged accounts can now create event triggers and configure the maximum length of logs.

  • Bug fixes

    • Resolved an issue that prevented slow log content from being displayed.

    • Granted privileged accounts permission to use custom dictionaries with the zhparser plugin.

    • Resolved an issue with incorrect archive_mode alerts in the logs.

20201230

Kompatibel dengan community 13.1.

  • New features

    • Indexes now support parallel vacuuming.

    • Added support for more data types from different data sources.

    • Improved partitioning to allow direct joins on partitioned tables, which reduces overall query execution time. Partitioned tables now also fully support row-level BEFORE triggers and logical replication.

    • More aggregate and grouping types can now use efficient hash aggregation, allowing queries with large aggregates to run without being fully loaded into memory.

    • Added support for the Logical Replication Slot Failover feature.

  • Performance optimizations

    Optimized indexing and lookup features to better suit large database systems.

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

PostgreSQL 12

Minor version

Description

20251130

Kompatibel dengan community version 12.20.

  • New features

    None.

  • Bug fixes

    Resolved known issues.

20250830

Kompatibel dengan community version 12.20.

20250630

Kompatibel dengan community version 12.20.

  • New features

    None.

  • Bug fixes

    Resolved known issues.

20250430

Kompatibel dengan community version 12.20.

  • New features

    None.

  • Bug fixes

    • Addressed a security vulnerability in the scheduled task (pg_cron) extension, restoring the ability to create it.

    • Resolved other known issues.

20250228

Kompatibel dengan community version 12.20.

  • New features

    None.

  • Bug fixes

    Resolved known issues.

20241230

Kompatibel dengan community version 12.20.

  • New features

    Upgraded the pg_hint_plan extension to version 1.3.9.

  • Bug fixes

    Resolved known issues.

20241030

Kompatibel dengan community version 12.20.

20240830

Kompatibel dengan community version 12.20.

  • New features

    Upgraded the encdb extension to version 1.1.14.

  • Bug fixes

    Resolved known issues.

20240730

Kompatibel dengan community version 12.19.

  • New features

    Upgraded the tds_fdw extension to version 2.0.3.

  • Bug fixes

    Resolved known issues.

20240530

Kompatibel dengan community version 12.18.

  • New features

  • Bug fixes

    Resolved known issues.

20240229

Kompatibel dengan community version 12.18.

20231230

Kompatibel dengan community version 12.17.

20231030

Kompatibel dengan community version 12.16.

  • New features

    None.

  • Bug fixes

    Upgraded the GanosBase extension to version 5.9 to resolve known issues.

20230830

Kompatibel dengan community version 12.16.

20230630

Kompatibel dengan community version 12.13.

  • New features

    None.

  • Bug fixes

    Resolved known issues.

20230530

Kompatibel dengan community version 12.13.

20230430

Kompatibel dengan community version 12.13.

20230330

Kompatibel dengan community version 12.13.

  • New features

    None.

  • Bug fixes

    Resolved some known issues.

20230228

Kompatibel dengan community version 12.13.

20221230

Kompatibel dengan community version 12.13.

20221030

Kompatibel dengan community version 12.12.

20220830

Kompatibel dengan community version 12.11.

  • New features

    • Upgraded the encdb extension to version 1.1.1.

    • Optimized the memory usage of the index_adviser extension.

  • Bug fixes

    Resolved a memory out-of-bounds issue in the index_adviser extension that occurred during complex queries.

20220730

Kompatibel dengan community version 12.8.

  • New features

    • Upgraded the GanosBase extension to version 4.9. For more information, see the Spatio-temporal Engine Release Notes.

      • Added the ST_Intersection aggregate function for aggregate operations on arrays of Geometry objects.

      • Added the ST_AddZ function to convert Geometry 2D/3DM objects to Geometry 3D/4D objects by using Z-coordinate arrays as parameters.

      • Enhanced the ST_SetValue function to support setting pixel values based on the spatial range of a specified geometry object.

      • Enhanced the ST_ExportTo function to support exporting Raster objects as COG files.

      • Enhanced the ST_CreateRast function to support converting multiple records or arrays of regular grid points into Raster objects.

      • Enhanced the ST_Split function. When you split data by time, you can specify the start time. You can also split data based on the sequence numbers of trajectory points.

      • Enhanced the ST_Union function to execute in batches based on memory usage, preventing out-of-memory (OOM) errors from large data volumes.

      • Added support for HDFS file systems for raster data.

    • Enhanced the pg_jieba extension to support custom dictionaries, dictionary switching, and displaying word segmentation results with offsets for each field.

  • Bug fixes

    Resolved an issue where the index_adviser extension would crash if all recommended indexes already existed.

20220228

Kompatibel dengan community version 12.8.

  • New features

  • Bug fixes

    Resolved an issue where parameter values were missing in slow SQL logs.

20220130

Kompatibel dengan community version 12.8.

New features

20211130

Kompatibel dengan community version 12.8.

  • New features

    • Upgraded the GanosBase extension to version 4.4. For more information, see the Spatio-temporal Engine Release Notes.

    • Upgraded the PostGIS extension to version 3.1.4.

    • Added the pg_jieba Chinese word segmentation extension.

    • Added the pldebugger extension for debugging stored procedures.

    • You can now set the log_statement parameter at the session, user, and database levels.

  • Bug fixes

    • Resolved a memory leak that occurred when viewing task logs (cron.job_log) with the pg_cron extension.

    • Resolved a permission issue that prevented high-privilege accounts from running show shared_preload_libraries;.

    • Corrected a permission issue that incorrectly allowed standard accounts to run pg_stat_reset().

20211031

Kompatibel dengan community version 12.8.

  • New features

    The fully encrypted database feature now includes version checks for the EncDB SDK and EncJDBC.

  • Enhancements

    • Optimized audit logs are now enabled by default.

    • Optimized the GanosBase extension. The extension description now identifies the GanosBase extension and provides upgrade instructions. For more information, see How to upgrade the spatio-temporal engine extension.

  • Bug fixes

    Resolved an issue with the GanosBase extension where using a function without upgrading the extension caused an error.

20210930

Kompatibel dengan community version 12.8.

  • New features

    • Upgraded the GanosBase extension to version 4.1. Multiple functions are added and enhanced. For more information, see the Spatio-temporal Engine Release Notes.

    • Added the rdsutils extension, which includes the failove_slots view.

    • Upgraded the rum extension to version 1.3.8.

    • Upgraded the pg_pathman extension to version 1.5.12.

    • Upgraded the pglogical extension to version 2.4.0.

    • Upgraded the plv8 extension to version 2.3.15.

    • Upgraded the rdkit extension to version 2020_09_05.

  • Enhancements

    • Upgraded GCC to 9.2 and glibc to 2.30, and enabled Link Time Optimization (LTO), resulting in an overall performance increase of approximately 5%.

    • Optimized audit logs. When the log_statement parameter is set to all, performance is improved by approximately four times in high-concurrency scenarios where active_conn is greater than 50.

    • Enabled Logical Replication Slot Failover by default by changing the default value of the rds_failover_slot_mode parameter to async.

  • Bug fixes

    • Resolved a bug in TimescaleDB where system table metadata was lost after a VACUUM FULL pg_catalog.pg_attribute operation.

    • Resolved a memory leak that occurred in some scenarios when the mysql_fdw extension was used.

    • Resolved a memory leak that occurred in some scenarios when the pg_cron extension was used.

20210531

Kompatibel dengan community version 12.4.

  • New features

    • Upgraded the GanosBase extension to version 3.8.

      • Added the ST_AsDatasetFile function to return a binary stream of raster objects within a specified range and in a specified file format.

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

      • Resolved an issue where the ST_Clip function failed to perform reprojection with a specified spatial reference.

    • Added the pglogical extension, which provides features for logical streaming replication, publication, and subscription.

    • Added the pgAudit extension, which provides audit logging capabilities.

  • Enhancements

    • Optimized user permissions. When you run the GRANT role1 TO role2 command, role2 no longer inherits the CREATEDB and CREATEROLE permissions from role1.

      Penting

      Roles that were granted permissions by using the GRANT command can no longer use the CREATEDB and CREATEROLE permissions.

    • Removed usage restrictions on the pg_ls_waldir() function for high-privilege accounts.

    • Optimized the monitoring and scanning method to improve CPU performance.

    • Optimized major version upgrade. This optimization supports smooth upgrades for extensions such as PostGIS and pgrouting, and also supports smooth upgrades of account permissions from PostgreSQL 9.4 to later versions.

    • Increased the length limit for logs generated by an out-of-memory error or a process crash from 1,024 bytes to 4,096 bytes.

  • Bug fixes

    Resolved a memory out-of-bounds issue that occurred in some scenarios when the oss_fdw extension was used.

20210331

Kompatibel dengan community version 12.4.

  • New features

    • Upgraded the GanosBase extension to version 3.7.

    • Added the pg_repack extension to reclaim space online and resolve table bloat.

    • Upgraded the mysql_fdw extension to version 1.1.

    • The major version upgrade feature now supports seamless migration of user permissions, the mysql_fdw extension, the oss_fdw extension, and extension permissions.

  • Bug fixes

    Resolved an issue where the oss_fdw extension failed to work after a minor or major version upgrade.

20210228

Kompatibel dengan community version 12.4.

  • New features

    • Upgraded the GanosBase extension to version 3.6.

    • Added the decoderbufs extension, which outputs data compatible with the Debezium platform based on the Protocol Buffers protocol.

    • Added the pg_pathman high-performance partitioning extension.

    • Added the plv8 trusted JavaScript language extension.

    • Added the oss_fdw extension, which allows you to read data from and write data to OSS.

  • Bug fixes

    • Resolved an issue where high-privilege accounts did not have permission to use custom dictionaries for the zhparser extension.

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

20201230

Kompatibel dengan community version 12.4.

  • New features

    • Upgraded the GanosBase extension to version 3.3.

    • Added the pg_hint_plan extension, which allows you to modify PostgreSQL execution plans by using special comment hints.

    • Added the zhparser extension.

    • Added the RUM extension for high-speed full-text search.

    • Added the bloom extension.

    • Added support for Logical Replication Slot Failover.

  • Bug fixes

    Resolved a kernel issue caused by a conflict between tds_fdw and plancache.

20201130

Kompatibel dengan community version 12.4.

  • New features

    • High-privilege accounts can now create accounts with the REPLICATION privilege.

    • High-privilege accounts can now create event triggers.

    • You can now configure the maximum length of audit logs (rds_auditlog_max_query_length).

    • Upgraded the pg_cron extension. You can now create and run cross-database jobs and view job execution records in the cron.job_log table.

    • Added the pg_freespacemap extension.

    • GanosBase now supports in-memory spatio-temporal topological indexes.

    • Upgraded the GanosBase extension to version 3.2.

  • Bug fixes

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

    • Addressed the community security vulnerability CVE-2020-14349 (search path not properly cleaned during logical replication).

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

    • Addressed the community security vulnerability CVE-2020-25695 (allowed creation of non-temporary objects and execution of arbitrary SQL functions as a superuser).

20200830

Kompatibel dengan community version 12.2.

  • New features

    • Upgraded the GanosBase extension to version 3.0.

    • Added the SQL firewall extension to prevent malicious SQL injection.

    • Added the bigm extension for fuzzy searches.

  • Bug fixes

    • Resolved an error where a background parameter with the rds_ prefix was not recognized.

    • Resolved an error where the pg_cron extension could not be created or used as expected.

    • Bundled several dependencies for the RDKit extension to fix a loading error caused by missing dependencies.

20200421

Kompatibel dengan community version 12.2.

  • New features

    • Upgraded the GanosBase extension to version 2.7.

    • Now supports the hll extension, version 2.14.

    • Now supports the plproxy extension, version 2.9.0.

    • Now supports the tsm_system_rows extension, version 1.0.

    • Now supports the tsm_system_time extension, version 1.0.

    • Now supports the smlar extension, version 1.0.

    • Now supports the tds_fdw extension, version 1.0.

  • Bug fixes

    Resolved an instance restart issue caused by a logical subscription timeout.

20200221

  • New features

    • Added support for reserving connections for the rds_superuser role. This feature ensures that you can connect to the instance for troubleshooting even when connection slots are exhausted.

    • Now supports the wal2json extension.

    • Upgraded the GanosBase extension to version 2.6.

  • Bug fixes

    Resolved some permission issues.

20191230

New features

PostgreSQL 11

Minor version

Description

20250630

Kompatibel dengan community version 11.22.

  • New features

    None.

  • Bug fixes

    Fixed known issues.

20250430

Kompatibel dengan community version 11.22.

  • New features

    None.

  • Bug fixes

    • Fixed a security vulnerability in the pg_cron plugin and re-enabled creation of the plugin.

    • Fixed other known issues.

20250228

Kompatibel dengan community version 11.22.

  • New features

    None.

  • Bug fixes

    Fixed known issues.

20241230

Kompatibel dengan community version 11.22.

  • New features

    Upgraded the pg_hint_plan plugin to version 1.3.9.

  • Bug fixes

    Fixed known issues.

20241030

Kompatibel dengan community version 11.22.

  • Bug fixes

    Fixed known issues.

20240830

Kompatibel dengan community version 11.22.

  • New features

    Upgraded the encdb plugin to version 1.1.14.

  • Bug fixes

    Fixed known issues.

20240730

Kompatibel dengan community version 11.22.

  • New features

    Upgraded the tds_fdw plugin to version 2.0.3.

  • Bug fixes

    Fixed known issues.

20240530

Kompatibel dengan community version 11.22.

  • New features

  • Bug fixes

    Fixed known issues.

20240229

Kompatibel dengan community version 11.22.

20231230

Kompatibel dengan community version 11.22.

20231030

Kompatibel dengan community version 11.21.

  • New features

    None.

  • Bug fixes

    Upgraded the GanosBase plugin to version 5.9 to fix known issues.

20230830

Kompatibel dengan community version 11.21.

20230630

Kompatibel dengan community version 11.18.

  • New features

    None.

  • Bug fixes

    Fixed known issues.

20230530

Kompatibel dengan community version 11.18.

  • New features

    Upgraded the GanosBase plugin to version 5.6. For more information, see the Ganos release notes.

  • Bug fixes

    Fixed a connection failure between the profile and server databases when using the pg_profile plugin.

20230430

Kompatibel dengan community version 11.18.

20230330

Kompatibel dengan community version 11.18.

  • New features

    None.

  • Bug fixes

    Fixed known issues.

20221230

Kompatibel dengan community version 11.18.

  • New features

  • Bug fixes

    None.

20221030

Kompatibel dengan community version 11.17.

20220830

Kompatibel dengan community version 11.16.

  • New features

    • Upgraded the encdb plugin to version 1.1.1.

    • Optimized the memory usage of the index_adviser plugin.

  • Bug fixes

    Fixed a memory out-of-bounds issue in the index_adviser plugin during complex queries.

20220730

Kompatibel dengan community version 11.13.

  • New features

    • Upgraded the GanosBase plugin to version 4.9. For more information, see the Ganos release notes.

      • Added the ST_Intersection aggregate function to support aggregate operations on arrays of Geometry objects.

      • Added the ST_AddZ function to convert Geometry 2D/3DM objects to Geometry 3D/4D objects by using Z-coordinate arrays as parameters.

      • Enhanced the ST_SetValue function to set pixel values based on the spatial range of a specified geometry object.

      • Enhanced the ST_ExportTo function to support exporting raster objects as COG files.

      • Enhanced the ST_CreateRast function to support converting multiple records or arrays of regular grid points into raster objects.

      • Enhanced the ST_Split function to support splitting data by a specified start time or by trajectory point sequence numbers.

      • Enhanced the ST_Union function to execute in batches based on memory usage, preventing out-of-memory (OOM) errors when processing large data volumes.

      • Added support for HDFS file systems for raster data.

    • Enhanced the pg_jieba plugin to support custom dictionaries, dictionary switching, and displaying word segmentation results with offsets for each field.

  • Bug fixes

    Fixed an issue where the index_adviser plugin would crash if all recommended indexes already existed.

20220228

Kompatibel dengan community version 11.13.

  • New features

    • Added support for the sequential-uuids plugin, version 1.0.2.

    • Upgraded the encdb plugin to version 1.1.9.

    • Upgraded the GanosBase plugin to version 4.6. For more information, see the Ganos release notes.

    • Standard accounts can now run the LOAD command to load the index_adviser and pg_hint_plan plugins.

    • Privileged accounts can now configure the BYPASSRLS parameter with the CREATE ROLE command.

  • Bug fixes

    Fixed an issue where parameter values were missing in slow SQL logs.

20220130

Kompatibel dengan community version 11.13.

New features

20211130

Kompatibel dengan community version 11.13.

  • New features

    • Upgraded the GanosBase plugin to version 4.4. For more information, see the Ganos release notes.

    • Upgraded the postgis plugin to version 3.1.4.

    • Added support for the pg_jieba Chinese word segmentation plugin.

    • Added support for the pldebugger plugin for debugging stored procedures.

    • Added support for setting the log_statement parameter at the session, user, and database levels.

  • Bug fixes

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

    • Fixed an issue where privileged accounts did not have the permission to run show shared_preload_libraries;.

    • Fixed a permission issue that incorrectly allowed standard accounts to run pg_stat_reset().

20211031

Kompatibel dengan community version 11.13.

  • New features

    The fully encrypted database feature now includes version checks for the EncDB SDK and EncJDBC.

  • Enhancements

  • Bug fixes

    Fixed an issue in the GanosBase plugin where an error was reported when you used functions of the plugin before it was upgraded.

20210930

Kompatibel dengan community version 11.13.

  • New features

    • Upgraded the GanosBase plugin to version 4.1, which adds and enhances multiple functions. For more information, see the Ganos release notes.

    • Added the rdsutils plugin, which includes the failover_slots view.

    • Upgraded the rum plugin to version 1.3.8.

    • Upgraded the pg_pathman plugin to version 1.5.12.

    • Upgraded the pglogical plugin to version 2.4.0.

    • Upgraded the plv8 plugin to version 2.3.15.

  • Enhancements

    • Upgraded GCC to 9.2 and glibc to 2.30. Enabled Link Time Optimization (LTO) for an overall performance increase of 5%.

    • Optimized audit logs. When the log_statement parameter is set to all, performance is improved by approximately four times in high-concurrency scenarios where active_conn is greater than 50.

    • Changed the default value of the rds_failover_slot_mode parameter to async. This means that logical replication slot failover is enabled by default.

    • Optimized logging to suppress the incomplete startup packet log triggered by empty packets.

  • Bug fixes

    • Fixed a memory leak that occurred in some scenarios when the mysql_fdw plugin was used.

    • Fixed a memory leak that occurred in some scenarios when the pg_cron plugin was used.

20210531

Kompatibel dengan community version 11.9.

  • New features

    • Upgraded the GanosBase plugin to version 3.8.

      • Added the ST_AsDatasetFile function. It returns a binary stream of raster objects within a specified range and in a specified file format.

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

      • Fixed an issue where the ST_Clip function failed to perform reprojection with a specified spatial reference.

    • Added support for the pglogical plugin, which provides logical stream replication, publishing, and subscription.

    • Added support for the pgAudit plugin to generate audit logs.

    • Added support for the fully encrypted database feature, which encrypts data on the client side to protect it against security threats from both within and outside the cloud platform.

  • Enhancements

    • Optimized user permissions. When you run the GRANT role1 TO role2 command, role2 no longer inherits the CREATEDB and CREATEROLE permissions from role1.

      Penting

      Roles that previously inherited the CREATEDB and CREATEROLE permissions via the GRANT command can no longer use them.

    • Privileged accounts can now use the pg_ls_waldir() function.

    • Optimized the monitoring and scanning method to improve CPU performance.

    • Optimized major version upgrade to provide smoother migration for plugins like postgis and pgrouting, and for account permissions from PostgreSQL 9.4 or later versions.

    • Increased the length limit for logs generated when an SQL statement causes an OOM error or a process crash from 1,024 bytes to 4,096 bytes.

  • Bug fixes

    • Fixed an index out-of-bounds issue in the PASE index plugin.

    • Fixed a memory out-of-bounds issue that occurred in some scenarios when the oss_fdw plugin was used.

20210331

Kompatibel dengan community version 11.9.

  • New features

    • Upgraded the GanosBase plugin to version 3.7.

    • Added support for the pg_repack plugin for online space reclamation to resolve table bloat.

    • Upgraded the mysql_fdw plugin to version 1.1.

    • The major version upgrade feature now supports seamless migration of user permissions, the mysql_fdw plugin, the oss_fdw plugin, and plugin permissions.

  • Bug fixes

    Fixed an issue where the oss_fdw plugin failed after a minor or major version upgrade.

20210228

Kompatibel dengan community version 11.9.

  • New features

    • Upgraded the GanosBase plugin to version 3.6.

    • Added support for the mysql_fdw plugin, which allows you to read and write data in ApsaraDB RDS for MySQL instances or self-managed MySQL databases.

  • Bug fixes

    Fixed an online alert issue related to archive_mode in logs.

20201230

Kompatibel dengan community version 11.9.

  • New features

    • Upgraded the GanosBase plugin to version 3.3.

    • Added support for the pg_hint_plan plugin, which allows you to change PostgreSQL execution plans by using special comment hints.

    • Added support for the bloom plugin.

  • Bug fixes

    • Optimized the logical replication slot failover feature to prevent data loss in synchronous mode, even in extreme conditions.

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

20201130

Kompatibel dengan community version 11.9.

  • New features

    • Privileged accounts can now create accounts with the REPLICATION privilege.

    • Privileged accounts can now create event triggers.

    • Added support for configuring the maximum length of audit logs (rds_auditlog_max_query_length).

    • Upgraded the pg_cron plugin. You can now create and run cross-database tasks and view task history in the cron.job_log table.

    • Added support for the pg_freespacemap plugin.

    • GanosBase now supports in-memory spatio-temporal topological indexes.

    • Upgraded the GanosBase plugin to version 3.2.

  • Bug fixes

    • Fixed a validation exception caused by the opening or committing of multiple sub-transactions during DTS migration.

    • Fixed the community security vulnerability CVE-2020-14349 (search path not properly cleaned during logical replication).

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

    • Fixed the community security vulnerability CVE-2020-25695 (creation of non-temporary objects and execution of arbitrary SQL functions as a superuser).

20200830

  • New features

    • Upgraded the GanosBase plugin to version 3.0.

    • Added support for the SQL Firewall plugin to prevent malicious SQL injection.

    • Added support for the bigm plugin for fuzzy search.

    • Added support for the ZomboDB plugin for text search and analysis.

  • Bug fixes

    • Fixed an error where a backend parameter with the rds_ prefix was not recognized.

    • Fixed an error where a failover slot with a duplicate replication slot name caused the standby instance to crash.

    • Fixed an error where the pg_cron plugin could not be created and used properly.

    • Fixed a correctness error in the PASE plugin caused by a global variable.

20200610

New features

  • Allowed privileged accounts to use the pageinspect plugin.

  • Allowed privileged accounts to grant the REPLICATION privilege to other users.

20200511

  • New features

    Upgraded the GanosBase plugin to version 2.8.

  • Bug fixes

    Fixed slow insert operations on HNSW indexes in the PASE plugin.

20200421

New features

  • Added support for the logical replication slot failover feature.

  • Added support for the plproxy plugin, version 2.9.0.

  • Added support for the tsm_system_rows plugin, version 1.0.

  • Added support for the tsm_system_time plugin, version 1.0.

  • Added support for the smlar plugin, version 1.0.

20200402

  • New features

    • Added support for the hll plugin (version 2.14). This plugin provides the hll data type for high-performance, low-cost approximate analysis. It is ideal for use cases that require millisecond-level responses, such as real-time PV/UV queries and feature tag containment checks.

    • Added support for the oss_fdw plugin (version 1.1). This plugin enables you to use OSS as an external storage solution for your database. You can offload infrequently queried historical data to OSS to reduce storage costs while still allowing for low-frequency queries.

    • Added support for the tds_fdw plugin (version 2.0.1). This allows you to query data from Sybase and SQL Server in real time directly from your PostgreSQL database without needing an ETL process, enabling cross-database queries and data migration.

  • Plugin upgrades

    • Upgraded the GanosBase plugin to version 2.7.

    • Upgraded the wal2json plugin to version 2.2.

  • Performance optimizations

    Optimized the shutdown -m fast command.

20191218

New features

  • Added support for the PASE index plugin for image recognition indexing.

  • Privileged accounts can now publish all tables and create subscriptions at once.

PostgreSQL 10

Minor version

Description

20231230

Kompatibel dengan community version 10.23.

  • New features

    None.

  • Bug fixes

    Fixed known issues.

20230830

Kompatibel dengan community version 10.23.

20230630

Kompatibel dengan community version 10.23.

  • New features

    None.

  • Bug fixes

    Fixed known issues.

20230430

Kompatibel dengan community version 10.23.

20230330

Kompatibel dengan community version 10.23.

  • New features

    None.

  • Bug fixes

    Fixed known issues.

20221230

Kompatibel dengan community version 10.23.

20221030

Kompatibel dengan community version 10.22.

20220830

Kompatibel dengan community version 10.21.

  • New features

    • Upgraded the encdb plugin to version 1.1.1.

    • Optimized the memory usage of the index_adviser plugin.

  • Bug fixes

    Fixed a memory out-of-bounds issue in the index_adviser plugin during complex queries.

20220730

Kompatibel dengan community version 10.19.

  • New features

    • Upgraded the GanosBase plugin to version 4.9. For more information, see Spatiotemporal Engine Release Notes.

      • Added the ST_Intersection aggregate function to support aggregate operations on arrays of Geometry objects.

      • Added the ST_AddZ function to convert Geometry 2D/3D objects to Geometry3D/4D objects by using Z-coordinate arrays as parameters.

      • Enhanced the ST_SetValue function to support setting pixel values based on the spatial range of a specified geometry object.

      • Enhanced the ST_ExportTo function to support exporting Raster objects as COG files.

      • Enhanced the ST_CreateRast function to support converting multiple records or arrays of regular grid points into raster objects.

      • Enhanced the ST_Split function. When you split data by time, you can specify the start time. You can also split data based on the sequence numbers of trajectory points.

      • Enhanced the ST_Union function to execute in batches based on memory usage, which prevents out-of-memory (OOM) errors caused by large data volumes.

      • Added HDFS support for raster data.

    • Enhanced the pg_jieba plugin to support custom dictionaries, dictionary switching, and displaying word segmentation results with offsets for each field.

  • Bug fixes

    • Fixed an issue where the index_adviser plugin would crash if all recommended indexes already existed.

    • High-privilege accounts can now run the CREATE PUBLICATION xxx FOR ALL TABLES; command.

20****28

Kompatibel dengan community version 10.19.

  • New features

  • Bug fixes

    Fixed an issue where parameter values were missing in slow SQL logs.

20220130

Kompatibel dengan community version 10.19.

New features

20211130

Kompatibel dengan community version 10.19.

  • New features

    • Upgraded the GanosBase plugin to version 4.4. For more information, see Spatiotemporal Engine Release Notes.

    • Upgraded the PostGIS plugin to version 3.1.4.

    • Added support for the pg_jieba Chinese word segmentation plugin.

    • Added support for the pldebugger plugin to debug stored procedures.

    • Added support for setting the log_statement parameter at the session, user, and database levels.

  • Bug fixes

    • Fixed a memory leak that occurred when you view task logs (cron.job_log) by using the pg_cron plugin.

    • Removed permission for standard accounts to run pg_stat_reset().

20211031

Kompatibel dengan community version 10.14.

  • New features

    The fully encrypted database feature now includes version checks for the EncDB SDK and EncJDBC.

  • Enhancements

    • Optimized audit logs are now enabled by default.

    • GanosBase plugin optimization: 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

    Fixed errors that occurred when using functions from an un-upgraded GanosBase plugin.

20210930

Kompatibel dengan community version 10.14.

  • New features

    • Upgraded the GanosBase plugin to version 4.1. For more information, see Spatiotemporal Engine Release Notes.

    • Added the rdsutils plugin, which includes the failover_slots view.

    • Upgraded the rum plugin to version 1.3.8.

    • Upgraded the pglogical plugin to version 2.4.0.

    • Upgraded the plv8 plugin to version 2.3.15.

  • Enhancements

    • Upgraded GCC to 9.2 and glibc to 2.30. Enabled Link Time Optimization (LTO) for an overall performance increase of 5%.

    • Optimized audit logs. When the log_statement parameter is set to all, performance is improved by approximately four times in high-concurrency scenarios where active_conn is greater than 50.

    • The default value of the rds_failover_slot_mode parameter is changed to async. This means that logical replication slot failover is enabled by default.

    • Optimized logging to prevent incomplete startup packet messages from being recorded for empty packets.

  • Bug fixes

    • Fixed a memory leak in the mysql_fdw plugin in some scenarios.

    • Fixed a memory leak in the pg_cron plugin in some scenarios.

20210531

Kompatibel dengan community version 10.14.

  • New features

    • Upgraded the GanosBase plugin to version 3.8.

      • Added the ST_AsDatasetFile function. It returns a binary stream of raster objects within a specified range and in a specified file format.

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

      • Fixed an issue where the ST_Clip function failed to perform reprojection with a specified spatial reference.

    • Added support for the pglogical plugin, which provides publish/subscribe capabilities for logical streaming replication.

    • Added support for the pgAudit plugin to enhance audit logging.

  • Enhancements

    • Changed user permission inheritance. When you run the GRANT role1 TO role2 command, role2 no longer inherits the CREATEDB and CREATEROLE permissions from role1.

      Penting

      Roles that were previously granted permissions by using the GRANT command can no longer use the CREATEDB and CREATEROLE permissions.

    • High-privilege accounts can now use the pg_ls_waldir() function.

    • Optimized the monitoring and scanning method to improve CPU performance.

    • Major version upgrade optimization. This feature supports smooth upgrades for extensions such as postgis and pgrouting, and for account permissions from PostgreSQL 9.4 to higher versions.

    • The length limit for logs generated when an SQL statement causes an OOM error or a process crash is increased from 1,024 bytes to 4,096 bytes.

  • Bug fixes

    Fixed a memory out-of-bounds issue that occurred in the oss_fdw plugin in some scenarios.

20210331

Kompatibel dengan community version 10.14.

  • New features

    • Upgraded the GanosBase plugin to version 3.7.

    • Added support for the pg_repack plugin to reclaim space from tables online and resolve table bloat issues.

    • The mysql_fdw plugin now supports PostgreSQL 10.

    • Upgraded the mysql_fdw plugin to version 1.1.

    • The major version upgrade feature now supports migrating user permissions, the mysql_fdw plugin, the oss_fdw plugin, and plugin permissions.

  • Bug fixes

    Fixed an issue where the oss_fdw plugin failed after a minor or major version upgrade.

20210228

Kompatibel dengan community version 10.14.

  • New features

    Upgraded the GanosBase plugin to version 3.6.

  • Bug fixes

    Fixed an issue that caused erroneous archive_mode alerts in logs.

20201230

Kompatibel dengan community version 10.14.

New features

20201130

Kompatibel dengan community version 10.14.

  • New features

    • High-privilege accounts can now create accounts with the REPLICATION permission.

    • High-privilege accounts can now create event triggers.

    • Added support for configuring the maximum length of audit logs (rds_auditlog_max_query_length).

    • Upgraded the pg_cron plugin. You can now create and run cross-database jobs and view job history in the cron.job_log table.

    • Added support for the pg_freespacemap plugin.

    • The GanosBase spatiotemporal engine now supports in-memory topology indexes.

    • Upgraded the GanosBase plugin to version 3.2.

  • Bug fixes

    • Fixed an exception during DTS migration caused by opening or committing multiple sub-transactions.

    • Fixed the community security vulnerability CVE-2020-14349, where the search path was not properly cleaned during logical replication.

    • Fixed the community security vulnerability CVE-2020-14350, related to an uncontrolled search path element in CREATE EXTENSION.

    • Fixed the community security vulnerability CVE-2020-25695, which allowed creating non-temporary objects and executing arbitrary SQL functions as a superuser.

20200830

Kompatibel dengan community version 10.9.

  • New features

    • Upgraded the GanosBase plugin to version 3.0.

    • Added support for the SQL firewall plugin to prevent malicious SQL injection.

    • Added support for the bigm plugin for fuzzy search.

  • Bug fixes

    Fixed an issue that prevented the pg_cron plugin from being created and used.

20200212

Kompatibel dengan community version 10.9.

  • New features

    • Added support for reserving a specified number of connections for the rds_superuser role. This ensures that you can connect to the instance for troubleshooting even when connection slots are exhausted.

    • Upgraded the GanosBase plugin to version 2.6.

  • Bug fixes

    Reduced long wait times in streaming replication.

20190703

Kompatibel dengan community version 10.9.

  • New features

    • Upgraded the kernel to version 10.9.

    • Synchronous replication now switches to asynchronous replication on timeout.

  • Bug fixes

    • Fixed an error with make pg_hint_plan.

PostgreSQL 9.4

Minor version

Description

20210531

Enhancements

Improved the major version upgrade feature to support seamless upgrades for plugins, such as PostGIS and pgRouting, and smooth migration of account permissions from PostgreSQL 9.4 to later versions.

20201130

Bug fixes

  • Fixed community security vulnerability CVE-2020-25694, where security parameters could be lost when switching connections, potentially allowing an attack.

  • Fixed community security vulnerability CVE-2020-25695, which allowed the creation of non-temporary objects and the execution of arbitrary SQL functions as a superuser.

  • Fixed community security vulnerability CVE-2020-25696, where psql's \gset could allow overwriting of specially crafted variables.

20200623

  • New features

    • Upgraded wal2json to version 2.2.

    • Added support for the xml2 plugin version 1.0.

  • Bug fixes

    Fixed an out-of-memory issue caused by the wal2json plugin.

20200210

New feature

Added the ability to reserve a specified number of connections for the rds_superuser role, which allows you to connect to the instance for troubleshooting even when connection slots are exhausted.

20190601

Upgraded to version 9.4.19.