Release notes of minor AliPG versions

• New features:
  • The Community edition of PostgreSQL 13.1 is supported.
  • 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 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 allows ApsaraDB RDS to aggregate and group various types of data. This way, a query that requires ApsaraDB RDS to aggregate a large volume of data does not need to be run in the memory.
• Performance optimization:

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

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

• New features:
  • AliPG is upgraded to ensure compatibility with the Community edition of PostgreSQL 12.4.
  • New permissions are granted to privileged accounts. These permissions are used to create accounts that are authorized to replicate streams.
  • New permissions are granted to privileged accounts. These permissions are used to create triggers.
  • The rds_auditlog_max_query_length parameter is introduced. It allows you to specify the maximum length of SQL log records.
  • The pg_cron plug-in is upgraded. It allows you to create and execute cross-instance tasks. It also provides a table named cron.job_log. You can view task execution 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 Alibaba Cloud 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 include uncontrollable search path elements.
  • The CVE-2020-25695 vulnerability is fixed. This vulnerability allows you to create permanent objects and to invoke all SQL functions as a super user.

• New features:
  • The Ganos plug-in is upgraded to version 3.0.
  • The sql_firewall plug-in is introduced to prevent an injection of malicious SQL statements.
  • The pg_bigm plug-in is introduced to implement fuzzy match.
  • The TimescaleDB plug-in is introduced to process time series data.
• Bugs fixed:
  • The bug that prevents the backend from identifying the rds_ prefix in parameters is fixed.
  • The bug that prevents you from properly creating 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.

• New features:
  • AliPG is upgraded to ensure compatibility with the Community edition of PostgreSQL 12.2.
  • 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 RDS instances to restart due to timed-out logical subscriptions is fixed.

• New features:
  • The reservation for a specific number of connections is supported for the rds_superuser role. If you are authorized with this role, you 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 wal2json plug-in is supported.
  • The Ganos plug-in is upgraded to version 2.6.
• Bugs fixed:

  Some permission-related bugs are fixed.

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.

• New features:
  • AliPG is upgraded to ensure compatibility with the Community edition of PostgreSQL 11.9.
  • New permissions are granted to privileged accounts. These permissions are used to create accounts that are authorized to replicate streams.
  • New permissions are granted to privileged accounts. These permissions are used to create triggers.
  • The rds_auditlog_max_query_length parameter is introduced. It allows you to specify the maximum length of SQL log records.
  • The pg_cron plug-in is upgraded. It allows you to create and execute cross-instance tasks. It also provides a table named cron.job_log. You can view task execution 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 Alibaba Cloud 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 include uncontrollable search path elements.
  • The CVE-2020-25695 vulnerability is fixed. This vulnerability allows you to create permanent objects and to invoke all SQL functions as a super user.

• New features:
  • The Ganos plug-in is upgraded to version 3.0.
  • The sql_firewall plug-in is introduced to prevent an injection of malicious SQL statements.
  • The pg_bigm plug-in is introduced 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 RDS instance to exit 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 creating and using the pg_cron plug-in is fixed.
  • The bug in a global variable of the PASE plug-in is fixed.

New features:

• The TimescaleDB plug-in of version 1.7.1 is supported.
• The pageinspect plug-in is supported for the rds_superuser role.
• The rds_superuser role is authorized to grant the replication permissions to other users.

• New feature:

  The Ganos plug-in is upgraded to version 2.8.

• Bug fixed:

  The bug that causes the PASE plug-in to slowly run INSERT statements on HNSW indexes is fixed.

New features:

• The failover slot feature is supported. For more information, see Use the failover slot feature for logical subscriptions.
• 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.

• New features:
  • The HLL plug-in of version 2.14 is supported. It 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. It allows you to store infrequently requested historical data to Alibaba Cloud Object Storage Service (OSS) buckets. This reduces storage costs.
  • The tds_fdw plug-in of version 2.0.1 is supported. It allows you 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. It also allows you 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.

New features:

• The PASE plug-in is introduced to support 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.

• New features:
  • AliPG is upgraded to ensure compatibility with the Community edition of PostgreSQL 10.14.
  • New permissions are granted to privileged accounts. These permissions are used to create accounts that are authorized to replicate streams.
  • New permissions are granted to privileged accounts. These permissions are used to create triggers.
  • The rds_auditlog_max_query_length parameter is introduced. It allows you to specify the maximum length of SQL log records.
  • The pg_cron plug-in is upgraded. It allows you to create and execute cross-instance tasks. It also provides a table named cron.job_log. You can view task execution 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 Alibaba Cloud 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 include uncontrollable search path elements.
  • The CVE-2020-25695 vulnerability is fixed. This vulnerability allows you to create permanent objects and to invoke all SQL functions as a super user.

• New features:
  • The Ganos plug-in is upgraded to version 3.0.
  • The sql_firewall plug-in is introduced to prevent an injection of malicious SQL statements.
  • The pg_bigm plug-in is introduced to implement fuzzy match.
• Bug fixed:

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

• New features:
  • The reservation for a specific number of connections is supported for the rds_superuser role. If you are authorized with this role, you 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.

• 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 creating the pg_hint_plan plug-in is fixed.
  • The bug that causes external RUM indexing to fail is fixed.

Bugs fixed:

• 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, RDS instances may be attacked.
• The CVE-2020-25695 vulnerability is fixed. This vulnerability allows you to create permanent objects and to invoke all SQL functions as a super user.
• The CVE-2020-25696 vulnerability is fixed. This vulnerability allows the gset command to overwrite variables that are processed based on specified conditions.

• 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.

New feature:

The reservation for a specific number of connections is supported for the rds_superuser role. If you are authorized with this role, you can connect to an RDS instance to troubleshoot issues even if the number of established connections to the RDS instance reaches the upper limit.

AliPG is upgraded to version 9.4.19.