This topic describes the release notes of minor AliPG versions.

If you want to use the features that are supported by a minor AliPG version, you must upgrade the minor AliPG version that is running on your ApsaraDB RDS instance. For more information, see the following topics:

PostgreSQL 13

Minor engine version Description
20210531 The Community edition of PostgreSQL 13.1 is supported.
  • New features:
    • The Ganos plug-in is upgraded to version 3.8.
    • The pglogical plug-in is supported. This plug-in provides logical streaming replication for PostgreSQL by using a publish/subscribe pattern.
    • The pgAudit plug-in is supported. This plug-in is used to generate audit logs.
  • Feature optimization:
    • Permission management is optimized. When you execute the GRANT role1 TO role2 statement, role2 does not carry over the CREATEDB and CREATEROLE permissions from role1.
      Notice The CREATEDB and CREATEROLE permissions are also unavailable to the roles that you have authorized by executing the GRANT statement in earlier minor engine versions.
    • The pg_ls_waldir() function is supported for privileged accounts.
    • The monitoring and scanning features are optimized to improve CPU performance.
    • The feature that is used to upgrade a major engine version is optimized. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. The feature supports smooth upgrades of plug-ins such as PostGIS and pgRouting This feature also supports smooth upgrades of account permission management for an RDS instance that runs PostgreSQL 9.4.
    • When SQL statements cause insufficient memory or unexpected exits, the maximum length of each log record that is generated is increased from 1,024 bytes to 4,096 bytes.
  • Bug fixed:

    The bug that causes the oss_fdw plug-in to access memory out of bounds in some scenarios is fixed.

20210331 The Community edition of PostgreSQL 13.1 is supported.
  • New features:
  • Bug fixed

    The bug that prevents you from using the oss_fdw plug-in after a minor or major engine version upgrade is fixed.

20210228 The Community edition of PostgreSQL 13.1 is supported.
  • New features:
    • The Ganos plug-in is upgraded to version 3.6.
    • 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 and write data to an Object Storage Service (OSS) bucket.
    • The mysql_fdw plug-in is supported. This plug-in is used to read and write data to an ApsaraDB RDS for MySQL instance or a self-managed MySQL database.
    • The creation of event_trigger is supported for privileged accounts. You can use the privileged account of an AliPG-running RDS instance to configure the maximum length of log records for that RDS instance.
  • Bugs fixed:
    • The bug that prevents ApsaraDB RDS from displaying slow query logs as normal is fixed.
    • The bug that deprives a privileged account of the permissions to customize word libraries is fixed. This bug is triggered if you run the zhparser plug-in by using the privileged account.
    • The bug that causes log-related online alerts is fixed. This bug is triggered if the archive_mode parameter is set to on.
20201230 The Community edition of 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 allows ApsaraDB RDS to directly join partitioned tables. This reduces the overall time that is required to run a query. This feature also supports row-level BEFORE triggers and full logical replications.
    • An advanced hash aggregation feature is introduced. 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.
  • Performance optimization:

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

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

PostgreSQL 12

Minor engine version Description
20210531 The Community edition of PostgreSQL 12.4 is supported.
  • New features:
    • The Ganos plug-in is upgraded to version 3.8.
    • The pglogical plug-in is supported. This plug-in provides logical streaming replication for PostgreSQL by using a publish/subscribe pattern.
    • The pgAudit plug-in is supported. This plug-in is used to generate audit logs.
  • Feature optimization
    • Permission management is optimized. When you execute the GRANT role1 TO role2 statement, role2 does not carry over the CREATEDB and CREATEROLE permissions from role1.
      Notice The CREATEDB and CREATEROLE permissions are also unavailable to the roles that you have authorized by executing the GRANT statement in earlier minor engine versions.
    • The pg_ls_waldir() function is supported for privileged accounts.
    • The monitoring and scanning features are optimized to improve CPU performance.
    • The feature that is used to upgrade the major engine version is optimized. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. The feature supports smooth upgrades of plug-ins such as PostGIS and pgRouting The feature also supports smooth upgrades of account permission management for an RDS instance that runs PostgreSQL 9.4.
    • When SQL statements cause insufficient memory or unexpected exits, the maximum length of each log record that is generated is increased from 1,024 bytes to 4,096 bytes.
  • Bug fixed:

    The bug that causes the oss_fdw plug-in to access memory out of bounds in some scenarios is fixed.

20210331 The Community edition of PostgreSQL 12.4 is supported.
  • New features:
  • Bug fixed

    The bug that prevents you from using the oss_fdw plug-in after a minor or major engine version upgrade is fixed.

20210228 The Community edition of PostgreSQL 12.4 is supported.
  • New features:
    • The Ganos plug-in is upgraded to version 3.6.
    • 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 and write data to an OSS bucket.
  • Bugs fixed:
    • The bug that deprives a privileged account of the permissions to customize word libraries is fixed. This bug is triggered if you run the zhparser plug-in by using the privileged account.
    • The bug that causes log-related online alerts is fixed. This bug is triggered if the archive_mode parameter is set to on.
20201230 The Community edition of PostgreSQL 12.4 is supported.
  • New features:
    • The Ganos plug-in is upgraded to version 3.3.
    • The pg_hint_plan plug-in is supported. This plug-in is used to add hints that make PostgreSQL change provided query plans.
    • The zhparser plug-in is supported.
    • The RUM plug-in is supported. This plug-in is used to implement high-speed full-text search.
    • The Bloom plug-in is supported.
  • Bug fixed:

    The bug that is caused by the conflict between the tds_fdw plug-in and the plan cache is fixed.

20201130 The Community edition of PostgreSQL 12.4 is supported.
  • New features:
    • Some permissions are granted to privileged accounts. These permissions are used to create accounts that have the REPLICATION permission on data streams.
    • Privileged accounts are granted permissions to create triggers.
    • The rds_auditlog_max_query_length parameter is introduced. This parameter is used to specify the maximum length of SQL log records.
    • The pg_cron plug-in is upgraded. This plug-in is used to create and run cross-instance tasks. This plug-in also provides a table named cron.job_log. You can view the task records in this table.
    • The pg_freespacemap plug-in is supported.
    • Spatio-temporal memory topology indexes are supported by the Ganos plug-in.
    • The Ganos plug-in is upgraded to version 3.2.
  • Bugs fixed:
    • The bug that causes check errors when you migrate data by using Data Transmission Service (DTS) is fixed. These check errors occur if you start or commit more than one child transaction during the migration.
    • The CVE-2020-14349 vulnerability is fixed. This vulnerability prevents ApsaraDB RDS from properly cleaning search paths 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 invoke all SQL functions as a super user.
20200830 The Community edition of PostgreSQL 12.2 is supported.
  • New feature:
    • The Ganos plug-in is upgraded to version 3.0.
    • The sql_firewall plug-in is supported. This plug-in is used to prevent a malicious injection of SQL statements.
    • The pg_bigm plug-in is supported. This plug-in is used to implement fuzzy match.
  • Bugs fixed:
    • The bug that prevents the backend from identifying the rds_ prefix in parameters is fixed.
    • The bug that prevents you from properly installing and using the pg_cron plug-in is fixed.
    • The bug that prevents you from loading the RDKit plug-in due to the lack of dependencies is fixed.
20200421 The Community edition of PostgreSQL 12.2 is supported.
  • New features:
    • The Ganos plug-in is upgraded to version 2.7.
    • The hll plug-in of version 2.14 is supported.
    • The PL/Proxy plug-in of version 2.9.0 is supported.
    • The tsm_system_rows plug-in of version 1.0 is supported.
    • The tsm_system_time plug-in of version 1.0 is supported.
    • The smlar plug-in of version 1.0 is supported.
    • The tds_fdw plug-in of version 1.0 is supported.
  • Bug fixed:

    The bug that causes AliPG-running RDS instances to restart due to timed-out logical subscriptions is fixed.

20200221
  • New features:
    • The reservation for a specific number of connections is supported for the rds_superuser role. If a user assumes this role, the user can connect to an AliPG-running 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.
    • The Ganos plug-in is upgraded to version 2.6.
  • Bug fixed:

    Some permission-related bugs are fixed.

20191230

New features:

  • The pg_roaringbitmap, RDKit, mysql_fdw, and Ganos plug-ins are supported.
  • Permissions to publish all tables at a time and create subscriptions are granted to privileged accounts.

PostgreSQL 11

Minor engine version Description
20210531 The Community edition of PostgreSQL 11.9 is supported.
  • New features:
    • The Ganos plug-in is upgraded to version 3.8.
    • The pglogical plug-in is supported. This plug-in provides logical streaming replication for PostgreSQL by using a publish/subscribe pattern.
    • The pgAudit plug-in is supported. This plug-in is used to generate audit logs.
    • Supports the Create a fully encrypted database on an ApsaraDB RDS for PostgreSQL instance function. Data is encrypted on the user side and passed into the cloud database. This helps protect your services from external security threats and security threats within the cloud. This also helps protect user data at all times.
  • Feature optimization
    • Permission management is optimized. When you execute the GRANT role1 TO role2 statement, role2 does not carry over the CREATEDB and CREATEROLE permissions from role1.
      Notice The CREATEDB and CREATEROLE permissions are also unavailable to the roles that you have authorized by executing the GRANT statement in earlier minor engine versions.
    • The pg_ls_waldir() function is supported for privileged accounts.
    • The monitoring and scanning features are optimized to improve CPU performance.
    • The feature that is used to upgrade a major engine version is optimized. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. The feature supports smooth upgrades of plug-ins such as PostGIS and pgRouting The feature also supports smooth upgrades of account permission management for an RDS instance that runs PostgreSQL 9.4.
    • When SQL statements cause insufficient memory or unexpected exits, the maximum length of each log record that is generated is increased from 1,024 bytes to 4,096 bytes.
  • Bugs fixed:
    • The bug that causes the PASE plug-in to index out of bounds is fixed.
    • The bug that causes the oss_fdw plug-in to access memory out of bounds in some scenarios is fixed.
20210331 The Community edition of PostgreSQL 11.9 is supported.
  • New features:
  • Bug fixed

    The bug that prevents you from using the oss_fdw plug-in after a minor or major engine version upgrade is fixed.

20210228 The Community edition of PostgreSQL 11.9 is supported.
  • New features:
    • The Ganos plug-in is upgraded to version 3.6.
    • The mysql_fdw plug-in is supported. This plug-in is used to read and write data to an ApsaraDB RDS for MySQL instance or a self-managed MySQL database.
  • Bug fixed:

    The bug that causes log-related online alerts is fixed. This bug is triggered if the archive_mode parameter is set to on.

20201230 The Community edition of PostgreSQL 11.9 is supported.
  • New features:
    • The Ganos plug-in is upgraded to version 3.3.
    • The pg_hint_plan plug-in is supported. This plug-in used to add hints that make PostgreSQL change provided query plans.
    • The Bloom plug-in is supported.
  • Bugs fixed:
    • The bug that causes data loss in synchronous mode is fixed by optimizing the failover slot feature. This feature prevents data loss occurs in extreme circumstances if the failover slot feature is enabled. For more information, see Use the failover slot feature for logical subscriptions.
    • The bug that is caused by the conflict between the tds_fdw plug-in and the plan cache is fixed.
20201130 The Community edition of PostgreSQL 11.9 is supported.
  • New features:
    • Some permissions are granted to privileged accounts. These permissions are used to create accounts that have the REPLICATION permission on data streams.
    • Privileged accounts are granted permissions to create triggers.
    • The rds_auditlog_max_query_length parameter is introduced. This parameter is used to specify the maximum length of SQL log records.
    • The pg_cron plug-in is upgraded. This plug-in is used to create and run cross-instance tasks. This plug-in also provides a table named cron.job_log. You can view the task records in this table.
    • The pg_freespacemap plug-in is supported.
    • Spatio-temporal memory topology indexes are supported by the Ganos plug-in.
    • The Ganos plug-in is upgraded to version 3.2.
  • Bugs fixed:
    • The bug that causes check errors when you migrate data by using DTS is fixed. These check errors occur if you start or commit more than one child transaction during the migration.
    • The CVE-2020-14349 vulnerability is fixed. This vulnerability prevents ApsaraDB RDS from properly cleaning search paths 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 invoke all SQL functions as a super user.
20200830
  • New features:
    • The Ganos plug-in is upgraded to version 3.0.
    • The sql_firewall plug-in is supported. This plug-in is used to prevent a malicious injection of SQL statements.
    • The pg_bigm plug-in is supported. This plug-in is used to implement fuzzy match.
    • The ZomboDB plug-in is supported.This plug-in is used to implement text search and analysis.
  • Bugs fixed:
    • The bug that prevents the backend from identifying the rds_ prefix in parameters is fixed.
    • The bug that causes a secondary AliPG-running RDS instance to fail is fixed. This error occurs if the failover slot has the same name as the streaming replication slot.
    • The bug that prevents you from properly installing and using the pg_cron plug-in is fixed.
    • The bug in a global variable of the PASE plug-in is fixed.
20200610

New features:

  • The pageinspect plug-in is supported for the rds_superuser role.
  • The rds_superuser role is authorized to grant the REPLICATION permission to other users.
20200511
  • New feature:

    The Ganos plug-in is upgraded to version 2.8.

  • Bug fixed:

    The bug that causes the PASE plug-in to execute INSERT statements at low speeds based on Hierarchical Navigable Small World (HNSW) indexes is fixed.

20200421

New features:

20200402
  • New features:
    • The hll plug-in of version 2.14 is supported. This plug-in allows ApsaraDB RDS to support the HLL data type, respond to queries in milliseconds, and analyze approximate data at low costs and high speeds. For example, you can query page views (PVs) and unique visitors (UVs) in real time and determine whether the analyzed approximate data contains specified characteristic tags.
    • The oss_fdw plug-in of version 1.1 is supported. This plug-in is used to store infrequently requested historical data to OSS buckets. This reduces storage costs.
    • The tds_fdw plug-in of version 2.0.1 is supported. This plug-in is used 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.
  • Upgraded plug-ins:
    • The Ganos plug-in is upgraded to version 2.7.
    • The wal2json plug-in is upgraded to version 2.2.
  • Performance optimization:

    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.
  • Some permissions are granted to privileged accounts. These permissions are used to publish all tables at a time and create subscriptions.

PostgreSQL 10

Minor engine version Description
20210531 The Community edition of PostgreSQL 10.14 is supported.
  • New features:
    • The Ganos plug-in is upgraded to version 3.8.
    • The pglogical plug-in is supported. This plug-in provides logical streaming replication for PostgreSQL by using a publish/subscribe pattern.
    • The pgAudit plug-in is supported. This plug-in is used to generate audit logs.
  • Feature optimization
    • Permission management is optimized. When you execute the GRANT role1 TO role2 statement, role2 does not carry over the CREATEDB and CREATEROLE permissions from role1.
      Notice The CREATEDB and CREATEROLE permissions are also unavailable to the roles that you have authorized by executing the GRANT statement in earlier minor engine versions.
    • The pg_ls_waldir() function is supported for privileged accounts.
    • The monitoring and scanning features are optimized to improve CPU performance.
    • The feature that is used to upgrade a major engine version is optimized. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. The feature supports smooth upgrades of plug-ins such as PostGIS and pgRouting The feature also supports smooth upgrades of account permission management for an RDS instance that runs PostgreSQL 9.4.
    • When SQL statements cause insufficient memory or unexpected exits, the maximum length of each log record that is generated is increased from 1,024 bytes to 4,096 bytes.
  • Bug fixed:

    The bug that causes the oss_fdw plug-in to access memory out of bonds in some scenarios is fixed.

20210331 The Community edition of PostgreSQL 10.14 is supported.
  • New features:
  • Bug fixed

    The bug that prevents you from using the oss_fdw plug-in after a minor or major engine version upgrade is fixed.

20210228 The Community edition of PostgreSQL 10.14 is supported.
  • New feature:

    The Ganos plug-in is upgraded to version 3.6.

  • Bug fixed:

    The bug that causes log-related online alerts is fixed. This bug is triggered if the archive_mode parameter is set to on.

20201230 The Community edition of PostgreSQL 10.14 is supported.

New features:

  • The Ganos plug-in is upgraded to version 3.3.
  • The Bloom plug-in is supported.
20201130 The Community edition of PostgreSQL 10.14 is supported.
  • New features:
    • Some permissions are granted to privileged accounts. These permissions are used to create accounts that have the REPLICATION permission on data streams.
    • Privileged accounts are granted permissions to create triggers.
    • The rds_auditlog_max_query_length parameter is introduced. This parameter is used to specify the maximum length of SQL log records.
    • The pg_cron plug-in is upgraded. This plug-in is used to create and run cross-instance tasks. This plug-in also provides a table named cron.job_log. You can view the task records in this table.
    • The pg_freespacemap plug-in is supported.
    • Spatio-temporal memory topology indexes are supported by the Ganos plug-in.
    • The Ganos plug-in is upgraded to version 3.2.
  • Bugs fixed:
    • The bug that causes check errors when you migrate data by using DTS is fixed. These check errors occur if you start or commit more than one child transaction during the migration.
    • The CVE-2020-14349 vulnerability is fixed. This vulnerability prevents ApsaraDB RDS from properly cleaning search paths 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 invoke all SQL functions as a super user.
20200830 The Community edition of PostgreSQL 10.9 is supported.
  • New features:
    • The Ganos plug-in is upgraded to version 3.0.
    • The sql_firewall plug-in is supported. This plug-in is used to prevent a malicious injection of SQL statements.
    • The pg_bigm plug-in is supported. This plug-in is used to implement fuzzy match.
  • Bug fixed:

    The bug that prevents you from properly installing and using the pg_cron plug-in is fixed.

20200212 The Community edition of PostgreSQL 10.9 is supported.
  • New features:
    • The reservation for a specific number of connections is supported for the rds_superuser role. If a user assumes this role, the user can connect to an RDS instance to troubleshoot issues even if the number of established connections to the RDS instance reaches the upper limit.
    • The Ganos plug-in is upgraded to version 2.6.
  • Bug fixed:

    The bug that causes a long wait for streaming replication is fixed.

20190703 The Community edition of PostgreSQL 10.9 is supported.
  • New features:
    • AliPG is upgraded to version 10.9.
    • The change from synchronous replication to asynchronous replication is supported when the ongoing replication times out.
  • Bugs fixed:
    • The bug that prevents you from properly installing the pg_hint_plan plug-in is fixed.
    • The bug that causes external RUM indexing to fail is fixed.

PostgreSQL 9.4

Minor engine version Description
20210531

Feature optimization

The feature that is used to upgrade a major engine version is optimized. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. The feature supports smooth upgrades of plug-ins such as PostGIS and pgRouting The feature also supports smooth upgrades of account permission management for an RDS instance that runs PostgreSQL 9.4.

20201130

Bugs fixed:

  • The CVE-2020-25694 vulnerability is fixed. This vulnerability may cause ApsaraDB RDS to lose security parameters when AliPG-running 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 invoke all SQL functions as a super user.
  • 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:
    • The wal2json plug-in is upgraded to version 2.2.
    • The xml2 plug-in of version 1.0 is supported.
  • Bug fixed:

    The bug that causes memory exhaustion when the wal2json plug-in runs is fixed.

20200210

New feature:

The reservation for a specific number of connections is supported for the rds_superuser role. If a user assumes this role, the user can connect 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 version 9.4.19.