All Products
Search
Document Center

ApsaraDB RDS:Release notes for ApsaraDB RDS for PostgreSQL

Last Updated:Jun 17, 2025

This topic describes the release notes for ApsaraDB RDS for PostgreSQL and provides links to the relevant references.

Note

For information about updates in minor engine versions, see Release notes for AliPG (PostgreSQL 14-17).

2025

June

Category

Feature

Description

Release date

References

New feature

New minor engine version

Version 20250430 of AliPG is released.

  • New features

    • The following extensions are supported for RDS instances that run PostgreSQL 17: rds_ai (1.0.0), RUM (1.3), pg_cron (1.6), and pg_partman (5.2.4).

    • The rds_ai extension of version 1.0.0 is supported for RDS instances that run PostgreSQL 14 and PostgreSQL 15.

    • The rds_ccl extension of version 1.2 is supported for RDS instances that run PostgreSQL 13.

  • Bug fixes

    • The security vulnerabilities of the pg_cron extension are fixed for RDS instances that run PostgreSQL 11 to PostgreSQL 16. The extension can be created for these instances.

    • Known issues are fixed.

06-13

New feature

Global Active Database (GAD)

To ensure business continuity and high availability (HA), RDS for PostgreSQL supports Global Active Database (GAD) to provide disaster recovery capabilities. This feature delivers a one-stop, cost-effective cross-region disaster recovery solution based on Data Transmission Service (DTS) and the native physical replication feature of RDS for PostgreSQL. In the solution, a primary instance and a secondary instance are added to a GAD instance group. Data is synchronized from the primary instance to the secondary instance in real time by using DTS. This achieves cross-region disaster recovery and allows users to access data from the nearest region.

06-13

Global Active Database

May

Category

Feature

Description

Release date

References

New feature

Major engine version upgrade

RDS for PostgreSQL supports the zero-downtime upgrade mode in addition to the existing blue-green deployment and local upgrade modes. You can select an upgrade mode that is suitable for your business.

05-21

Upgrade the major engine version

March

Category

Feature

Description

Release date

References

New feature

New minor engine version

Version 20250228 of AliPG is released.

  • New features

    • The rds_duckdb extension of version 1.3 is supported by RDS instances that run PostgreSQL 15 to support automatic incremental synchronization of column-oriented tables.

    • The rds_ccl extension of version 1.2 is supported by RDS instances that run PostgreSQL 14, PostgreSQL 15, PostgreSQL 16, and PostgreSQL 17 to support the search_path parameter.

    • The rds_encdb extension of version 1.0 is supported by RDS instances that run PostgreSQL 16.

  • Bug fixes

    Known issues are fixed.

03-18

Release notes for AliPG (PostgreSQL 14-17)

February

Category

Feature

Description

Release date

References

New feature

Column encryption

The column encryption feature provided by Data Security Center (DSC) is supported to encrypt sensitive columns.

02-21

Use the column encryption feature

January

Category

Feature

Description

Release date

References

New feature

rds_ai

ApsaraDB RDS for PostgreSQL now supports the rds_ai extension. This extension integrates the advanced models of Alibaba Cloud Model Studio, including Qwen and the text embedding model. You can use this extension in various scenarios, such as LLM-based Q&A, conversion based on text embedding, top N similar vector retrieval, and Q&A based on retrieval-augmented generation (RAG). The rds_ai extension also supports custom models. You can add required models by using rds_ai to implement various AI-based applications in RDS for PostgreSQL.

01-14

Available soon

New feature

New minor engine version

Version 20241230 of AliPG is released.

  • New features

    • The pgsql-http extension of version 1.6 is supported by RDS instances that run PostgreSQL 16.

    • The rds_ai extension of version 1.0 is supported by RDS instances that run PostgreSQL 16.

    • The pgsql-gzip extension of version 1.0.0 is supported by RDS instances that run PostgreSQL 16 and 17.

    • The pgvector extension is upgraded to version 0.8.0.

    • The pg_hint_plan extension is upgraded.

    • The rds_duckdb extension supports the synchronization of incremental DML operations.

    • The automatic time column update feature is supported.

  • Bug fixes

    Known issues are fixed.

01-14

Release notes for AliPG (PostgreSQL 14-17)

2024

November

Category

Feature

Description

Release date

References

New feature

Instance types of read-only RDS instances

The read-only instances of ApsaraDB RDS for PostgreSQL standard instances offer dedicated instance types that provide more resources

11-26

[New features/New specifications] The read-only instances of ApsaraDB RDS for PostgreSQL standard instances offer dedicated instance types that provide more resources

Feature optimization

Cloud disk encryption

You can enable or disable the cloud disk encryption feature and modify its configurations for your RDS for PostgreSQL instance in the console.

11-22

Use the cloud disk encryption feature

New feature

Instance types of the primary RDS instance

The primary instance of ApsaraDB RDS for PostgreSQL standard instances that run RDS High-availability Edition offers dedicated instance types that provide more resources

11-21

[New features/New specifications] The primary instance of ApsaraDB RDS for PostgreSQL standard instances that run RDS High-availability Edition offers dedicated instance types that provide more resources

New feature

New minor engine version

Version 20241030 of AliPG is released.

  • New features:

    • Some extensions are supported by RDS instances that run PostgreSQL 17.

    • The rds_duckdb extension of version 1.1 is supported by RDS instances that run PostgreSQL 12, PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, PostgreSQL 16, and PostgreSQL 17.

    • GanosBase extensions are updated to version 6.9 for RDS instances that run PostgreSQL 12, PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, and PostgreSQL 16, and are updated to version 7.0 for RDS instances that run PostgreSQL 17.

  • Bug fixes:

    Known issues are fixed.

11-19

Release notes for AliPG (PostgreSQL 14-17)

October

Category

Feature

Description

Release date

References

New feature

Instance stopping

You can call the StopDBInstance operation to stop an ApsaraDB RDS for PostgreSQL instance. After an RDS instance is stopped, the compute resources of the instance are released. You are not charged for the instance type. This way, your cost is reduced.

10-22

New feature

Support for PostgreSQL 17

ApsaraDB RDS for PostgreSQL supports PostgreSQL 17.

10-17

Features

September

Category

Feature

Description

Release date

References

New feature

rds_duckdb

The rds_duckdb extension of ApsaraDB RDS for PostgreSQL that is used to implement analytical processing (AP) query acceleration is supported. When you run a complex query and want to quickly obtain query results, you can use the rds_duckdb extension. The extension exports local tables as column-oriented tables and uses vectorization capabilities to significantly accelerate complex queries without the need to modify original query statements. This allows you to obtain the query results in a convenient and efficient manner.

Important

The rds_duckdb extension is available for users in the whitelist. If you want to use the extension, contact us.

09-27

Use the rds_duckdb extension to implement AP query acceleration

New feature

New minor engine version

Version 20240830 of AliPG is released.

  • New feature:

    Some extensions are supported and updated.

  • Bug fixes:

    Known issues are fixed.

09-27

Release notes for AliPG (PostgreSQL 14-17)

New feature

Disaster recovery deployment

The disaster recovery feature is provided, and disaster recovery RDS instances can be created in a different region than the region of the original RDS instance to achieve geo-disaster recovery. This helps ensures business continuity and high availability. You can create disaster recovery RDS instances for self-managed instances that are not deployed on clouds or instances that are managed on other clouds to provide disaster recovery in the cloud and multi-cloud disaster recovery.

09-25

Disaster recovery solutions

Feature optimization

Extension management

The Extension Overview tab is upgraded to the Extension Marketplace tab.

09-03

Manage extensions

August

Category

Feature

Description

Release date

References

Feature optimization

Major engine version upgrade

The upgrade mode during the cutover is optimized. Local upgrade and blue-green deployment are supported.

  • Local upgrade: The major engine version upgrade is performed on the original RDS instance, and no new RDS instance is created.

  • Blue-green deployment: After the major engine version of the RDS instance is upgraded, the original RDS instance is retained and a new RDS instance is created.

08-28

Upgrade the major engine version

New feature

New minor engine version

Version 20240730 of AliPG is released.

  • New feature

    The tds_fdw extension is updated to version 2.0.3 for RDS instances that run PostgreSQL 11 and PostgreSQL 12.

  • Bug fixes:

    Known issues are fixed.

08-19

Release notes for AliPG (PostgreSQL 14-17)

New feature

RDS Cluster Edition

ApsaraDB RDS for PostgreSQL instances that run RDS Cluster Edition can be created. An RDS instance that runs RDS Cluster Edition is referred to as an RDS cluster. RDS Cluster Edition for ApsaraDB RDS for PostgreSQL uses an HA architecture that contains one primary node and multiple secondary nodes and supports compute-storage separation. RDS Cluster Edition provides the following features: automated failover, primary/secondary switchover, readable secondary nodes, node addition and deletion, multi-zone disaster recovery, node-level monitoring, and cluster topology management. An RDS cluster is more cost-effective, flexible, and reliable than a self-managed database.

08-09

RDS Cluster Edition

New feature

General Enterprise SSD (ESSD)

Serverless RDS instances that use general ESSDs can be created.

08-07

Create a serverless RDS instance

July

Category

Feature

Description

Release date

References

New feature

Cross-region backup and restoration

The cross-region backup and restoration feature is supported for ApsaraDB RDS for PostgreSQL instances for which cloud disk encryption is enabled. After the cross-region backup feature is enabled, the system automatically backs up the data of an RDS instance to a different region for regulation or disaster recovery.

07-24

June

Category

Feature

Description

Release date

References

New feature

Zero-ETL

The zero-ETL feature is provided to synchronize data from an ApsaraDB RDS for PostgreSQL instance to an AnalyticDB for PostgreSQL instance. You do not need to create or maintain data synchronization tasks, and you are not charged for data synchronization tasks. This reduces data transmission costs and O&M costs.

06-30

Use the zero-ETL feature

New feature

General Enterprise SSD (ESSD)

The general Enterprise SSD (ESSD) is a new storage type supported by ApsaraDB RDS. General ESSDs are compatible with all features of ESSDs and support the I/O burst, I/O acceleration, and data archiving features.

06-20

General ESSDs

Feature optimization

General Enterprise SSD (ESSD)

For RDS instances that use general ESSDs, the baseline IOPS is increased by up to 22,400, and the baseline I/O bandwidth is increased by up to 350 MB/s. The baseline I/O performance includes the performance of baseline IOPS and baseline I/O bandwidth.

06-20

[Product changes/Feature changes] The baseline I/O performance of the Premium ESSDs of ApsaraDB RDS instances is increased

New feature

New minor engine version

Version 20240530 of AliPG is released.

  • New feature

    • Version 0.0.10 of the pg_proctab extension is supported.

    • The pgvector extension that is used to perform high-dimensional vector similarity searches is updated to version 0.7.0. For more information, see Use the pgvector extension.

  • Bug fixes:

    Known issues are fixed.

06-13

Release notes for AliPG (PostgreSQL 14-17)

April

Category

Feature

Description

Release date

References

New feature

ApsaraDB RDS buy page of the new version

The ApsaraDB RDS buy page of the new version is available. Compared with the old version, the new version simplifies and accelerates instance creation.

04-29

Create an RDS instance

New feature

Backup download

The backup file of an RDS instance that uses the ESSD storage type can be downloaded in the CSV format with headers. This helps you analyze data or archive data to an on-premises device. In addition, the data of an RDS instance can be restored to a self-managed PostgreSQL instance by using the backup file in the CSV or SQL format.

04-15

March

Category

Feature

Description

Release date

References

Feature optimization

Major engine version upgrade

The major engine version of a serverless RDS instance can be upgraded.

03-21

Upgrade the major engine version

New feature

New minor engine version

Version 20240229 of AliPG is released.

  • The extensions of GanosBase are updated to version 6.3.

  • The pg_squeeze extension is updated to version 1.6 for RDS instances that run PostgreSQL 11, PostgreSQL 12, PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, and PostgreSQL 16.

  • The versions of some extensions are updated.

03-21

Release notes for AliPG (PostgreSQL 14-17)

New feature

Restoration of individual databases and tables

The restoration feature for individual databases and tables is supported for RDS instances. This feature allows you to restore only specific databases to new RDS instance by backup set or point in time. This feature can be used in scenarios when misoperations are performed and data needs to be quickly restored or when historical data needs to be analyzed.

03-15

Restore individual databases and tables

Feature optimization

Serverless

Physical replication and logical replication are supported for serverless RDS instances.

03-14

Overview

New feature

Change of a billing method

The billing method of an RDS instance can be changed between pay-as-you-go to serverless.

03-13

January

Category

Feature

Description

Release date

References

Feature optimization

Enhanced SSD (ESSD)

The maximum storage capacity of an RDS instance that uses ESSDs of performance level 1 (PL1), PL2, or PL3 is changed from 32 TB to 64 TB.

01-29

New feature

Serverless

Serverless RDS instances that run PostgreSQL 16 are supported.

01-17

Create a serverless RDS instance

New feature

New minor engine version

Version 20231230 of AliPG is released.

  • The extensions of GanosBase are updated to version 6.0.

  • The rds_embedding extension is supported on RDS instances that run PostgreSQL 14 and PostgreSQL 15.

  • Global parameters can be configured for the Transparent Data Encryption (TDE) feature for RDS instances that run PostgreSQL 13. After you configure global parameters, new tables and indexes are encrypted by default.

01-05

Release notes for AliPG (PostgreSQL 14-17)

2023

December

Category

Feature

Description

Release date

References

New feature

Database proxy

The general-purpose database proxies in ApsaraDB RDS for PostgreSQL are provided free of charge.

12-22

database proxy

New feature

Backup download

The backup files of RDS instances that use PL2 ESSDs or PL3 ESSDs can be downloaded.

12-18

Download the backup files of an RDS instance

New feature

Support for PostgreSQL 16

PostgreSQL 16 is supported in ApsaraDB RDS for PostgreSQL and is compatible with ApsaraDB RDS for PostgreSQL.

12-07

Capability

New feature

Serverless

PostgreSQL 15 is supported for serverless RDS instances.

12-06

Create a serverless RDS instance

November

Category

Feature

Description

Release date

References

New feature

New minor engine version

Version 20231030 of AliPG is released.

  • PostgreSQL 14 and PostgreSQL 15:

    • The transparent page compression (TPC) feature is supported to compress and decompress page data in a buffer pool in real time. This reduces storage costs and improves I/O throughput. For more information about TPC, see Use the TPC feature.

    • Global parameters can be configured for the TDE feature. After you configure global parameters, new tables and indexes are encrypted by default. For more information, see Configure TDE.

11-20

Release notes for AliPG (PostgreSQL 14-17)

New feature

Babelfish for RDS PostgreSQL

Babelfish can be enabled for an RDS instance that runs PostgreSQL 15. You can enable Babelfish when you create an RDS instance.

11-06

Enable Babelfish for an RDS instance

October

Category

Feature

Description

Release date

References

Feature optimization

Fast individual database and table restoration

The fast restoration feature for individual databases and tables is supported for RDS instances that reside in different regions.

10-30

Restore individual databases and tables of an RDS instance

September

Category

Feature

Description

Release date

References

New feature

Always-confidential database (basic edition)

The feature does not depend on special hardware conditions and is suitable for RDS instances that do not use Intel SGX-based security-enhanced instance types. The feature is used together with the always-confidential access control module to limit the ability of database users to manipulate data within a database. This prevents unauthorized access and ensures that your data is available but invisible to all database users, including DBAs. The feature allows you to use the index acceleration extension, more encryption data types, more operators, and more clauses.

09-28

Always-confidential databases

New feature

Always-confidential database (hardware-enhanced edition)

The feature is supported for RDS instances that use Intel SGX-based security-enhanced instance types in some regions. The feature can be used to encrypt sensitive data columns in database tables. This way, the sensitive data is transmitted, computed, and stored in ciphertext. The feature leverages hardware advantages to provide you with TEE-based data protection. TEE is short for trusted execution environment.

The feature is supported in the following regions and zones: Hong Kong Zone B, Hong Kong Zone D, Shanghai Zone B, Shanghai Zone L, Beijing Zone I, Beijing Zone K, and Hangzhou Zone K.

09-28

Always-confidential databases

New feature

New minor engine version

Version 20230830 of AliPG is released.

  • PostgreSQL 14 and PostgreSQL 15:

    • The cache eviction feature is supported.

    • Version 1.1.0 of the postgresql_anonymizer extension is supported.

    • The pgvector extension is updated to version 0.5.0 and supports Hierarchical Navigable Small World (HNSW) indexes, construction of IVFFLAT parallel indexes, element-by-element multiplication of vectors, L1 distance functions, and sum aggregation.

  • The extensions of GanosBase are updated to version 5.8 for PostgreSQL 10, PostgreSQL 11, PostgreSQL 12, PostgreSQL 13, PostgreSQL 14, and PostgreSQL 15. For more information, see Release notes for GanosBase.

09-13

Release notes for AliPG (PostgreSQL 14-17)

August

Category

Feature

Description

Release date

References

Feature optimization

Backup and restoration

The tabs on the Backup and Restoration page of an RDS instance are adjusted. The Data Backup and Log Backup tabs are moved to the Base Backups tab. The original Backup Settings tab is renamed as Backup Strategy. This does not affect the original features. The changes aim to simplify and optimize the operations on the Backup and Restoration page to improve user experience.

08-15

Use the backup and restoration feature

New feature

Serverless RDS instances on RDS High-availability Edition

Serverless RDS instances that run RDS High-availability Edition are supported.

08-11

Create a serverless RDS instance

Feature optimization

Backup and restoration

The tabs on the Backup and Restoration page of an RDS instance are adjusted. The original Archived Logs tab is renamed as Log Backup. This does not affect the original features. The changes aim to simplify and optimize the operations on the Backup and Restoration page to improve user experience.

08-09

Use the backup and restoration feature

Feature optimization

Cross-zone migration

The feature that allows you to separately migrate the zone of a secondary RDS instance is supported for RDS instances that use cloud disks.

08-03

Use the cross-zone migration feature

New feature

New minor engine version

Version 20230730 of AliPG is released.

Known issues in PostgreSQL 15 are fixed.

08-01

Release notes for AliPG (PostgreSQL 14-17)

July

Category

Feature

Description

Release date

References

New feature

Extension management

Extensions that are supported by ApsaraDB RDS for PostgreSQL can be managed in the ApsaraDB RDS console.

07-20

Manage extensions

Feature optimization

Storage capacity reduction for RDS instances with cloud disks

The storage capacity of a serverless RDS instance that uses cloud disks can be reduced.

07-20

Reduce the storage capacity of an ApsaraDB RDS for PostgreSQL instance that uses cloud disks

New feature

New minor engine version

Version 20230630 of AliPG is released.

A new feature that allows you to specify whether to use default dictionaries during the searches is supported for the pg_jieba Chinese word segmentation extension in PostgreSQL 14 and PostgreSQL 15.

07-11

Release notes for AliPG (PostgreSQL 14-17)

New feature

PgBouncer

The connection pooling feature is supported for ApsaraDB RDS for PostgreSQL. This feature reduces the impacts caused by frequent connection establishment and closing on the performance of RDS instances.

07-05

Enable or disable the connection pooling feature

June

Category

Feature

Description

Release date

References

New feature

New minor engine version

Version 20230530 of AliPG is released.

  • Version 4.7.3 of the pg_partman extension is supported by PostgreSQL 12, PostgreSQL 13, PostgreSQL 14, and PostgreSQL 15.

  • The pg_cron extension is updated to version 1.5 for PostgreSQL 13, PostgreSQL 14, and PostgreSQL 15.

  • The extensions of GanosBase are updated to version 5.6 for PostgreSQL 11, PostgreSQL 12, PostgreSQL 13, PostgreSQL 14, and PostgreSQL 15. For more information, see Release notes for GanosBase.

06-08

Release notes for AliPG (PostgreSQL 14-17)

Feature optimization

Update of minor engine versions

The policy to update minor engine versions can be configured for RDS instances that use cloud disks. If the minor engine version of your RDS instance is earlier than the latest minor engine version, the system automatically updates the minor engine version within the maintenance window that you specified.

06-08

Update the minor engine version of an RDS instance

New feature

Instance types for RDS Basic Edition

The dedicated instance types are supported for RDS instances that run RDS Basic Edition. This helps meet various business requirements.

06-02

Primary RDS instance types

May

Category

Feature

Description

Release date

References

Feature optimization

Serverless

The automatic start and stop feature can be configured for serverless RDS instances. The scaling policies of these RDS instances can be modified.

05-18

New feature

New minor engine version

Version 20230430 of AliPG is released.

05-16

Release notes for AliPG (PostgreSQL 14-17)

April

Category

Feature

Description

Release date

References

New feature

Fast individual database and table restoration

This feature is supported for RDS instances that use cloud disks. This feature allows you to restore only specific databases to the original RDS instance by backup set or point in time. This feature can be used in scenarios when misoperations are performed and data needs to be quickly restored or when historical data needs to be analyzed.

04-12

Restore individual databases and tables of an RDS instance

New feature

New minor engine version

Version 20230330 of AliPG is released.

  • Version 1.0 of the rds_ccl self-developed extension is supported by PostgreSQL 14 and PostgreSQL 15. You can use the extension for SQL throttling.

  • The TimescaleDB extension in PostgreSQL 14 is updated to version 2.9.2.

  • Some known issues are fixed.

04-12

Release notes for AliPG (PostgreSQL 14-17)

Feature optimization

Specification change

The storage capacity of an RDS instance that uses cloud disks can be used by changing specifications.

04-11

Change the specifications

New feature

Official release of serverless RDS instances

Serverless RDS instances are a new deployment model for RDS instances equipped with cloud disks, allowing you to scale CPU and memory resources in real time. This deployment model allows pay-as-you-go billing for computing resources, and allows you to quickly and independently scale computing resources to adapt to fluctuating workloads. These benefits simplify rightsizing your RDS instances, helping you reduce costs and improve efficiency.

04-10

[New features/New specifications] Serverless ApsaraDB RDS for PostgreSQL instances are available for commercial use

March

Category

Feature

Description

Release date

References

New feature

WAL log management

In ApsaraDB RDS for PostgreSQL, inactive replication slots can be deleted in the ApsaraDB RDS console or by calling API operations. This helps reduce the storage that is occupied by WAL logs.

03-30

Manage WAL logs

Feature optimization

Specification change

The architecture of an RDS instance can be changed between x86 and ARM.

03-22

Change the specifications

Feature optimization

Instance creation

An instance port is specified for an RDS instance when you create the RDS instance.

03-16

Create an RDS instance

New feature

New minor engine version

Version 20230228 of AliPG is released.

03-07

Release notes for AliPG (PostgreSQL 14-17)

January

Category

Feature

Description

Release date

References

New feature

New minor engine version

Version 20221230 of AliPG is released.

  • Version 0.0.1 of the PASE extension is supported for RDS instances that run PostgreSQL 12, PostgreSQL 13, PostgreSQL 14, or PostgreSQL 15.

  • The extensions of GanosBase are updated to version 5.3.

  • Version 1.1.12 of the EncDB extension is supported.

  • Version 3.3.2 of the PostGIS extension is supported.

01-17

Release notes for AliPG (PostgreSQL 14-17)

New feature

Task Center

Task Center is supported. After you perform operations on your RDS instance, you can view the task progress and historical task details on the Task Center page in the ApsaraDB RDS console. You can also specify and change the switching time of your workloads for specific tasks on the Task Center page.

01-03

Use Task Center

New feature

Support for PostgreSQL 15

PostgreSQL 15 is supported and is compatible with PostgreSQL 15.1.

01-03

Capability

2022

December

Category

Feature

Description

Release date

References

New feature

Performance events

The performance events feature is provided. You can view the details and statistics of abnormal events, optimization events, and auto scaling events of an RDS instance. The events include the events that are planned to be executed, the events that are being executed, and the events that are completed.

12-30

View performance events

New feature

Support for PostgreSQL 15

PostgreSQL 15 is supported and is compatible with PostgreSQL 15.1.

12-16

Capability

New feature

ARM architecture

The ARM architecture is supported for RDS instances.

12-02

Architectures

November

Category

Feature

Description

Release date

References

New feature

TDE

This feature is supported to implement TDE for tables and indexes.

11-29

Overview

New feature

Self-service diagnostics

The self-service diagnostics feature is added. You can use the feature to troubleshoot both the internal IP addresses of Elastic Compute Service (ECS) instances and the public addresses of clients that are connected to your RDS instance.

11-28

Use the self-service diagnostics feature for an RDS instance

New feature

New minor engine version

Version 20221030 of AliPG is released.

11-24

Release notes for AliPG (PostgreSQL 14-17)

October

Category

Feature

Description

Release date

References

Feature optimization

New general-purpose instance type

Cloud migration is supported for new general-purpose instance types.

10-17

Use the cloud migration feature

New feature

Parameter template

ApsaraDB RDS for PostgreSQL allows you to use a parameter template to modify multiple parameters at a time and apply the modification to multiple RDS instances.

10-14

Use a parameter template

New feature

Advanced download

Advanced download tasks can be created for RDS instances that use cloud disks by point in time or backup file. You can set the download destination to a URL or directly write data to your OSS bucket.

10-11

Download the backup files of an RDS instance

September

Category

Feature

Description

Release date

References

New feature

Designation of preferred minor engine versions

  • A minor engine version can be specified for an RDS instance when you create the RDS instance.

  • The minor engine version to which you want to update for an RDS instance can be specified.

09-16

Feature optimization

Parameter configuration

Expressions can be used as parameter values for an RDS instance. If you set an instance type-related parameter to an expression, the value of the parameter dynamically changes when the instance type changes.

09-15

Modify the parameters of an RDS instance

New feature

Deletion of manual backup files

The manual backup files of an RDS instance can be deleted in the ApsaraDB RDS console.

09-14

Delete a backup file

Feature optimization

New general-purpose instance type

The following features are supported for RDS instances that use the new general-purpose instance types: connection to self-managed domains, upgrade from RDS Basic Edition to RDS High-availability Edition, and cross-zone instance migration.

09-09

New feature

New minor engine version

Version 20220830 of AliPG is released.

  • The EncDB extension is updated to version 1.1.1.

  • Version 1.1 of the oss_fdw extension is supported in PostgreSQL 14.

  • Version 2.5.0 of the TimescaleDB extension is supported in PostgreSQL 14.

09-01

Release notes for AliPG (PostgreSQL 14-17)

August

Category

Feature

Description

Release date

References

Feature optimization

Data replication mode change

The entry point to change the data replication mode of an RDS instance is provided in the ApsaraDB RDS console.

08-18

Change the data replication mode

New feature

New minor engine version

Version 20220730 of AliPG is released.

  • The extensions of GanosBase are updated to version 4.9. For more information, see Release notes for GanosBase.

  • The pg_jieba extension is supported for PostgreSQL 14. This extension supports custom dictionaries and allows you to switch between dictionaries.

  • The issue of the index_adviser failure that occurs when all indexing suggestions already exist is fixed.

  • PostgreSQL 10 allows you to use privileged accounts to execute the CREATE PUBLICATION xxx FOR ALL TABLES; statement.

08-05

Release notes for AliPG (PostgreSQL 14-17)

Feature optimization

Viewing of the enhanced monitoring metrics

More memory-related metrics can be viewed.

08-04

View enhanced monitoring

July

Category

Feature

Description

Release date

References

Feature optimization

Cross-zone migration

RDS instances that run RDS Basic Edition with cloud disks and use general-purpose instance types can be migrated across zones.

07-15

Use the cross-zone migration feature

Feature optimization

Database proxy

The database proxy feature is available in the Malaysia (Kuala Lumpur), Germany (Frankfurt), and US (Virginia) regions and more zones.

07-15

Enable the proxy feature.

New feature

High-frequency snapshot backup

The high-frequency snapshot backup is supported for RDS instances. You can set a snapshot backup frequency that ranges from 15 minutes to 12 hours to increase the backup frequency.

07-15

Use the high-frequency snapshot backup feature

Feature optimization

Babelfish for RDS PostgreSQL

Babelfish can be enabled for an RDS instance that runs PostgreSQL 14 when you create the RDS instance.

07-11

Introduction to Babelfish

Feature optimization

Specification change

  • The ESSD storage type can be downgraded from a higher PL to a lower PL when you change the specifications of an RDS instance. The ESSD storage type has three PLs: PL3, PL2, and PL1.

  • An RDS instance can be changed from a new general-purpose instance type to another instance type that can provide more than 16 cores. For more information, see Primary ApsaraDB RDS for PostgreSQL instance types.

    • The instance type of an RDS instance that runs RDS Basic Edition can be changed from a new general-purpose instance type to a general-purpose instance type.

    • The instance type of an RDS instance that runs RDS High-availability Edition can be changed from a new general-purpose instance type to a dedicated instance type.

07-07

Change the specifications

New feature

New general-purpose instance type

The new general-purpose instance types are available in the Japan (Tokyo) region.

07-07

Instance types for primary RDS instances

June

Category

Feature

Description

Release date

References

New feature

New minor engine version

Version 20220630 of AliPG is released.

  • The extensions of GanosBase are updated to version 4.7. For more information, see Release notes for GanosBase.

    • The ST_makeTrajectory function is enhanced to convert table rows to trajectory objects.

    • The ST_AsTable function is added to convert trajectory objects to tables.

  • The silent corruption of indexes caused by "CREATE INDEX CONCURRENTLY" / "REINDEX CONCURRENTLY" is fixed in PostgreSQL 14. For more information, see PostgreSQL 14.4 Released.

06-23

Release notes for AliPG (PostgreSQL 14-17)

Feature optimization

Major engine version upgrade

The storage capacity of an RDS instance that uses local disks can be decreased when you upgrade the major engine version of the RDS instance.

06-22

Upgrade the major engine version of an RDS instance

Feature optimization

Specification change

The storage type of an RDS instance that runs RDS Basic Edition and uses cloud disks can be changed.

06-17

Change the specifications

Feature optimization

Specification change

Specification changes immediately take effect and your workloads are not affected if you increase the storage capacity or change the PL of the ESSD storage type for an RDS instance.

06-14

Change the specifications

New feature

SSL encryption

SSL encryption is supported for the new general-purpose instance types.

06-09

Configure a cloud certificate to enable the SSL encryption feature

New feature

Automatic storage expansion

Automatic storage expansion is supported for RDS instances that use cloud disks.

When the percentage of the remaining storage of an RDS instance reaches the specified threshold, ApsaraDB RDS automatically expands the storage capacity of the RDS instance to ensure stable business operations.

06-02

Configure automatic storage expansion

Feature optimization

Babelfish for RDS PostgreSQL

The Babelfish management account can be initialized when you create an RDS instance and enable Babelfish during the creation.

06-02

Create an RDS instance for which Babelfish is enabled

May

Category

Feature

Description

Release date

References

Feature optimization

Database proxy (read/write splitting)

  • The database proxy feature is supported for the new general-purpose instance types.

  • The database proxy feature is available in the Hangzhou Zone J.

05-27

Enable the proxy feature.

Feature optimization

Data backup

The retention period of data backups can be changed for RDS instances that run PostgreSQL 10 on RDS Basic Edition.

  • Before the feature optimization, the retention period is seven days and cannot be changed.

  • After the feature optimization, you can specify a retention period that ranges from 7 to 730 days.

05-27

Back up an RDS instance

New feature

Performance center

The performance center feature is supported. On the Performance Center page of the ApsaraDB RDS console, you can use the features such as monitoring dashboards.

Note

ApsaraDB RDS supports the performance center feature from May 20, 2022.

05-20

Use the monitoring dashboard feature

New feature

Babelfish for RDS PostgreSQL

Babelfish can be enabled when you create an RDS instance. After you enable Babelfish for your RDS instance, you can use the RDS instance to parse and execute SQL Server T-SQL statements.

05-17

Introduction to Babelfish

New feature

Enterprise-level console

The enterprise-level ApsaraDB RDS console is released. You can use the enterprise-level ApsaraDB RDS console to modify multiple parameters, edit multiple tags, renew multiple instances, and modify multiple attributes at a time. This improves the experience of batch instance management.

05-11

New feature

Database proxy (read/write splitting)

The database proxy feature is supported. This feature supports automatic read/write splitting.

05-07

Introduction to database proxies

April

Category

Feature

Description

Release date

References

New feature

Read-only instance creation

Read-only RDS instances can be created for primary RDS instances that use new general-purpose instance types.

04-22

Create a read-only RDS instance

New feature

RAM policies

Resource Access Management (RAM) policies are used to manage the permissions of RAM users. The RAM policies involve 12 conditions.

04-14

Use RAM policies to manage the permissions of RAM users on ApsaraDB RDS instances

New feature

Major engine version upgrade

The major engine versions of RDS instances that use new general-purpose instance types can be upgraded.

04-14

Upgrade the major engine version of an RDS instance

Feature optimization

Price reduction for read-only RDS instances

The price of a read-only RDS instance that uses cloud disks is reduced.

04-12

March

Category

Feature

Description

Release date

References

New feature

New minor engine version

Version 20220228 of AliPG is released.

  • Version 1.0.2 of the sequential-uuids plug-in is supported.

  • The EncDB extension is updated to version 1.1.9.

  • The extensions of GanosBase are updated to version 4.6. For more information, see Release notes for GanosBase.

  • Standard accounts are granted the permissions to run the LOAD command to load the index_adviser and pg_hint_plan extensions.

  • Privileged accounts are granted the permissions to execute the CREATE ROLE statement to configure the BYPASSRLS parameter.

03-18

Release notes for AliPG (PostgreSQL 14-17)

Feature optimization

Cloud migration

The cloud migration feature can be used to migrate data between PostgreSQL instances over the Internet.

03-17

Use the cloud migration feature

Feature optimization

Primary/secondary switchover logs

The entry point to the primary/secondary switchover logs is moved from the Logs page to the Service Availability page of the ApsaraDB RDS console.

03-16

Switch workloads over between primary and secondary RDS instances

New feature

New instance types

New general-purpose instance types are released for RDS instances that run RDS High-availability Edition and use cloud disks.

03-15

Instance types for primary RDS instances

New feature

Instance release protection

If your RDS instance uses the pay-as-you-go billing method and runs critical workloads, you can enable the release protection feature for your RDS instance. This feature prevents your RDS instance from being manually released due to accidental operations or lack of communication among team members.

03-08

Enable or disable the release protection feature

Feature optimization

Recycle bin for manually released pay-as-you-go RDS instances

Pay-as-you-go RDS instances that are created for more than seven days can be moved to the recycle bin after they are manually released. You can re-create and destroy the pay-as-you-go RDS instances in the recycle bin.

03-07

Manage RDS instances in the recycle bin

February

Category

Feature

Description

Release date

References

Feature optimization

Cross-zone migration

An RDS instance that runs RDS High-availability Edition and uses cloud disks can be migrated to different zones.

02-24

Use the cross-zone migration feature

January

Category

Feature

Description

Release date

References

New feature

New minor engine version

Version 20220130 of AliPG is released.

  • Version 2.0 of the index_adviser extension is supported.

  • Version 1.3.1 of the hypopg extension is supported.

  • The extensions of GanosBase are updated to version 4.5. For more information, see Release notes for GanosBase.

  • The EncDB extension is updated to version 1.1.7. This extension is used to support fully encrypted databases.

  • Version 1.1 of the pg_cron extension is supported.

  • Version 0.5 of the roaringbitmap extension is supported.

01-30

Release notes for AliPG (PostgreSQL 14-17)

2021

December

Category

Feature

Description

Release date

References

Feature optimization

Creation of accounts and databases in RDS instances that use local disks

Accounts and databases can be created for RDS instances that use local disks in the ApsaraDB RDS console. Multiple privileged accounts can be created for each of these instances.

12-30

Create a database and an account

New feature

Support for PostgreSQL 14

PostgreSQL 14 is supported and is compatible with PostgreSQL 14.1.

12-24

Capability

New feature

Prohibition of creating RDS instances for which disk encryption is disabled

Users can attach a Resource Access Management (RAM) policy to a RAM user to prevent the RAM user from creating RDS instances for which disk encryption is not enabled.

12-20

Use RAM policies to manage the permissions of RAM users

New feature

Cloud migration

The data of a self-managed PostgreSQL instance can be migrated from an ECS instance or a data center to an RDS instance in an easy-to-use, efficient manner and at a high speed with no downtime.

12-15

Use the cloud migration feature

November

Category

Feature

Description

Release date

References

Feature optimization

Cross-region backup

The cross-region backup feature is improved to support cross-region backups in more Alibaba Cloud regions.

11-26

Enable cross-region backups for an RDS instance

New feature

Connection of an RDS instance to a self-managed domain

An RDS instance can be connected to a self-managed Active Directory (AD) domain. This way, users can manage their enterprise in a centralized manner and ensure the security of their data.

11-25

Connect an RDS instance to a self-managed AD domain

New feature

Commercial release of the backup download feature

The backup download feature is about to be upgraded and commercially released. In the commercial release, a free quota for backup downloads over the Internet is provided. If the traffic that users consume for downloading backup files over the Internet exceeds the free quota, users are charged additional fees.

11-25

[Special offers/Price changes] Commercial release of the backup download feature for RDS instances that use local disks

Feature optimization

Subscription read-only RDS instances

In addition to the pay-as-you-go billing method, read-only RDS instances support the subscription billing method.

11-17

Overview of read-only RDS instances

October

Category

Feature

Description

Release date

References

New feature

Synchronization of IP address whitelists from a primary RDS instance to a specified read-only RDS instance

A primary RDS instance can synchronize its IP address whitelists to a specified read-only RDS instance that is attached to the primary RDS instance.

10-19

Configure an IP address whitelist for an RDS instance

Feature optimization

Enhanced alerting

After the alerting feature is enabled for an RDS instance, the built-in metrics that are provided by ApsaraDB RDS are displayed. Users can build an alerting system for the RDS instance with ease by using the built-in metrics and then use the alerting system to identify exceptions in crucial metrics at the earliest opportunity.

10-14

Configure an alert rule

September

Category

Feature

Description

Release date

References

Feature optimization

Pagination for the DescribeDBInstances operation

Users can use the MaxResults parameter to specify the maximum number of entries per page and then use the NextToken parameter to specify the token that is used to display the next page. The NextToken parameter is set to its value that is returned from the most recent call of the DescribeDBInstances operation.

10-15

Queries instances

Feature optimization

Cross-region backups for RDS instances that use cloud disks

The cross-region backup feature is enhanced to support cross-region backups for RDS instances that use cloud disks.

Note

Cross-region backups are not supported for RDS instances for which disk encryption is enabled.

09-26

Cross-region backup

New feature

Enhanced monitoring

The enhanced monitoring feature is supported. This feature provides more OS metrics and database metrics than the standard monitoring feature.

09-01

View enhanced monitoring

August

Category

Feature

Description

Release date

References

New feature

Time zone configuration at instance creation

The time zone of an RDS instance can be configured during instance creation.

08-20

Create an RDS instance

July

Category

Feature

Description

Release date

References

Feature optimization

Username length

The username of each account on an RDS instance that uses cloud disks is adjusted to 2 to 63 characters in length.

07-20

Create an account on an ApsaraDB RDS for MySQL instance

New feature

Major engine version upgrade

The major engine version of an RDS instance that runs RDS Basic Edition can be upgraded.

07-01

Upgrade the major engine version

June

Category

Feature

Description

Release date

References

New feature

Fully encrypted database

Always-confidential databases are supported for RDS instances that run PostgreSQL 11. Data from database clients is encrypted before it is transmitted to Always-confidential databases. Always-confidential databases help defend against internal and external security threats and provide around-the-clock protection for user data.

06-16

Always-confidential databases

New feature

Alerting

An alerting system can be built for an ApsaraDB RDS instance with a few clicks. This alerting system helps users monitor crucial metrics and identify abnormal metrics at the earliest opportunity.

06-01

Manage alerts on an RDS instance

May

Category

Feature

Description

Release date

References

New feature

Selection of zones for secondary RDS instances

The zones of secondary ApsaraDB RDS instances can be selected.

05-27

Create an RDS instance

New feature

SSL encryption

SSL encryption with custom certificates is supported for RDS instances that run PostgreSQL 10 or a later version and use cloud disks.

05-06

Configure SSL encryption for an RDS instance

March

Category

Feature

Description

Release date

References

New feature

Single-digit second backup

Single-digit second backups are supported. After single-digit second backups are enabled for an RDS instance, the system can complete a backup in 1 second.

03-18

Back up an RDS instance

Feature optimization

Storage type upgrade

The storage types of RDS instances can be upgraded. For example, the storage type of an RDS instance can be upgraded from standard SSDs to ESSDs.

03-18

Change the specifications

New feature

Cross-region backup

The cross-region backup feature is supported. After the feature is enabled for an RDS instance, the system can automatically replicate the backup files of the RDS instance to a different region. The cross-region data backup files can be used to monitor and restore the data of the RDS instance.

03-05

Use the cross-region backup feature

February

Category

Feature

Description

Release date

References

New feature

Major engine version upgrade

The major engine version of an RDS instance can be upgraded.

02-08

Upgrade the major engine version

2020

December

Feature

Description

Release date

References

PostgreSQL 13

PostgreSQL 13 is supported for the RDS Basic Edition and the RDS High-availability Edition.

2020-12-29

Create an RDS instance

November

Feature

Description

Release date

References

AliPG

Version 20201130 of AliPG is released.

2020-11-16

Release notes for AliPG (PostgreSQL 14-17)

GanosBase

Version 3.2 of GanosBase is supported.

2020-11-16

Release notes for GanosBase

September

Feature

Description

Release date

References

GanosBase

Version 3.0 of GanosBase is released.

2020-09-09

Release notes for GanosBase

AliPG

Version 20200830 of AliPG is released. In this version, the extensions of GanosBase are updated to version 3.0. The sql_firewall and TimescaleDB extensions are also supported.

2020-09-09

Release notes for AliPG (PostgreSQL 14-17)

RAM-based authorization

The permissions on RDS instances can be granted to Resource Access Management (RAM) users by using RAM.

2020-09-08

Authorize a RAM user to manage ApsaraDB RDS instances

HLL extension

The HLL extension is supported. This extension is used to recommend content to individual users based on the preferences of the users.

2020-09-07

User preference recommendation system

July

Feature

Description

Release date

References

New instance types

A total of 17 new instance types are added to provide 2 to 104 cores. These new instance types are supported for RDS instances that run RDS High-availability Edition with cloud disks.

2020-07-20

Instance types for primary RDS instances

April

Feature

Description

Release date

References

Pricing Model

The billing method of an RDS instance can be changed from subscription to pay-as-you-go.

2020-04-21

Switch the billing method from subscription to pay-as-you-go

Extension

The HLL, smlar, and tds_fdw extensions are supported.

2020-04-21

Supported extensions

External Tables

Foreign SQL Server tables and foreign Sybase tables are supported.

2020-04-03

N/A

March

Feature

Description

Release date

References

Multiple-zone deployment

The multi-zone deployment method is supported for RDS instances that run RDS High-availability Edition with cloud disks.

2020-03-08

Create an RDS instance

February

Feature

Description

Release date

References

Reserved connections

A specific number of connections can be reserved for superuser accounts. This way, users can log on to an RDS instance and troubleshoot issues by using superuser accounts even if the number of established connections to the RDS instance reaches the upper limit.

2020-02-22

Release notes for AliPG (PostgreSQL 14-17)

plv8

PLV8 V2.3.13 is provided for PostgreSQL 12 to compile stored procedures and functions.

2020-02-22

N/A

SQL translation

SQL statements can be translated from the Oracle syntax to the PostgreSQL syntax.

2020-02-14

Use the SQL translation feature

wal2json extension

The wal2json extension is provided for PostgreSQL 12 to support logical subscriptions.

2020-02-14

Use the wal2json extension

January

Feature

Description

Release date

References

pg_cron extension

The pg_cron extension is provided for PostgreSQL 11 to configure scheduled tasks.

2020-01-14

Use the pg_cron extension to configure scheduled tasks

plv8

PLV8 V2.3.13 is provided for PostgreSQL 11 to compile stored procedures and functions.

2020-01-14

N/A

log_fdw extension

The log_fdw extension is provided for PostgreSQL 11 to query logs in real time.

2020-01-14

Use the log_fdw extension

wal2json extension

The wal2json extension is provided for PostgreSQL 12 to support logical subscriptions.

2020-01-14

Use the wal2json extension

ESSD PLs

The following ESSD PLs are supported for RDS instances that run PostgreSQL 10 on RDS High-availability Edition: ESSD PL2 and ESSD PL3.

2020-01-07

Create an RDS instance

2019

December

Feature

Description

Release date

References

pg_roaringbitmap extension

The pg_roaringbitmap extension is provided for PostgreSQL 12. This extension is used to filter user profiles in real time.

2019-12-31

Use the roaringbitmap extension

Monitoring and alerting

The monitoring and alerting feature is supported for RDS instances that are equipped with cloud disks.

2019-12-31

N/A

New version

RDS Basic Edition is supported for RDS instances that run PostgreSQL 12.

2019-12-17

Create an RDS instance

SSL

SSL encryption can be enabled and disabled in the ApsaraDB RDS console. SSL encryption is supported for RDS instances that are equipped with cloud disks.

2019-12-17

Configure SSL encryption

vSwitch change

The vSwitch of an RDS instance that is equipped with cloud disks can be changed.

2019-12-17

Change the vSwitch of an RDS instance

Authorization of a service account

A temporary service account can be authorized for an RDS instance in the ApsaraDB RDS console. This temporary service account is used by Alibaba Cloud technical support engineers to troubleshoot issues on the RDS instance.

2019-12-17

Grant permissions to the service account

November

Feature

Description

Release date

References

Data reads and writes on foreign MySQL tables

The mysql_fdw extension is supported for RDS instances that run PostgreSQL 10 with cloud disks. This extension can be used to directly read data from and write data to ApsaraDB RDS for MySQL instances or self-managed MySQL databases.

2019-11-13

Use mysql_fdw to read data from and write data to a MySQL database

October

Feature

Description

Release date

References

Removal of binding relationships between storage capacity sizes and instance types

The binding relationships between storage capacity sizes and instance types are removed. Users can purchase a specific amount of storage based on the instance type that they select. This reduces the costs of storage-intensive workloads and compute-intensive workloads.

2019-10-24

Instance types for primary RDS instances

Data reads and writes on foreign PostgreSQL tables

The dblink and postgres_fdw extensions are supported for RDS instances that run PostgreSQL 11 with cloud disks. These extensions are used to manage tables across RDS instances.

2019-10-24

Use the dblink and postgres_fdw extensions for cross-database operations

Up to 32 TB storage capacity

The maximum storage capacity is increased to 6 TB for RDS instances that run RDS Basic Edition and for RDS instances that run RDS High-availability Edition with local or standard SSDs. The maximum storage capacity is increased to 32 TB for RDS instances that run RDS High-availability Edition with ESSDs.

2019-10-24

Instance types for primary RDS instances

PostgreSQL 11

PostgreSQL 11 is supported.

2019-10-24

Create an RDS instance

September

Feature

Description

Release date

References

ApsaraDB RDS buy page of the new version

The ApsaraDB RDS buy page of the new version is released.

2019-09-12

Create an RDS instance

Configure cloud disk encryption

The cloud disk encryption feature is supported for ApsaraDB RDS for PostgreSQL. This feature ensures the security of your data.

2019-09-04

Use cloud disk encryption.

July

Feature

Description

Release date

References

Five-year subscription

Five-year subscription is supported.

2019-07-20

Create an RDS instance