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

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

PostgreSQL 14

Minor AliPG version Description
20220228 PostgreSQL 14.1 is supported.
  • New features:
    • Version 1.0.2 of the sequential-uuids plug-in is supported.
    • Version 1.1.9 of the EncDB plug-in is supported.
    • Version 4.6 of Ganos is supported. 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 raster function is added. This function is used 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 plug-ins.
    • 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:

PostgreSQL 13

Minor AliPG version Description
20220228 PostgreSQL 13.5 is supported.
  • New features:
    • Version 1.0.2 of the sequential-uuids plug-in is supported.
    • Version 1.1.9 of the EncDB plug-in is supported.
    • Version 4.6 of Ganos is supported. 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 raster function is added. This function is used 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 plug-ins.
    • 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:
20211130 PostgreSQL 13.5 is supported.
  • New features:
    • Version 4.4 of Ganos is supported. For more information, see Release notes for Ganos.
    • Version 3.1.4 of PostGIS is supported.
    • The pg_jieba plug-in is supported. This plug-in is used for Chinese tokenization.
    • The pldebugger plug-in is supported. This plug-in is used to debug stored procedures.
    • Version 2.5.0 of the TimescaleDB plug-in is supported.
    • The log_statement parameter can be configured for a session, a user, or a database.
  • Bug fixes:
    • The bug due to which privileged accounts do not have 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.
    • Ganos is optimized. After the optimization, the plug-ins of Ganos can be identified based on their descriptions and can be updated. For more information, see How do I update the plug-ins of Ganos?.
  • Bug fixes:

    The bug due to which the plug-ins of Ganos report errors when functions are invoked is fixed. This bug is triggered if the plug-ins of Ganos are not updated at the earliest opportunity.

20210930 PostgreSQL 13.1 is supported.
  • New features:
    • Version 4.1 of Ganos is supported. In version 4.1, some functions are added, and some functions are enhanced. For more information, see Release notes for Ganos.
    • The rdsutils plug-in is provided. This plug-in is a proprietary plug-in of Alibaba Cloud and provides the failove_slots view.
    • Version 1.3.8 of the RUM plug-in is supported.
    • Version 2.4.0 of the pglogical plug-in is supported.
    • Version 2.3.15 of the PLV8 plug-in is supported.
  • 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 plug-in causes memory leaks in some scenarios is fixed.
    • The bug due to which the pg_cron plug-in causes memory leaks in some scenarios is fixed.
20210531 PostgreSQL 13.1 is supported.
  • New features:
    • Version 3.8 of Ganos is supported.
      • The ST_AsDatasetFile function is added. This function is used to convert a specified part of a raster into a BYTEA-type file.
      • The ST_RasterDrivers function is added. This function is used 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 plug-in is supported. This plug-in provides logical streaming replication by using a publish/subscribe pattern.
    • The pgAudit plug-in is supported. This plug-in 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.
      Notice 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 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 plug-ins 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 plug-in accesses memory out of bounds in some scenarios is fixed.

20210331 PostgreSQL 13.1 is supported.
  • New features:
  • Bug fixes:

    The bug due to which the oss_fdw plug-in 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:
    • Version 3.6 of Ganos is supported.
    • The decoderbufs plug-in is supported. This plug-in is used to generate data that is compatible with the Debezium platform based on Protocol Buffers.
    • The pg_pathman plug-in is supported. This plug-in is used to improve the performance of partitioned tables.
    • The PLV8 plug-in is supported. This plug-in is a trusted JavaScript extension.
    • The oss_fdw plug-in is supported. This plug-in is used to read data from and write data to OSS buckets.
    • The mysql_fdw plug-in is supported. This plug-in is used to read data from 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 plug-in 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. For more information, see Logical Replication Slot Failover.
  • Performance improvements:

    The indexing and search features are optimized to adapt to large database systems.

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

PostgreSQL 12

Minor AliPG version Description
20220228 PostgreSQL 12.8 is supported.
  • New features:
    • Version 1.0.2 of the sequential-uuids plug-in is supported.
    • Version 1.18.0 of the MADlib plug-in is supported.
    • Version 1.1.9 of the EncDB plug-in is supported.
    • Version 4.6 of Ganos is supported. 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 raster function is added. This function is used 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 plug-ins.
    • 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:
20211130 PostgreSQL 12.8 is supported.
  • New features:
    • Version 4.4 of Ganos is supported. For more information, see Release notes for Ganos.
    • Version 3.1.4 of PostGIS is supported.
    • The pg_jieba plug-in is supported. This plug-in is used for Chinese tokenization.
    • The pldebugger plug-in is supported. This plug-in 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 plug-in causes memory leaks when users view the task records in the cron.job_log data table is fixed.
    • The bug due to which privileged accounts do not have 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.
    • Ganos is optimized. After the optimization, the plug-ins of Ganos can be identified based on their descriptions and can be updated. For more information, see How do I update the plug-ins of Ganos?.
  • Bug fixes:

    The bug due to which the plug-ins of Ganos report errors when functions are invoked is fixed. This bug is triggered if the plug-ins of Ganos are not updated at the earliest opportunity.

20210930 PostgreSQL 12.8 is supported.
  • New features:
    • Version 4.1 of Ganos is supported. In version 4.1, some functions are added, and some functions are enhanced. For more information, see Release notes for Ganos.
    • The rdsutils plug-in is provided. This plug-in is a proprietary plug-in of Alibaba Cloud and provides the failove_slots view.
    • Version 1.3.8 of the RUM plug-in is supported.
    • Version 1.5.12 of the pg_pathman plug-in is supported.
    • Version 2.4.0 of the pglogical plug-in is supported.
    • Version 2.3.15 of the PLV8 plug-in is supported.
    • The RDKit plug-in 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 VACCUM FULL pg_catalog.pg_attribute statement is executed is fixed.
    • The bug due to which the mysql_fdw plug-in causes memory leaks in some scenarios is fixed.
    • The bug due to which the pg_cron plug-in causes memory leaks in some scenarios is fixed.
20210531 PostgreSQL 12.4 is supported.
  • New features:
    • Version 3.8 of Ganos is supported.
      • The ST_AsDatasetFile function is added. This function is used to convert a specified part of a raster into a BYTEA-type file.
      • The ST_RasterDrivers function is added. This function is used 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 plug-in is supported. This plug-in provides logical streaming replication by using a publish/subscribe pattern.
    • The pgAudit plug-in is supported. This plug-in 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.
      Notice 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 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 plug-ins 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 plug-in accesses memory out of bounds in some scenarios is fixed.

20210331 PostgreSQL 12.4 is supported.
  • New features:
  • Bug fixes:

    The bug due to which the oss_fdw plug-in 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:
    • Version 3.6 of Ganos is supported.
    • The decoderbufs plug-in is supported. This plug-in is used to generate data that is compatible with the Debezium platform based on Protocol Buffers.
    • The pg_pathman plug-in is supported. This plug-in is used to improve the performance of partitioned tables.
    • The PLV8 plug-in is supported. This plug-in is a trusted JavaScript extension.
    • The oss_fdw plug-in is supported. This plug-in 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 plug-in 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:
    • Version 3.3 of Ganos is supported.
    • The pg_hint_plan plug-in is supported. This plug-in is used to add hints, which are used to change the query plans that are provided.
    • The zhparser plug-in is supported.
    • The RUM plug-in is supported. This plug-in is used to run full-text searches at high speeds.
    • The Bloom plug-in is supported.
    • The Logical Replication Slot Failover feature is supported. For more information, see Logical Replication Slot Failover.
  • Bug fixes:

    The bug that is caused by the conflict between the tds_fdw plug-in 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 plug-in is provided. After the update, this plug-in can be used to create and run cross-instance tasks. In addition, this plug-in provides a data table named cron.job_log from which users can view task records.
    • The pg_freespacemap plug-in is supported.
    • Spatio-temporal memory topology indexes are supported by Ganos.
    • Version 3.2 of Ganos is supported.
  • 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:
    • Version 3.0 of Ganos is supported.
    • The sql_firewall plug-in is supported. This plug-in is used to prevent malicious injection of SQL statements.
    • The pg_bigm plug-in is supported. This plug-in 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 plug-in cannot be installed or used in an expected manner is fixed.
    • The bug due to which the RDKit plug-in cannot be loaded when dependencies are not provided is fixed.
20200421 PostgreSQL 12.2 is supported.
  • New features:
    • Version 2.7 of Ganos is supported.
    • Version 2.14 of the hll plug-in is supported.
    • Version 2.9.0 of the PL/Proxy plug-in is supported.
    • Version 1.0 of the tsm_system_rows plug-in is supported.
    • Version 1.0 of the tsm_system_time plug-in is supported.
    • Version 1.0 of the smlar plug-in is supported.
    • Version 1.0 of the tds_fdw plug-in 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 plug-in is supported.
    • Version 2.6 of Ganos is supported.
  • Bug fixes:

    Some permission-related bugs are fixed.

20191230

New features:

  • The pg_roaringbitmap plug-in, RDKit plug-in, mysql_fdw plug-in, and Ganos are supported.
  • Privileged accounts are granted the permissions to publish all tables at a time and create subscriptions.

PostgreSQL 11

Minor AliPG version Description
20220228 PostgreSQL 11.13 is supported.
  • New features:
    • Version 1.0.2 of the sequential-uuids plug-in is supported.
    • Version 1.18.0 of the MADlib plug-in is supported.
    • Version 1.1.9 of the EncDB plug-in is supported.
    • Version 4.6 of Ganos is supported. 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 raster function is added. This function is used 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 plug-ins.
    • 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:
20211130 PostgreSQL 11.13 is supported.
  • New features:
    • Version 4.4 of Ganos is supported. For more information, see Release notes for Ganos.
    • Version 3.1.4 of PostGIS is supported.
    • The pg_jieba plug-in is supported. This plug-in is used for Chinese tokenization.
    • The pldebugger plug-in is supported. This plug-in 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 plug-in causes memory leaks when users view the task records in the cron.job_log data table is fixed.
    • The bug due to which privileged accounts do not have 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.
    • Ganos is optimized. After the optimization, the plug-ins of Ganos can be identified based on their descriptions and can be updated. For more information, see How do I update the plug-ins of Ganos?.
  • Bug fixes:

    The bug due to which the plug-ins of Ganos report errors when functions are invoked is fixed. This bug is triggered if the plug-ins of Ganos are not updated at the earliest opportunity.

20210930 PostgreSQL 11.13 is supported.
  • New features:
    • Version 4.1 of Ganos is supported. In version 4.1, some functions are added, and some functions are enhanced. For more information, see Release notes for Ganos.
    • The rdsutils plug-in is provided. This plug-in is a proprietary plug-in of Alibaba Cloud and provides the failove_slots view.
    • Version 1.3.8 of the RUM plug-in is supported.
    • Version 1.5.12 of the pg_pathman plug-in is supported.
    • Version 2.4.0 of the pglogical plug-in is supported.
    • Version 2.3.15 of the PLV8 plug-in is supported.
  • 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. ApsaraDB RDS no longer provides incomplete startup packet log records that are triggered by empty packets.
  • Bug fixes:
    • The bug due to which the mysql_fdw plug-in causes memory leaks in some scenarios is fixed.
    • The bug due to which the pg_cron plug-in causes memory leaks in some scenarios is fixed.
20210531 PostgreSQL 11.9 is supported.
  • New features:
    • Version 3.8 of Ganos is supported.
      • The ST_AsDatasetFile function is added. This function is used to convert a specified part of a raster into a BYTEA-type file.
      • The ST_RasterDrivers function is added. This function is used 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 plug-in is supported. This plug-in provides logical streaming replication by using a publish/subscribe pattern.
    • The pgAudit plug-in is supported. This plug-in 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.
      Notice 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 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 plug-ins 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 plug-in to index data out of bounds is fixed.
    • The bug due to which the oss_fdw plug-in accesses memory out of bounds in some scenarios is fixed.
20210331 PostgreSQL 11.9 is supported.
  • New features:
  • Bug fixes:

    The bug due to which the oss_fdw plug-in 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:
    • Version 3.6 of Ganos is supported.
    • The mysql_fdw plug-in is supported. This plug-in 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:
    • Version 3.3 of Ganos is supported.
    • The pg_hint_plan plug-in is supported. This plug-in is used to add hints, which are used to change the query plans that are provided.
    • The Bloom plug-in 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 plug-in 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 plug-in is provided. After the update, this plug-in can be used to create and run cross-instance tasks. In addition, this plug-in provides a table named cron.job_log from which users can view task records.
    • The pg_freespacemap plug-in is supported.
    • Spatio-temporal memory topology indexes are supported by Ganos.
    • Version 3.2 of Ganos is supported.
  • 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 CREATE EXTENSION statements 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:
    • Version 3.0 of Ganos is supported.
    • The sql_firewall plug-in is supported. This plug-in is used to prevent malicious injection of SQL statements.
    • The pg_bigm plug-in is supported. This plug-in is used to support fuzzy match.
    • The ZomboDB plug-in is supported. This plug-in 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 plug-in cannot be installed or used in an expected manner is fixed.
    • The bug in a global variable of the PASE plug-in is fixed.
20200610

New features:

  • The pageinspect plug-in is supported by the rds_superuser role.
  • The rds_superuser role can grant the REPLICATION permission to other users.
20200511
  • New features:

    Version 2.8 of Ganos is supported.

  • Bug fixes:

    The bug due to which the PASE plug-in 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. For more information, see Logical Replication Slot Failover.
  • Version 2.9.0 of the PL/Proxy plug-in is supported.
  • Version 1.0 of the tsm_system_rows plug-in is supported.
  • Version 1.0 of the tsm_system_time plug-in is supported.
  • Version 1.0 of the smlar plug-in is supported.
20200402
  • New features:
    • Version 2.14 of the hll plug-in is supported. This plug-in 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 plug-in is supported. This plug-in is used to store infrequently requested historical data to OSS buckets to reduce storage costs.
    • Version 2.0.1 of the tds_fdw plug-in is supported. This plug-in 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 plug-in is also used to migrate data between an RDS instance and a Sybase or SQL Server database.
  • Plug-in updates:
    • The plug-ins of Ganos are updated to version 2.7.
    • The wal2json plug-in is updated to version 2.2.
  • Performance improvements:

    The shutdown -m fast command is optimized.

20191218

New features:

  • The PASE plug-in is supported. This plug-in 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

Minor AliPG version Description
20220228 PostgreSQL 10.19 is supported.
  • New features:
    • Version 1.0.2 of the sequential-uuids plug-in is supported.
    • Version 1.1.9 of the EncDB plug-in is supported.
    • Version 4.6 of Ganos is supported. 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 raster function is added. This function is used 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 plug-ins.
    • 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:
20211130 PostgreSQL 10.19 is supported.
  • New features:
    • Version 4.4 of Ganos is supported. For more information, see Release notes for Ganos.
    • PostGIS is updated to version 3.1.4, which supports ApsaraDB RDS for PostgreSQL. For more information, visit the PostGIS page
    • The pg_jieba plug-in is supported. This plug-in is used for Chinese tokenization.
    • The pldebugger plug-in is supported. This plug-in 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 plug-in 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.
    • Ganos is optimized. After the optimization, the plug-ins of Ganos can be identified based on their descriptions and can be updated. For more information, see How do I update the plug-ins of Ganos?.
  • Bug fixes:

    The bug due to which the plug-ins of Ganos report errors when functions are invoked is fixed. This bug is triggered if the plug-ins of Ganos are not updated at the earliest opportunity.

20210930 PostgreSQL 10.14 is supported.
  • New features:
    • Version 4.1 of Ganos is supported. In version 4.1, some functions are added, and some functions are enhanced. For more information, see Release notes for Ganos.
    • The rdsutils plug-in is provided. This plug-in is a proprietary plug-in of Alibaba Cloud and provides the failove_slots view.
    • Version 1.3.8 of the RUM plug-in is supported.
    • Version 2.4.0 of the pglogical plug-in is supported.
    • Version 2.3.15 of the PLV8 plug-in is supported.
  • 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. ApsaraDB RDS no longer provides incomplete startup packet log records that are triggered by empty packets.
  • Bug fixes:
    • The bug due to which the mysql_fdw plug-in causes memory leaks in some scenarios is fixed.
    • The bug due to which the pg_cron plug-in causes memory leaks in some scenarios is fixed.
20210531 PostgreSQL 10.14 is supported.
  • New features:
    • Version 3.8 of Ganos is supported.
      • The ST_AsDatasetFile function is added. This function is used to convert a specified part of a raster into a BYTEA-type file.
      • The ST_RasterDrivers function is added. This function is used 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 plug-in is supported. This plug-in provides logical streaming replication by using a publish/subscribe pattern.
    • The pgAudit plug-in is supported. This plug-in 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.
      Notice 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 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 plug-ins 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 plug-in accesses memory out of bounds in some scenarios is fixed.

20210331 PostgreSQL 10.14 is supported.
  • New features:
  • Bug fixes:

    The bug due to which the oss_fdw plug-in 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 plug-in is supported.
  • The Logical Replication Slot Failover feature is supported. For more information, see Logical Replication Slot Failover.
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 plug-in is provided. After the update, this plug-in can be used to create and run cross-instance tasks. In addition, this plug-in provides a table named cron.job_log from which users can view task records.
    • The pg_freespacemap plug-in is supported.
    • Spatio-temporal memory topology indexes are supported by Ganos.
    • Version 3.2 of Ganos is supported.
  • 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 CREATE EXTENSION statements 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:
    • Version 3.0 of Ganos is supported.
    • The sql_firewall plug-in is supported. This plug-in is used to prevent malicious injection of SQL statements.
    • The pg_bigm plug-in is supported. This plug-in is used to support fuzzy match.
  • Bug fixes:

    The bug due to which the pg_cron plug-in 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 upgraded 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 plug-in cannot be installed is fixed.

PostgreSQL 9.4

Minor AliPG version Description
20210531

Performance improvements:

The major 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 plug-ins 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.

20201130

Bug fixes:

  • The CVE-2020-25694 vulnerability is fixed. This vulnerability may cause ApsaraDB RDS to lose security parameters when RDS instances are switched over to other connections. If security parameters are lost, these RDS instances are vulnerable to attacks.
  • 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.
  • The CVE-2020-25696 vulnerability is fixed. This vulnerability allows the gset command to overwrite the variables that are processed based on specified conditions.
20200623
  • New features:
    • Version 2.2 of the wal2json plug-in is supported.
    • Version 1.0 of the xml2 plug-in is supported.
  • Bug fixes:

    The bug due to which memory resources are exhausted when the wal2json plug-in runs is fixed.

20200210

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.

20190601

AliPG is upgraded to adapt to PostgreSQL 9.4.19.