20221030 | PostgreSQL 11.17 is supported. - New features:
- Bug fixes:
None.
|
20220830 | PostgreSQL 11.16 is supported. |
20220730 | PostgreSQL 11.13 is supported. |
20220228 | PostgreSQL 11.13 is supported. |
20220130 | PostgreSQL 11.13 is supported. |
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 extension is supported. This extension is used for Chinese tokenization.
- The pldebugger extension is supported. This extension is used to debug stored procedures.
- The log_statement parameter can be configured for a session, a user, or a database.
- Bug fixes:
- The bug due to which the pg_cron extension causes memory leaks when users view the task records in the cron.job_log data table is fixed.
- The bug due to which privileged accounts do not have permissions to execute the
SHOW SHARED_PRELOAD_LIBRARIES statement is fixed. - The bug due to which standard accounts do not 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 extensions 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 extensions of Ganos report errors when functions are invoked is fixed. This bug is triggered if the extensions of Ganos are not updated at the earliest opportunity.
|
20210930 | PostgreSQL 11.13 is supported. - New features:
- 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 extension is provided. This extension is a proprietary extension of Alibaba Cloud and provides the failove_slots view.
- Version 1.3.8 of the RUM extension is supported.
- Version 1.5.12 of the pg_pathman extension is supported.
- Version 2.4.0 of the pglogical extension is supported.
- Version 2.3.15 of the PLV8 extension 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 extension causes memory leaks in some scenarios is fixed.
- The bug due to which the pg_cron extension causes memory leaks in some scenarios is fixed.
|
20210531 | PostgreSQL 11.9 is supported. - New features:
- 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 extension is supported. This extension provides logical streaming replication by using a publish/subscribe pattern.
- The pgAudit extension is supported. This extension is used to generate audit logs.
- The fully encrypted database feature is supported. This feature is used to encrypt data on the user side before the data is transmitted to RDS instances. This feature helps defend against security threats inside and outside the cloud to protect user data at all times.
- Performance improvements:
- Permission management is optimized. When the
GRANT role1 TO role2 statement is executed, role2 does not carry over the CREATEDB or CREATEROLE permission from role1.
Important The CREATEDB and CREATEROLE permissions are removed from the roles to which the GRANT statement is executed to grant these permissions. - Privileged accounts are granted the permissions to call the pg_ls_waldir() function.
- The scanning method that is used by the monitoring and alerting feature is optimized to improve CPU performance.
- The major version upgrade feature is optimized. For more information, see Upgrade the major engine version of an ApsaraDB RDS for PostgreSQL instance. This feature can be used to update extensions such as postgis and pgRouting with no downtime. This feature can also be used to update account permissions from PostgreSQL 9.4 to a later version with no downtime.
- The maximum length per log record is increased from 1,024 bytes to 4,096 bytes when SQL statements cause insufficient memory or unexpected exits.
- Bug fixes:
- The bug that causes the PASE extension to index data out of bounds is fixed.
- The bug due to which the oss_fdw extension accesses memory out of bounds in some scenarios is fixed.
|
20210331 | PostgreSQL 11.9 is supported. |
20210228 | PostgreSQL 11.9 is supported. |
20201230 | PostgreSQL 11.9 is supported. - New features:
- Version 3.3 of Ganos is supported.
- The pg_hint_plan extension is supported. This extension is used to add hints, which are used to change the query plans that are provided.
- The Bloom extension is supported.
- Bug fixes:
- The bug that causes data loss in synchronous mode is fixed by optimizing the Logical Replication Slot Failover feature. This feature can help prevent data loss even in extreme circumstances. For more information, see Logical Replication Slot Failover.
- The bug that is caused by the conflict between the tds_fdw extension and the plan cache is fixed.
|
20201130 | PostgreSQL 11.9 is supported. - New features:
- Privileged accounts are granted the permissions to create accounts that have the REPLICATION permission on data streams.
- Privileged accounts are granted the permissions to create event triggers.
- The rds_auditlog_max_query_length parameter is added. This parameter specifies the maximum length per audit log record.
- An updated pg_cron extension is provided. After the update, this extension can be used to create and run cross-instance tasks. In addition, this extension provides a table named cron.job_log from which users can view task records.
- The pg_freespacemap extension is supported.
- Spatio-temporal memory topology indexes are supported by Ganos.
- 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 extension is supported. This extension is used to prevent malicious injection of SQL statements.
- The pg_bigm extension is supported. This extension is used to support fuzzy match.
- The ZomboDB extension is supported. This extension is used to support text search and analysis.
- Bug fixes:
- The bug due to which the backend cannot identify the
rds_ prefix in parameters is fixed. - The bug due to which a secondary RDS instance unexpectedly exits when the failover slot has the same name as the streaming replication slot is fixed.
- The bug due to which the pg_cron extension cannot be installed or used in an expected manner is fixed.
- The bug in a global variable of the PASE extension is fixed.
|
20200610 | New features: - The pageinspect extension is supported by the rds_superuser role.
- The rds_superuser role can grant the REPLICATION permission to other users.
|
20200511 | |
20200421 | New features: - The Logical Replication Slot Failover feature is supported.
- Version 2.9.0 of the PL/Proxy extension is supported.
- Version 1.0 of the tsm_system_rows extension is supported.
- Version 1.0 of the tsm_system_time extension is supported.
- Version 1.0 of the smlar extension is supported.
|
20200402 | |
20191218 | New features: - The PASE extension is supported. This extension provides indexes that are used to recognize images.
- Privileged accounts are granted the permissions to publish all tables at a time and create subscriptions.
|