This topic describes the release notes of minor AliPG versions.

If you want to use the new features that are provided in a minor AliPG version, you must upgrade your AliPG-running ApsaraDB RDS instance to that minor AliPG version. For more information, see the following topics:

PostgreSQL 13

Minor engine version Description
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 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
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:
    • New permissions are granted to privileged accounts. These permissions are used to create accounts that have the REPLICATION permission on data streams.
    • New permissions are granted to privileged accounts. These permissions are used 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 enable 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 uncontrollable 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 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.
  • 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 usercan 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.
  • Bugs fixed:

    Some permission-related bugs are fixed.

20191230

New features:

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

PostgreSQL 11

Minor engine version Description
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. Such 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:
    • New permissions are granted to privileged accounts. These permissions are used to create accounts that have the REPLICATION permission on data streams.
    • New permissions are granted to privileged accounts. These permissions are used 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 enable 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 uncontrollable 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 introduced 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 introduced 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.
  • New 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
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:
    • New permissions are granted to privileged accounts. These permissions are used to create accounts that have the REPLICATION permission on data streams.
    • New permissions are granted to privileged accounts. These permissions are used 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 enable 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 uncontrollable 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 introduced 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
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.