Release notes for AliPG - ApsaraDB RDS - Alibaba Cloud Documentation Center

This topic describes the release notes for AliPG and provides links to the relevant references.

If you want to use the features that are provided by a later AliPG version, you must update the AliPG version of your ApsaraDB RDS instance to that later AliPG version. For more information, see Update the minor engine version of an ApsaraDB RDS for PostgreSQL instance.

PostgreSQL 15

AliPG version	Description
20230730	PostgreSQL 15.1 is supported. New features: None Bug fixes: Known issues are fixed.
20230630	PostgreSQL 15.1 is supported. New features: A new feature that allows you to specify whether to use default dictionaries during searches is supported for the pg_jieba extension. Bug fixes: None
20230530	PostgreSQL 15.1 is supported. New features: Version 4.7.3 of the pg_partman extension is supported. The pg_cron extension is updated to version 1.5. The extensions of Ganos are updated to version 5.6. For more information, see Release notes for Ganos. Bug fixes: The bug due to which the profile database fails to connect to the server database when the pg_profile extension is used is fixed.
20230430	PostgreSQL 15.1 is supported. New features: ICU collations are supported. Version 0.4.1 of the pgvector extension is supported. The rds_ccl extension is updated to version 1.1. The extensions of Ganos are updated to version 5.5. For more information, see Release notes for Ganos. Bug fixes: The bug due to which the DROP DATABASE statement fails to be executed when the pg_cron and pglogical extensions are used is fixed.
20230330	PostgreSQL 15.1 is supported. New features: Version 1.0 of the rds_ccl self-developed extension is supported. You can use this extension for SQL throttling. Bug fixes: The bug that audit logs and slow query logs cannot be collected due to abnormal output locations is fixed. Other known issues are fixed.
20230228	PostgreSQL 15.1 is supported. New features: Version 2.9.2 of the TimescaleDB extension is supported. Version 1.5 of the pg_hint_plan extension is supported. Version 2.4 of the ip4r extension is supported. Version 2.1 of the pgl_ddl_deploy extension is supported. The extensions of Ganos are updated to version 5.4. For more information, see Release notes for Ganos. The pgRouting extension is updated to version 3.4.2. Bug fixes: None
20221230	PostgreSQL 15.1 is supported. New features: Version 0.0.1 of the PASE extension is supported. The extensions of Ganos are updated to version 5.3. For more information, see Release notes for Ganos. Bug fixes: None
20221030	PostgreSQL 15.1 is supported. This is the initial release. For more information about the supported features, see Features. For more information about the supported extensions, see Supported extensions.

PostgreSQL 14

AliPG version	Description
20230630	PostgreSQL 14.6 is supported. New features: A new feature that allows you to specify whether to use default dictionaries during searches is supported for the pg_jieba extension. Bug fixes: None
20230530	PostgreSQL 14.6 is supported. New features: Version 4.7.3 of the pg_partman extension is supported. The pg_cron extension is updated to version 1.5. The extensions of Ganos are updated to version 5.6. For more information, see Release notes for Ganos. Bug fixes: The bug due to which the profile database fails to connect to the server database when the pg_profile extension is used is fixed.
20230430	PostgreSQL 14.6 is supported. New features: ICU collations are supported. Version 0.4.1 of the pgvector extension is supported. The rds_ccl extension is updated to version 1.1. The extensions of Ganos are updated to version 5.5. For more information, see Release notes for Ganos. Bug fixes: The bug due to which out of memory (OOM) errors occur when the pg_jieba extension loads super-large dictionaries is fixed.
20230330	PostgreSQL 14.6 is supported. New features: Version 1.0 of the rds_ccl self-developed extension is supported. You can use this extension for SQL throttling. The TimescaleDB extension is updated to version 2.9.2. Bug fixes: Specific known issues are fixed.
20230228	PostgreSQL 14.6 is supported. New features: The extensions of Ganos are updated to version 5.4. For more information, see Release notes for Ganos. Version 2.4 of the ip4r extension is supported. Version 2.1 of the pgl_ddl_deploy extension is supported. The pgRouting extension is updated to version 3.4.2. The pglogical extension is updated to version 2.4.2. Bug fixes: None
20221230	PostgreSQL 14.6 is supported. New features: The extensions of Ganos are updated to version 5.3. For more information, see Release notes for Ganos. Version 0.0.1 of the PASE extension is supported. The PostGIS extension is updated to version 3.3.2. The EncDB extension is updated to version 1.1.12. Bug fixes: None
20221030	PostgreSQL 14.5 is supported. New features: The extensions of Ganos are updated to version 5.1. For more information, see Release notes for Ganos. The TDE feature is supported to achieve table-level transparent data encryption. Version 1.0 of the rds_tde_utils extension is supported. Version 4.1 of the pg_profile extension is supported. Version 2.2.1 of the pg_stat_kcache extension is supported. Version 1.1 of the mysql_fdw extension is supported. Version 1.4.7 of the pg_repack extension is supported. Version 1.0 of the zhparser extension is supported. Version 1.3 of the rum extension is supported. Version 2.3.15 of the plv8 extension is supported. Version 1.4.0 of the pg_hint_plan extension is supported. Version 2.0.3 of the tds_fdw extension is supported. Bug fixes: None
20220830	PostgreSQL 14.4 is supported. New features: The EncDB extension is updated to version 1.1.1. Version 1.1 of the oss_fdw extension is supported. Version 2.5.0 of the TimescaleDB extension is supported. The memory usage of the index_adviser extension is optimized. Bug fixes: The bug due to which the index_adviser extension accesses memory out of bounds in complex queries is fixed.
20220730	PostgreSQL 14.4 is supported. New features: The extensions of Ganos are updated to version 4.9. For more information, see Release notes for Ganos. The ST_Intersection aggregate function is supported to aggregate an array of geometry objects. The ST_AddZ function is supported to accept z-axis values as the value of an input parameter and convert a 2D or 3DM geometry to a 3D or 4D geometry. The ST_SetValue function is enhanced to support the settings of pixel values based on the spatial range of a geometry object. The ST_ExportTo function is enhanced to export raster objects as COG files. The ST_CreateRast function is enhanced to convert multiple raster records or arrays into raster objects. The ST_Split function is enhanced to support the settings of start time when you want to split a trajectory by time. The enhanced function also supports the splitting of a trajectory by trajectory point index. The ST_Union function is enhanced to support batch execution based on memory usage to prevent OOM errors caused by large data volumes. HDFS-based operations on raster data are supported. The pg_jieba extension that is used to segment Chinese text is supported. The extension supports custom dictionaries and allows you to switch between dictionaries. The extension displays segmentation results based on the offset of each field. Bug fixes: The bug due to which the index_adviser extension fails to respond when all recommended indexes already exist is fixed.
20220630	PostgreSQL 14.4 is supported. New features: The extensions of Ganos are updated to version 4.7. For more information, see Release notes for Ganos. The ST_makeTrajectory function is enhanced to convert rows in a table into trajectories. The ST_AsTable function is added to convert trajectories into tables. Bug fixes: The bug of silent corruption of indexes caused by "CREATE INDEX CONCURRENTLY" / "REINDEX CONCURRENTLY" is fixed.
20220228	PostgreSQL 14.1 is supported. New features: Version 1.0.2 of the sequential-uuids extension is supported. The EncDB extension is updated to version 1.1.9. The extensions of Ganos are updated to version 4.6. For more information, see Release notes for Ganos. Raster data can be accessed by using self-managed MinIO servers. For more information, see Object storage paths. The ST_PointValues function is added to return the pixel values of all bands. Standard accounts are granted the permissions to execute the LOAD statement to load the index_adviser and pg_hint_plan extensions. Privileged accounts are granted the permissions to configure the BYPASSRLS parameter in the CREATE ROLE statement. Bug fixes: The bug that causes missing parameter values in slow SQL logs is fixed.
20220130	PostgreSQL 14.1 is supported. New features: Version 2.0 of the index_adviser extension is supported. Version 1.3.1 of the hypopg extension is supported. The extensions of Ganos are updated to version 4.5. For more information, see Release notes for Ganos. The EncDB extension is updated to version 1.1.7. The pg_cron extension is updated to version 1.1. The roaringbitmap extension is updated to version 0.5.
20211130	PostgreSQL 14.1 is supported. This is the initial release. For more information about the supported features, see PostgreSQL 14. For more information about the supported extensions, see Supported extensions.

PostgreSQL 13

AliPG version	Description
20230630	PostgreSQL 13.9 is supported. New features: None Bug fixes: Known issues are fixed.
20230530	PostgreSQL 13.9 is supported. New features: Version 4.7.3 of the pg_partman extension is supported. The pg_cron extension is updated to version 1.5. The extensions of Ganos are updated to version 5.6. For more information, see Release notes for Ganos. Bug fixes: The bug due to which the profile database fails to connect to the server database when the pg_profile extension is used is fixed.
20230430	PostgreSQL 13.9 is supported. New features: ICU collations are supported. The extensions of Ganos are updated to version 5.5. For more information, see Release notes for Ganos. Bug fixes: None
20230330	PostgreSQL 13.9 is supported. New features: None Bug fixes: Specific known issues are fixed.
20230228	PostgreSQL 13.9 is supported. New features: The extensions of Ganos are updated to version 5.4. For more information, see Release notes for Ganos. Version 2.4 of the ip4r extension is supported. Version 2.1 of the pgl_ddl_deploy extension is supported. The pgRouting extension is updated to version 3.4.2. The pglogical extension is updated to version 2.4.2. Bug fixes: None
20221230	PostgreSQL 13.9 is supported. New features: The extensions of Ganos are updated to version 5.3. For more information, see Release notes for Ganos. Version 0.0.1 of the PASE extension is supported. The PostGIS extension is updated to version 3.3.2. The EncDB extension is updated to version 1.1.12. Bug fixes: None
20221030	PostgreSQL 13.8 is supported. New features: The extensions of Ganos are updated to version 5.1. For more information, see Release notes for Ganos. The TDE feature is supported to achieve table-level transparent data encryption. Version 1.0 of the rds_tde_utils extension is supported. Version 4.1 of the pg_profile extension is supported. Version 2.2.1 of the pg_stat_kcache extension is supported. Version 2.0.3 of the tds_fdw extension is supported. Bug fixes: None
20220830	PostgreSQL 13.7 is supported. New features: The EncDB extension is updated to version 1.1.1. The memory usage of the index_adviser extension is optimized. Bug fixes: The bug due to which the index_adviser extension accesses memory out of bounds in complex queries is fixed.
20220730	PostgreSQL 13.6 is supported. New features: The extensions of Ganos are updated to version 4.9. For more information, see Release notes for Ganos. The ST_Intersection aggregate function is supported to aggregate an array of geometry objects. The ST_AddZ function is supported to accept z-axis values as the value of an input parameter and convert a 2D or 3DM geometry to a 3D or 4D geometry. The ST_SetValue function is enhanced to support the settings of pixel values based on the spatial range of a geometry object. The ST_ExportTo function is enhanced to export raster objects as COG files. The ST_CreateRast function is enhanced to convert multiple raster records or arrays into raster objects. The ST_Split function is enhanced to support the settings of start time when you want to split a trajectory by time. The enhanced function also supports the splitting of a trajectory by trajectory point index. The ST_Union function is enhanced to support batch execution based on memory usage to prevent OOM errors caused by large data volumes. HDFS-based operations on raster data are supported. The pg_jieba extension that is used to segment Chinese words is supported. The extension supports custom dictionaries and allows you to switch between dictionaries. The extension displays segmentation results based on the offset of each field. Bug fixes: The bug due to which the index_adviser extension fails to respond when all recommended indexes already exist is fixed.
20220228	PostgreSQL 13.5 is supported. New features: Version 1.0.2 of the sequential-uuids extension is supported. The EncDB extension is updated to version 1.1.9. The extensions of Ganos are updated to version 4.6. For more information, see Release notes for Ganos. Raster data can be accessed by using self-managed MinIO servers. For more information, see Object storage paths. The ST_PointValues function is added to return the pixel values of all bands. Standard accounts are granted the permissions to execute the LOAD statement to load the index_adviser and pg_hint_plan extensions. Privileged accounts are granted the permissions to configure the BYPASSRLS parameter in the CREATE ROLE statement. Bug fixes: The bug that causes missing parameter values in slow SQL logs is fixed.
20220130	PostgreSQL 13.5 is supported. New features: Version 2.0 of the index_adviser extension is supported. Version 1.3.1 of the hypopg extension is supported. The extensions of Ganos are updated to version 4.5. For more information, see Release notes for Ganos. The pg_cron extension is updated to version 1.1. The roaringbitmap extension is updated to version 0.5.
20211130	PostgreSQL 13.5 is supported. New features: The extensions of Ganos are updated to version 4.4. For more information, see Release notes for Ganos. The PostGIS extension is updated to version 3.1.4. The pg_jieba extension is supported. This extension is used for Chinese tokenization. The pldebugger extension is supported. This extension is used to debug stored procedures. Version 2.5.0 of the TimescaleDB extension is supported. The log_statement parameter can be set for a session, a user, or a database. Bug fixes: The bug that privileged accounts have no permissions to execute the `SHOW SHARED_PRELOAD_LIBRARIES` statement is fixed. The bug due to which standard accounts have the permissions to call the `pg_stat_reset()` function is fixed.
20211031	PostgreSQL 13.1 is supported. New features: The fully encrypted database feature can identify the versions of the EncDB SDK and EncJDBC. For more information, see Overview. Performance improvements: The audit log feature is optimized. After the optimization, the audit log feature is enabled by default. The extensions of Ganos are optimized. After the optimization, the extensions of Ganos can be identified based on their descriptions and can be updated. For more information, see How do I update the extensions of Ganos? Bug fixes: The bug due to which the extensions of Ganos report errors when functions are invoked is fixed. This bug is triggered if the extensions of Ganos are not updated at the earliest opportunity.
20210930	PostgreSQL 13.1 is supported. New features: The extensions of Ganos are updated to version 4.1. In version 4.1, some functions are added, and some functions are enhanced. For more information, see Release notes for Ganos. The rdsutils extension is provided. This extension is a proprietary extension of Alibaba Cloud and provides the failove_slots view. The RUM extension is updated to version 1.3.8. The pglogical extension is updated to version 2.4.0. The PLV8 extension is updated to version 2.3.15. Performance improvements: GCC is updated to version 9.2, and glibc is updated to version 2.30. After the updates, LTO is supported. If LTO is enabled, the overall performance can be improved by 5%. The audit log feature is optimized. If the log_statement parameter is set to all, database performance can be improved by approximately four times in scenarios in which more than 50 active connections are established. The default value of the `rds_failover_slot_mode` parameter is changed to `async`. This default value specifies that the Logical Replication Slot Failover feature is enabled. For more information, see Logical Replication Slot Failover. Bug fixes: The bug due to which the mysql_fdw extension causes memory leaks in some scenarios is fixed. The bug due to which the pg_cron extension causes memory leaks in some scenarios is fixed.
20210531	PostgreSQL 13.1 is supported. New features: The extensions of Ganos are updated to version 3.8. The ST_AsDatasetFile function is supported to convert a specified part of a raster into a BYTEA-type file. The ST_RasterDrivers function is supported to query all drivers that are supported by raster data sources in Ganos. The bug due to which the ST_Clip function encounters reprojection failures when a spatial reference system is specified is fixed. The pglogical extension is supported. This extension provides logical streaming replication by using a publish/subscribe pattern. The pgAudit extension is supported. This extension is used to generate audit logs. Performance improvements: Permission management is optimized. When the `GRANT role1 TO role2` statement is executed, role2 does not carry over the CREATEDB or CREATEROLE permission from role1. Important The CREATEDB and CREATEROLE permissions are removed from the roles to which the GRANT statement is executed to grant these permissions. Privileged accounts are granted the permissions to call the pg_ls_waldir() function. The scanning method that is used by the monitoring and alerting feature is optimized to improve CPU performance. The major engine version upgrade feature is optimized. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. This feature can be used to update extensions such as PostGIS and pgRouting with no downtime. This feature can also be used to update account permissions from PostgreSQL 9.4 to a later version with no downtime. The maximum length per log record is increased from 1,024 bytes to 4,096 bytes when SQL statements cause insufficient memory or unexpected exits. Bug fixes: The bug due to which the oss_fdw extension accesses memory out of bounds in some scenarios is fixed.
20210331	PostgreSQL 13.1 is supported. New features: The extensions of Ganos are updated to version 3.7. The pg_repack extension is supported. This extension is used to clear tablespaces and mitigate table bloats. The mysql_fdw extension is updated to version 1.1. The major version upgrade feature is provided to migrate the user permissions, the mysql_fdw and oss_fdw extensions, and the permissions on these extensions with no downtime. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. Bug fixes: The bug due to which the oss_fdw extension cannot be used after a minor engine version update or a major engine version upgrade is fixed.
20210228	PostgreSQL 13.1 is supported. New features: The extensions of Ganos are updated to version 3.6. The decoderbufs extension is supported. This extension is used to generate data that is compatible with the Debezium platform based on Protocol Buffers. The pg_pathman extension is supported. This extension is used to improve the performance of partitioned tables. The PLV8 extension is supported. This extension is a trusted JavaScript extension. The oss_fdw extension is supported. This extension is used to read and write data to OSS buckets. The mysql_fdw extension is supported. This extension is used to read and write data to ApsaraDB RDS for MySQL instances or self-managed MySQL databases. Privileged accounts are granted the permissions to create event triggers and specify the maximum length per log record. Bug fixes: The bug due to which ApsaraDB RDS cannot display slow query logs in an expected manner is fixed. The bug due to which privileged accounts cannot use the zhparser extension to customize word libraries is fixed. The bug that triggers log-related online alerts if the archive_mode parameter is set to on is fixed.
20201230	PostgreSQL 13.1 is supported. New features: Indexes can be deleted in parallel. More types of data from different data sources are supported. An enhanced partitioning feature is provided. This feature can directly join partitioned tables to reduce the overall amount of time that is required to run a query. In addition, this feature supports row-level BEFORE triggers and full logical replications. An advanced hash aggregation feature is released. This feature is used to aggregate and group various types of data. This way, a query that requires ApsaraDB RDS to aggregate a large amount of data does not need to run only in the memory. The Logical Replication Slot Failover feature is supported. Performance improvement The indexing and search features are optimized to adapt to large database systems. For more information about PostgreSQL 13, see the PostgreSQL official documentation.

PostgreSQL 12

AliPG version	Description
20230630	PostgreSQL 12.13 is supported. New features: None Bug fixes: Known issues are fixed.
20230530	PostgreSQL 12.13 is supported. New features: Version 4.7.3 of the pg_partman extension is supported. The extensions of Ganos are updated to version 5.6. For more information, see Release notes for Ganos. Bug fixes: The bug due to which the profile database fails to connect to the server database when the pg_profile extension is used is fixed.
20230430	PostgreSQL 12.13 is supported. New features: ICU collations are supported. The extensions of Ganos are updated to version 5.5. For more information, see Release notes for Ganos. Bug fixes: None
20230330	PostgreSQL 12.13 is supported. New features: None Bug fixes: Specific known issues are fixed.
20230228	PostgreSQL 12.13 is supported. New features: The extensions of Ganos are updated to version 5.4. For more information, see Release notes for Ganos. The pgRouting extension is updated to version 3.4.2. The pglogical extension is updated to version 2.4.2. Bug fixes: None
20221230	PostgreSQL 12.13 is supported. New features: The extensions of Ganos are updated to version 5.3. For more information, see Release notes for Ganos. Version 0.0.1 of the PASE extension is supported. The PostGIS extension is updated to version 3.3.2. The EncDB extension is updated to version 1.1.12. Bug fixes: None
20221030	PostgreSQL 12.12 is supported. New features: The extensions of Ganos are updated to version 5.1. For more information, see Release notes for Ganos. The TDE feature is supported to achieve table-level transparent data encryption. Version 1.0 of the rds_tde_utils extension is supported. Version 4.1 of the pg_profile extension is supported. Version 2.2.1 of the pg_stat_kcache extension is supported. Bug fixes: None
20220830	PostgreSQL 12.11 is supported. New features: The EncDB extension is updated to version 1.1.1. The memory usage of the index_adviser extension is optimized. Bug fixes: The bug due to which the index_adviser extension accesses memory out of bounds in complex queries is fixed.
20220730	PostgreSQL 12.8 is supported. New features: The extensions of Ganos are updated to version 4.9. For more information, see Release notes for Ganos. The ST_Intersection aggregate function is supported to aggregate an array of geometry objects. The ST_AddZ function is supported to accept z-axis values as the value of an input parameter and convert a 2D or 3DM geometry to a 3D or 4D geometry. The ST_SetValue function is enhanced to support the settings of pixel values based on the spatial range of a geometry object. The ST_ExportTo function is enhanced to export raster objects as COG files. The ST_CreateRast function is enhanced to convert multiple raster records or arrays into raster objects. The ST_Split function is enhanced to support the settings of start time when you want to split a trajectory by time. The enhanced function also supports the splitting of a trajectory by trajectory point index. The ST_Union function is enhanced to support batch execution based on memory usage to prevent OOM errors caused by large data volumes. HDFS-based operations on raster data are supported. The pg_jieba extension that is used to segment Chinese words is supported. The extension supports custom dictionaries and allows you to switch between dictionaries. The extension displays segmentation results based on the offset of each field. Bug fixes: The bug due to which the index_adviser extension fails to respond when all recommended indexes already exist is fixed.
20220228	PostgreSQL 12.8 is supported. New features: Version 1.0.2 of the sequential-uuids extension is supported. Version 1.18.0 of the MADlib extension is supported. The EncDB extension is updated to version 1.1.9. The extensions of Ganos are updated to version 4.6. For more information, see Release notes for Ganos. Raster data can be accessed by using self-managed MinIO servers. For more information, see Object storage paths. The ST_PointValues function is added to return the pixel values of all bands. Standard accounts are granted the permissions to execute the LOAD statement to load the index_adviser and pg_hint_plan extensions. Privileged accounts are granted the permissions to configure the BYPASSRLS parameter in the CREATE ROLE statement. Bug fixes: The bug that causes missing parameter values in slow SQL logs is fixed.
20220130	PostgreSQL 12.8 is supported. New features: Version 2.0 of the index_adviser extension is supported. Version 1.3.1 of the hypopg extension is supported. The extensions of Ganos are updated to version 4.5. For more information, see Release notes for Ganos.
20211130	PostgreSQL 12.8 is supported. New features: The extensions of Ganos are updated to version 4.4. For more information, see Release notes for Ganos. The PostGIS extension is updated to version 3.1.4. The pg_jieba extension is supported. This extension is used for Chinese tokenization. The pldebugger extension is supported. This extension is used to debug stored procedures. The log_statement parameter can be configured for a session, a user, or a database. Bug fixes: The bug due to which the pg_cron extension causes memory leaks when users view the task records in the cron.job_log data table is fixed. The bug that privileged accounts have no permissions to execute the `SHOW SHARED_PRELOAD_LIBRARIES` statement is fixed. The bug due to which standard accounts have the permissions to call the `pg_stat_reset()` function is fixed.
20211031	PostgreSQL 12.8 is supported. New features: The fully encrypted database feature can identify the versions of the EncDB SDK and EncJDBC. For more information, see Overview. Performance improvements: The audit log feature is optimized. After the optimization, the audit log feature is enabled by default. The extensions of Ganos are optimized. After the optimization, the extensions of Ganos can be identified based on their descriptions and can be updated. For more information, see How do I update the extensions of Ganos? Bug fixes: The bug due to which the extensions of Ganos report errors when functions are invoked is fixed. This bug is triggered if the extensions of Ganos are not updated at the earliest opportunity.
20210930	PostgreSQL 12.8 is supported. New features: The extensions of Ganos are updated to version 4.1. In version 4.1, some functions are added, and some functions are enhanced. For more information, see Release notes for Ganos. The rdsutils extension is provided. This extension is a proprietary extension of Alibaba Cloud and provides the failove_slots view. The RUM extension is updated to version 1.3.8. The pg_pathman extension is updated to version 1.5.12. The pglogical extension is updated to version 2.4.0. The PLV8 extension is updated to version 2.3.15. The RDKit extension is updated to version 2020_09_05. Performance improvements: GCC is updated to version 9.2, and glibc is updated to version 2.30. After the updates, LTO is supported. If LTO is enabled, the overall performance can be improved by 5%. The audit log feature is optimized. If the log_statement parameter is set to all, database performance can be improved by approximately four times in scenarios in which more than 50 active connections are established. The default value of the `rds_failover_slot_mode` parameter is changed to `async`. This default value specifies that the Logical Replication Slot Failover feature is enabled. For more information, see Logical Replication Slot Failover. Bug fixes: The bug due to which TimescaleDB loses the metadata of system tables after the `VACUUM FULL pg_catalog.pg_attribute` statement is executed is fixed. The bug due to which the mysql_fdw extension causes memory leaks in some scenarios is fixed. The bug due to which the pg_cron extension causes memory leaks in some scenarios is fixed.
20210531	PostgreSQL 12.4 is supported. New features: The extensions of Ganos are updated to version 3.8. The ST_AsDatasetFile function is supported to convert a specified part of a raster into a BYTEA-type file. The ST_RasterDrivers function is supported to query all drivers that are supported by raster data sources in Ganos. The bug due to which the ST_Clip function encounters reprojection failures when a spatial reference system is specified is fixed. The pglogical extension is supported. This extension provides logical streaming replication by using a publish/subscribe pattern. The pgAudit extension is supported. This extension is used to generate audit logs. Performance improvements: Permission management is optimized. When the `GRANT role1 TO role2` statement is executed, role2 does not carry over the CREATEDB or CREATEROLE permission from role1. Important The CREATEDB and CREATEROLE permissions are removed from the roles to which the GRANT statement is executed to grant these permissions. Privileged accounts are granted the permissions to use the pg_ls_waldir() function. The scanning method that is used by the monitoring and alerting feature is optimized to improve CPU performance. The major engine version upgrade feature is optimized. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. This feature can be used to update extensions such as PostGIS and pgRouting with no downtime. This feature can also be used to update account permissions from PostgreSQL 9.4 to a later version with no downtime. The maximum length per log record is increased from 1,024 bytes to 4,096 bytes when SQL statements cause insufficient memory or unexpected exits. Bug fixes: The bug due to which the oss_fdw extension accesses memory out of bounds in some scenarios is fixed.
20210331	PostgreSQL 12.4 is supported. New features: The extensions of Ganos are updated to version 3.7. The pg_repack extension is supported. This extension is used to clear tablespaces and mitigate table bloats. The mysql_fdw extension is updated to version 1.1. The major version upgrade feature is provided to migrate the user permissions, the mysql_fdw and oss_fdw extensions, and the permissions on these extensions with no downtime. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. Bug fixes: The bug due to which the oss_fdw extension cannot be used after a minor engine version update or a major engine version upgrade is fixed.
20210228	PostgreSQL 12.4 is supported. New features: The extensions of Ganos are updated to version 3.6. The decoderbufs extension is supported. This extension is used to generate data that is compatible with the Debezium platform based on Protocol Buffers. The pg_pathman extension is supported. This extension is used to improve the performance of partitioned tables. The PLV8 extension is supported. This extension is a trusted JavaScript extension. The oss_fdw extension is supported. This extension is used to read data from and write data to OSS buckets. Bug fixes: The bug due to which privileged accounts cannot use the zhparser extension to customize word libraries is fixed. The bug that triggers log-related online alerts if the archive_mode parameter is set to on is fixed.
20201230	PostgreSQL 12.4 is supported. New features: The extensions of Ganos are updated to version 3.3. The pg_hint_plan extension is supported. This extension is used to add hints, which are used to change the query plans that are provided. The zhparser extension is supported. The RUM extension is supported. This extension is used to run full-text searches at high speeds. The Bloom extension is supported. The Logical Replication Slot Failover feature is supported. Bug fixes: The bug that is caused by the conflict between the tds_fdw extension and the plan cache is fixed.
20201130	PostgreSQL 12.4 is supported. New features: Privileged accounts are granted the permissions to create accounts that have the REPLICATION permission on data streams. Privileged accounts are granted the permissions to create event triggers. The rds_auditlog_max_query_length parameter is added. This parameter specifies the maximum length per audit log record. An updated pg_cron extension is provided. After the update, this extension can be used to create and run cross-instance tasks. In addition, this extension provides a data table named cron.job_log from which users can view task records. The pg_freespacemap extension is supported. Spatio-temporal memory topology indexes are supported by Ganos. Ganos is updated to version 3.2. Bug fixes: The bug due to which DTS reports check errors when more than one child transaction is started or committed during data migration is fixed. The CVE-2020-14349 vulnerability is fixed. This vulnerability prevents ApsaraDB RDS from cleaning search paths in an expected manner during logical replications. The CVE-2020-14350 vulnerability is fixed. This vulnerability allows the `CREATE EXTENSION` statement to contain uncontrolled search path elements. The CVE-2020-25695 vulnerability is fixed. Attackers can exploit this vulnerability to create permanent objects and call all SQL functions by using the credentials of a superuser account.
20200830	PostgreSQL 12.2 is supported. New features: The extensions of Ganos are updated to version 3.0. The sql_firewall extension is supported. This extension is used to prevent malicious injection of SQL statements. The pg_bigm extension is supported. This extension is used to support fuzzy match. Bug fixes: The bug due to which the backend cannot identify the `rds_ prefix` in parameters is fixed. The bug due to which the pg_cron extension cannot be installed or used in an expected manner is fixed. The bug due to which the RDKit extension cannot be loaded when dependencies are not provided is fixed.
20200421	PostgreSQL 12.2 is supported. New features: The extensions of Ganos are updated to version 2.7. Version 2.14 of the hll extension is supported. Version 2.9.0 of the PL/Proxy extension is supported. Version 1.0 of the tsm_system_rows extension is supported. Version 1.0 of the tsm_system_time extension is supported. Version 1.0 of the smlar extension is supported. Version 1.0 of the tds_fdw extension is supported. Bug fixes: The bug due to which RDS instances restart when logical subscriptions time out is fixed.
20200221	New features: A specified number of connections can be reserved for the rds_superuser role. If users assume this role, they can log on to an RDS instance to troubleshoot issues even if the number of established connections to the RDS instance reaches the upper limit. The wal2json extension is supported. The extensions of Ganos are updated to version 2.6. Bug fixes: Some permission-related bugs are fixed.
20191230	New features: The pg_roaringbitmap extension, RDKit extension, mysql_fdw extension, and Ganos are supported. Privileged accounts are granted the permissions to publish all tables at a time and create subscriptions.

PostgreSQL 11

AliPG version	Description
20230630	PostgreSQL 11.18 is supported. New features: None Bug fixes: Known issues are fixed.
20230530	PostgreSQL 11.18 is supported. New features: The extensions of Ganos are updated to version 5.6. For more information, see Release notes for Ganos. Bug fixes: The bug due to which the profile database fails to connect to the server database when the pg_profile extension is used is fixed.
20230430	PostgreSQL 11.18 is supported. New features: ICU collations are supported. The extensions of Ganos are updated to version 5.5. For more information, see Release notes for Ganos. Bug fixes: None
20230330	PostgreSQL 11.18 is supported. New features: None Bug fixes: Specific known issues are fixed.
20221230	PostgreSQL 11.18 is supported. New features: The extensions of Ganos are updated to version 5.3. For more information, see Release notes for Ganos. The PostGIS extension is updated to version 3.3.2. The EncDB extension is updated to version 1.1.12. Bug fixes: None
20221030	PostgreSQL 11.17 is supported. New features: The extensions of Ganos are updated to version 5.1. For more information, see Release notes for Ganos. The TDE feature is supported to achieve table-level transparent data encryption. Version 1.0 of the rds_tde_utils extension is supported. Version 4.1 of the pg_profile extension is supported. Version 2.2.1 of the pg_stat_kcache extension is supported. Bug fixes: None
20220830	PostgreSQL 11.16 is supported. New features: The EncDB extension is updated to version 1.1.1. The memory usage of the index_adviser extension is optimized. Bug fixes: The bug due to which the index_adviser extension accesses memory out of bounds in complex queries is fixed.
20220730	PostgreSQL 11.13 is supported. New features: The extensions of Ganos are updated to version 4.9. For more information, see Release notes for Ganos. The ST_Intersection aggregate function is supported to aggregate an array of geometry objects. The ST_AddZ function is supported to accept z-axis values as the value of an input parameter and convert a 2D or 3DM geometry to a 3D or 4D geometry. The ST_SetValue function is enhanced to support the settings of pixel values based on the spatial range of a geometry object. The ST_ExportTo function is enhanced to export raster objects as COG files. The ST_CreateRast function is enhanced to convert multiple raster records or arrays into raster objects. The ST_Split function is enhanced to support the settings of start time when you want to split a trajectory by time. The enhanced function also supports the splitting of a trajectory by trajectory point index. The ST_Union function is enhanced to support batch execution based on memory usage to prevent OOM errors caused by large data volumes. HDFS-based operations on raster data are supported. The pg_jieba extension that is used to segment Chinese words is supported. The extension supports custom dictionaries and allows you to switch between dictionaries. The extension displays segmentation results based on the offset of each field. Bug fixes: The bug due to which the index_adviser extension fails to respond when all recommended indexes already exist is fixed.
20220228	PostgreSQL 11.13 is supported. New features: Version 1.0.2 of the sequential-uuids extension is supported. Version 1.18.0 of the MADlib extension is supported. The EncDB extension is updated to version 1.1.9. The extensions of Ganos are updated to version 4.6. For more information, see Release notes for Ganos. Raster data can be accessed by using self-managed MinIO servers. For more information, see Object storage paths. The ST_PointValues function is added to return the pixel values of all bands. Standard accounts are granted the permissions to execute the LOAD statement to load the index_adviser and pg_hint_plan extensions. Privileged accounts are granted the permissions to configure the BYPASSRLS parameter in the CREATE ROLE statement. Bug fixes: The bug that causes missing parameter values in slow SQL logs is fixed.
20220130	PostgreSQL 11.13 is supported. New features: Version 2.0 of the index_adviser extension is supported. Version 1.3.1 of the hypopg extension is supported. The extensions of Ganos are updated to version 4.5. For more information, see Release notes for Ganos.
20211130	PostgreSQL 11.13 is supported. New features: The extensions of Ganos are updated to version 4.4. For more information, see Release notes for Ganos. The PostGIS extension is updated to version 3.1.4. The pg_jieba extension is supported. This extension is used for Chinese tokenization. The pldebugger extension is supported. This extension is used to debug stored procedures. The log_statement parameter can be configured for a session, a user, or a database. Bug fixes: The bug due to which the pg_cron extension causes memory leaks when users view the task records in the cron.job_log data table is fixed. The bug that privileged accounts have no permissions to execute the `SHOW SHARED_PRELOAD_LIBRARIES` statement is fixed. The bug due to which standard accounts have the permissions to call the `pg_stat_reset()` function is fixed.
20211031	PostgreSQL 11.13 is supported. New features: The fully encrypted database feature can identify the versions of the EncDB SDK and EncJDBC. For more information, see Overview. Performance improvements: The audit log feature is optimized. After the optimization, the audit log feature is enabled by default. The extensions of Ganos are optimized. After the optimization, the extensions of Ganos can be identified based on their descriptions and can be updated. For more information, see How do I update the extensions of Ganos? Bug fixes: The bug due to which the extensions of Ganos report errors when functions are invoked is fixed. This bug is triggered if the extensions of Ganos are not updated at the earliest opportunity.
20210930	PostgreSQL 11.13 is supported. New features: The extensions of Ganos are updated to version 4.1. In version 4.1, some functions are added, and some functions are enhanced. For more information, see Release notes for Ganos. The rdsutils extension is provided. This extension is a proprietary extension of Alibaba Cloud and provides the failove_slots view. The RUM extension is updated to version 1.3.8. The pg_pathman extension is updated to version 1.5.12. The pglogical extension is updated to version 2.4.0. The PLV8 extension is updated to version 2.3.15. Performance improvements: GCC is updated to version 9.2, and glibc is updated to version 2.30. After the updates, LTO is supported. If LTO is enabled, the overall performance can be improved by 5%. The audit log feature is optimized. If the log_statement parameter is set to all, database performance can be improved by approximately four times in scenarios in which more than 50 active connections are established. The default value of the `rds_failover_slot_mode` parameter is changed to `async`. This default value specifies that the Logical Replication Slot Failover feature is enabled. For more information, see Logical Replication Slot Failover. The logging mechanism is optimized. The system no longer provides `incomplete startup packet` log records that are triggered by empty packets. Bug fixes: The bug due to which the mysql_fdw extension causes memory leaks in some scenarios is fixed. The bug due to which the pg_cron extension causes memory leaks in some scenarios is fixed.
20210531	PostgreSQL 11.9 is supported. New features: The extensions of Ganos are updated to version 3.8. The ST_AsDatasetFile function is supported to convert a specified part of a raster into a BYTEA-type file. The ST_RasterDrivers function is supported to query all drivers that are supported by raster data sources in Ganos. The bug due to which the ST_Clip function encounters reprojection failures when a spatial reference system is specified is fixed. The pglogical extension is supported. This extension provides logical streaming replication by using a publish/subscribe pattern. The pgAudit extension is supported. This extension is used to generate audit logs. The fully encrypted database feature is supported. This feature is used to encrypt data on the user side before the data is transmitted to RDS instances. This feature helps defend against security threats inside and outside the cloud to protect user data at all times. Performance improvements: Permission management is optimized. When the `GRANT role1 TO role2` statement is executed, role2 does not carry over the CREATEDB or CREATEROLE permission from role1. Important The CREATEDB and CREATEROLE permissions are removed from the roles to which the GRANT statement is executed to grant these permissions. Privileged accounts are granted the permissions to call the pg_ls_waldir() function. The scanning method that is used by the monitoring and alerting feature is optimized to improve CPU performance. The major engine version upgrade feature is optimized. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. This feature can be used to update extensions such as PostGIS and pgRouting with no downtime. This feature can also be used to update account permissions from PostgreSQL 9.4 to a later version with no downtime. The maximum length per log record is increased from 1,024 bytes to 4,096 bytes when SQL statements cause insufficient memory or unexpected exits. Bug fixes: The bug that causes the PASE extension to index data out of bounds is fixed. The bug due to which the oss_fdw extension accesses memory out of bounds in some scenarios is fixed.
20210331	PostgreSQL 11.9 is supported. New features: The extensions of Ganos are updated to version 3.7. The pg_repack extension is supported. This extension is used to clear tablespaces and mitigate table bloats. The mysql_fdw extension is updated to version 1.1. The major version upgrade feature is provided to migrate the user permissions, the mysql_fdw and oss_fdw extensions, and the permissions on these extensions with no downtime. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. Bug fixes: The bug due to which the oss_fdw extension cannot be used after a minor engine version update or a major engine version upgrade is fixed.
20210228	PostgreSQL 11.9 is supported. New features: The plug-ins of Ganos are updated to version 3.6. The mysql_fdw extension is supported. This extension is used to read data from and write data to ApsaraDB RDS for MySQL instances or self-managed MySQL databases. Bug fixes: The bug that triggers log-related online alerts if the archive_mode parameter is set to on is fixed.
20201230	PostgreSQL 11.9 is supported. New features: The extensions of Ganos are updated to version 3.3. The pg_hint_plan extension is supported. This extension is used to add hints, which are used to change the query plans that are provided. The Bloom extension is supported. Bug fixes: The bug that causes data loss in synchronous mode is fixed by optimizing the Logical Replication Slot Failover feature. This feature can help prevent data loss even in extreme circumstances. For more information, see Logical Replication Slot Failover. The bug that is caused by the conflict between the tds_fdw extension and the plan cache is fixed.
20201130	PostgreSQL 11.9 is supported. New features: Privileged accounts are granted the permissions to create accounts that have the REPLICATION permission on data streams. Privileged accounts are granted the permissions to create event triggers. The rds_auditlog_max_query_length parameter is added. This parameter specifies the maximum length per audit log record. An updated pg_cron extension is provided. After the update, this extension can be used to create and run cross-instance tasks. In addition, this extension provides a table named cron.job_log from which users can view task records. The pg_freespacemap extension is supported. Spatio-temporal memory topology indexes are supported by Ganos. Ganos is updated to version 3.2. Bug fixes: The bug due to which DTS reports check errors when more than one child transaction is started or committed during data migration is fixed. The CVE-2020-14349 vulnerability is fixed. This vulnerability prevents ApsaraDB RDS from cleaning search paths in an expected manner during logical replications. The CVE-2020-14350 vulnerability is fixed. This vulnerability allows the `CREATE EXTENSION` statement to contain uncontrolled search path elements. The CVE-2020-25695 vulnerability is fixed. Attackers can exploit this vulnerability to create permanent objects and call all SQL functions by using the credentials of a superuser account.
20200830	New features: The extensions of Ganos are updated to version 3.0. The sql_firewall extension is supported. This extension is used to prevent malicious injection of SQL statements. The pg_bigm extension is supported. This extension is used to support fuzzy match. The ZomboDB extension is supported. This extension is used to support text search and analysis. Bug fixes: The bug due to which the backend cannot identify the `rds_ prefix` in parameters is fixed. The bug due to which a secondary RDS instance unexpectedly exits when the failover slot has the same name as the streaming replication slot is fixed. The bug due to which the pg_cron extension cannot be installed or used in an expected manner is fixed. The bug in a global variable of the PASE extension is fixed.
20200610	New features: The pageinspect extension is supported by the rds_superuser role. The rds_superuser role can grant the REPLICATION permission to other users.
20200511	New features: The extensions of Ganos are updated to version 2.8. Bug fixes: The bug due to which the PASE extension executes the INSERT statement at a low speed based on Hierarchical Navigable Small World (HNSW) indexes is fixed.
20200421	New features: The Logical Replication Slot Failover feature is supported. Version 2.9.0 of the PL/Proxy extension is supported. Version 1.0 of the tsm_system_rows extension is supported. Version 1.0 of the tsm_system_time extension is supported. Version 1.0 of the smlar extension is supported.
20200402	New features: Version 2.14 of the hll extension is supported. This extension is used to support the HLL data type, respond to queries in milliseconds, and analyze approximate data at low costs and high speeds. For example, users can query page views (PVs) and unique visitors (UVs) in real time and check whether the approximate data that they analyze contains specified characteristic tags. Version 1.1 of the oss_fdw extension is supported. This extension is used to store infrequently requested historical data to OSS buckets to reduce storage costs. Version 2.0.1 of the tds_fdw extension is supported. This extension allows users to initiate requests on an RDS instance to query data from a Sybase or SQL Server database without the need to perform extract, transform and load (ETL) operations. This extension is also used to migrate data between an RDS instance and a Sybase or SQL Server database. Extension updates: The extensions of Ganos are updated to version 2.7. The wal2json extension is updated to version 2.2. Performance improvement The `shutdown -m fast` command is optimized.
20191218	New features: The PASE extension is supported. This extension provides indexes that are used to recognize images. Privileged accounts are granted the permissions to publish all tables at a time and create subscriptions.

PostgreSQL 10

AliPG version	Description
20230630	PostgreSQL 10.23 is supported. New features: None Bug fixes: Known issues are fixed.
20230430	PostgreSQL 10.23 is supported. New features: ICU collations are supported. The extensions of Ganos are updated to version 5.5. For more information, see Release notes for Ganos. Bug fixes: None
20230330	PostgreSQL 10.23 is supported. New features: None Bug fixes: Specific known issues are fixed.
20221230	PostgreSQL 10.23 is supported. New features: The extensions of Ganos are updated to version 5.3. For more information, see Release notes for Ganos. The PostGIS extension is updated to version 3.3.2. The EncDB extension is updated to version 1.1.12. Bug fixes: None
20221030	PostgreSQL 10.22 is supported. New features: The extensions of Ganos are updated to version 5.1. For more information, see Release notes for Ganos. The TDE feature is supported to achieve table-level transparent data encryption. Version 1.0 of the rds_tde_utils extension is supported. Version 4.1 of the pg_profile extension is supported. Version 2.2.1 of the pg_stat_kcache extension is supported. Bug fixes: None
20220830	PostgreSQL 10.21 is supported. New features: The EncDB extension is updated to version 1.1.1. The memory usage of the index_adviser extension is optimized. Bug fixes: The bug due to which the index_adviser extension accesses memory out of bounds in complex queries is fixed.
20220730	PostgreSQL 10.19 is supported. New features: The extensions of Ganos are updated to version 4.9. For more information, see Release notes for Ganos. The ST_Intersection aggregate function is supported to aggregate an array of geometry objects. The ST_AddZ function is supported to accept z-axis values as the value of an input parameter and convert a 2D or 3DM geometry to a 3D or 4D geometry. The ST_SetValue function is enhanced to support the settings of pixel values based on the spatial range of a geometry object. The ST_ExportTo function is enhanced to export raster objects as COG files. The ST_CreateRast function is enhanced to convert multiple raster records or arrays into raster objects. The ST_Split function is enhanced to support the settings of start time when you want to split a trajectory by time. The enhanced function also supports the splitting of a trajectory by trajectory point index. The ST_Union function is enhanced to support batch execution based on memory usage to prevent OOM errors caused by large data volumes. HDFS-based operations on raster data are supported. The pg_jieba extension that is used to segment Chinese words is supported. The extension supports custom dictionaries and allows you to switch between dictionaries. The extension displays segmentation results based on the offset of each field. Bug fixes: The bug due to which the index_adviser extension fails to respond when all recommended indexes already exist is fixed. The bug that a privileged account cannot execute the `CREATE PUBLICATION xxx FOR ALL TABLES;` statement is fixed.
20220228	PostgreSQL 10.19 is supported. New features: Version 1.0.2 of the sequential-uuids extension is supported. The EncDB extension is updated to version 1.1.9. The extensions of Ganos are updated to version 4.6. For more information, see Release notes for Ganos. Raster data can be accessed by using self-managed MinIO servers. For more information, see Object storage paths. The ST_PointValues function is added to return the pixel values of all bands. Standard accounts are granted the permissions to execute the LOAD statement to load the index_adviser and pg_hint_plan extensions. Privileged accounts are granted the permissions to configure the BYPASSRLS parameter in the CREATE ROLE statement. Bug fixes: The bug that causes missing parameter values in slow SQL logs is fixed.
20220130	PostgreSQL 10.19 is supported. New features: Version 2.0 of the index_adviser extension is supported. Version 1.3.1 of the hypopg extension is supported. The extensions of Ganos are updated to version 4.5. For more information, see Release notes for Ganos.
20211130	PostgreSQL 10.19 is supported. New features: The extensions of Ganos are updated to version 4.4. For more information, see Release notes for Ganos. The PostGIS extension is updated to version 3.1.4 and is compatible with ApsaraDB RDS for PostgreSQL. The pg_jieba extension is supported. This extension is used for Chinese tokenization. The pldebugger extension is supported. This extension is used to debug stored procedures. The log_statement parameter can be configured for a session, a user, or a database. Bug fixes: The bug due to which the pg_cron extension causes memory leaks when users view the task records in the cron.job_log data table is fixed. The bug due to which standard accounts have the permissions to call the `pg_stat_reset()` function is fixed.
20211031	PostgreSQL 10.14 is supported. New features: The fully encrypted database feature can identify the versions of the EncDB SDK and EncJDBC. For more information, see Overview. Performance improvements: The audit log feature is optimized. After the optimization, the audit log feature is enabled by default. The extensions of Ganos are optimized. After the optimization, the extensions of Ganos can be identified based on their descriptions and can be updated. For more information, see How do I update the extensions of Ganos? Bug fixes: The bug due to which the extensions of Ganos report errors when functions are invoked is fixed. This bug is triggered if the extensions of Ganos are not updated at the earliest opportunity.
20210930	PostgreSQL 10.14 is supported. New features: The extensions of Ganos are updated to version 4.1. In version 4.1, some functions are added, and some functions are enhanced. For more information, see Release notes for Ganos. The rdsutils extension is provided. This extension is a proprietary extension of Alibaba Cloud and provides the failove_slots view. The RUM extension is updated to version 1.3.8. The pglogical extension is updated to version 2.4.0. The PLV8 extension is updated to version 2.3.15. Performance improvements: GCC is updated to version 9.2, and glibc is updated to version 2.30. After the updates, LTO is supported. If LTO is enabled, the overall performance can be improved by 5%. The audit log feature is optimized. If the log_statement parameter is set to all, database performance can be improved by approximately four times in scenarios in which more than 50 active connections are established. The default value of the `rds_failover_slot_mode` parameter is changed to `async`. This default value specifies that the Logical Replication Slot Failover feature is enabled. For more information, see Logical Replication Slot Failover. The logging mechanism is optimized. The system no longer provides `incomplete startup packet` log records that are triggered by empty packets. Bug fixes: The bug due to which the mysql_fdw extension causes memory leaks in some scenarios is fixed. The bug due to which the pg_cron extension causes memory leaks in some scenarios is fixed.
20210531	PostgreSQL 10.14 is supported. New features: The extensions of Ganos are updated to version 3.8. The ST_AsDatasetFile function is supported to convert a specified part of a raster into a BYTEA-type file. The ST_RasterDrivers function is supported to query all drivers that are supported by raster data sources in Ganos. The bug due to which the ST_Clip function encounters reprojection failures when a spatial reference system is specified is fixed. The pglogical extension is supported. This extension provides logical streaming replication by using a publish/subscribe pattern. The pgAudit extension is supported. This extension is used to generate audit logs. Performance improvements: Permission management is optimized. When the `GRANT role1 TO role2` statement is executed, role2 does not carry over the CREATEDB or CREATEROLE permission from role1. Important The CREATEDB and CREATEROLE permissions are removed from the roles to which the GRANT statement is executed to grant these permissions. Privileged accounts are granted the permissions to call the pg_ls_waldir() function. The scanning method that is used by the monitoring and alerting feature is optimized to improve CPU performance. The major engine version upgrade feature is optimized. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. This feature can be used to update extensions such as PostGIS and pgRouting with no downtime. This feature can also be used to update account permissions from PostgreSQL 9.4 to a later version with no downtime. The maximum length per log record is increased from 1,024 bytes to 4,096 bytes when SQL statements cause insufficient memory or unexpected exits. Bug fixes: The bug due to which the oss_fdw extension accesses memory out of bounds in some scenarios is fixed.
20210331	PostgreSQL 10.14 is supported. New features: The extensions of Ganos are updated to version 3.7. The pg_repack extension is supported. This extension is used to clear tablespaces and mitigate table bloats. PostgreSQL 10 is supported by the mysql_fdw extension. The mysql_fdw plug-in is updated to version 1.1. The major version upgrade feature is provided to migrate the user permissions, the mysql_fdw and oss_fdw extensions, and the permissions on these extensions with no downtime. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. Bug fixes: The bug due to which the oss_fdw extension cannot be used after a minor engine version update or a major engine version upgrade is fixed.
20210228	PostgreSQL 10.14 is supported. New features: The plug-ins of Ganos are updated to version 3.6. Bug fixes: The bug that triggers log-related online alerts if the archive_mode parameter is set to on is fixed.
20201230	PostgreSQL 10.14 is supported. New features: The plug-ins of Ganos are updated to version 3.3. The Bloom extension is supported. The Logical Replication Slot Failover feature is supported.
20201130	PostgreSQL 10.14 is supported. New features: Privileged accounts are granted the permissions to create accounts that have the REPLICATION permission on data streams. Privileged accounts are granted the permissions to create event triggers. The rds_auditlog_max_query_length parameter is added. This parameter specifies the maximum length per audit log record. An updated pg_cron extension is provided. After the update, this extension can be used to create and run cross-instance tasks. In addition, this extension provides a table named cron.job_log from which users can view task records. The pg_freespacemap extension is supported. Spatio-temporal memory topology indexes are supported by Ganos. Ganos is updated to version 3.2. Bug fixes: The bug due to which DTS reports check errors when more than one child transaction is started or committed during data migration is fixed. The CVE-2020-14349 vulnerability is fixed. This vulnerability prevents ApsaraDB RDS from cleaning search paths in an expected manner during logical replications. The CVE-2020-14350 vulnerability is fixed. This vulnerability allows the `CREATE EXTENSION` statement to contain uncontrolled search path elements. The CVE-2020-25695 vulnerability is fixed. Attackers can exploit this vulnerability to create permanent objects and call all SQL functions by using the credentials of a superuser account.
20200830	PostgreSQL 10.9 is supported. New features: The extensions of Ganos are updated to version 3.0. The sql_firewall extension is supported. This extension is used to prevent malicious injection of SQL statements. The pg_bigm extension is supported. This extension is used to support fuzzy match. Bug fixes: The bug due to which the pg_cron extension cannot be installed or used in an expected manner is fixed.
20200212	PostgreSQL 10.9 is supported. New features: A specified number of connections can be reserved for the rds_superuser role. If users assume this role, they can log on to an RDS instance to troubleshoot issues even if the number of established connections to the RDS instance reaches the upper limit. The plug-ins of Ganos are updated to version 2.6. Bug fixes: The bug that triggers long waits during streaming replication is fixed.
20190703	PostgreSQL 10.9 is supported. New features: AliPG is updated to adapt to PostgreSQL 10.9. The synchronous replication mode can be demoted to the asynchronous replication mode when the ongoing replication times out. Bug fixes: The bug due to which the pg_hint_plan extension cannot be installed is fixed.