Features supported by ApsaraDB RDS instances that run different PostgreSQL versions - ApsaraDB RDS

This topic provides an overview of the features that are supported by ApsaraDB RDS instances that run different PostgreSQL versions. You can purchase an ApsaraDB RDS for PostgreSQL instance that provides the required features. You can also query the features that are provided by an existing ApsaraDB RDS for PostgreSQL instance. In the following tables, ticks (️️️✔️) indicate that a feature is supported and crosses (❌) indicate that a feature is not supported.

Features of available PostgreSQL versions

Feature

PostgreSQL 16

PostgreSQL 15 and PostgreSQL 14

PostgreSQL 13

PostgreSQL 12 and PostgreSQL 11

RDS Cluster Edition

RDS High-availability Edition

RDS Basic Edition

RDS Cluster Edition

RDS High-availability Edition

RDS Basic Edition

RDS High-availability Edition

RDS Basic Edition

RDS High-availability Edition

RDS Basic Edition

Subscription/Pay-as-you-go

Serverless

Subscription/Pay-as-you-go

Serverless

Subscription/Pay-as-you-go

Serverless

Subscription/Pay-as-you-go

Serverless

Migration to the cloud

✔️

Data migration

✔️

Data synchronization

✔️

Change tracking

✔️

Upgrade of the major engine version

N/A

✔️

Update of the minor engine version

✔️

Instance creation

✔️

Specification change

✔️

❌

✔️

❌

✔️

❌

✔️

❌

✔️

Instance restart

✔️

Change of the scaling range of RDS Capacity Units (RCUs)

❌

✔️

❌

✔️

❌

✔️

❌

✔️

❌

Automatic start and stop

❌

✔️

❌

✔️

❌

✔️

❌

✔️

❌

Change of the RCU scaling policy

❌

✔️

❌

✔️

❌

✔️

❌

✔️

❌

Automatic or manual primary/secondary switchover

✔️

❌

✔️

❌

✔️

❌

✔️

❌

Maintenance window setting

✔️

Automatic storage expansion

✔️

Migration across zones

❌

✔️

❌

✔️

❌

✔️

❌

✔️

❌

✔️

Instance release

✔️

Release protection

✔️

Parameter configuration

✔️

Query and change of the data replication mode

❌

✔️

❌

✔️

❌

✔️

❌

✔️

❌

Recycle bin

✔️

Babelfish for ApsaraDB RDS for PostgreSQL

❌

✔️

❌

✔️

❌

✔️

❌

Read-only instance

❌

✔️

❌

✔️

❌

✔️

❌

✔️

❌

Database proxy (read/write splitting)

❌

✔️

❌

✔️

❌

✔️

❌

✔️

❌

Account creation

✔️

Password reset

✔️

Connection to a self-managed domain

✔️

Account locking or deletion

✔️

Connection to an RDS instance

✔️

Enabling or disabling a public endpoint

✔️

Viewing and change of the internal and public endpoints and port numbers

✔️

Network type change

❌

vSwitch change

✔️

❌

✔️

❌

✔️

❌

✔️

❌

✔️

✔️

✔️

✔️

✔️

Check on the Enhanced Monitoring metrics

✔️

Alert management

✔️

Switching to the enhanced whitelist mode

❌

Whitelist configuration

✔️

SSL encryption

✔️

❌

✔️

❌

✔️

❌

✔️

❌

✔️

Cloud disk encryption

✔️

❌

✔️

❌

✔️

❌

✔️

❌

✔️

Creation of fully encrypted RDS instances

✔️

Instance that does not use the Intel SGX-based security-enhanced instance type: ️️️✔️
Instance that uses the Intel SGX-based security-enhanced instance type: ❌

❌

✔️

❌

✔️

❌

✔️

❌

✔️

Transparent Data Encryption (TDE)

✔️

✔️

✔️

✔️

✔️

✔️

❌

✔️

❌

✔️

❌

✔️

❌

✔️

High-frequency snapshot backup

❌

✔️

❌

✔️

❌

✔️

❌

✔️

❌

✔️

Backup download

✔️

❌

✔️

Backup deletion

✔️

Data restoration

✔️

Restoration of individual databases and tables

❌

✔️

❌

✔️

❌

✔️

❌

✔️

Cross-region restoration

✔️

❌

✔️

❌

✔️

❌

✔️

❌

✔️

Database Autonomy Service (DAS)

✔️

❌

✔️

❌

✔️

❌

✔️

❌

Tag creation

✔️

Tag deletion

✔️

Features of phased-out PostgreSQL versions

PostgreSQL 10

Feature	PostgreSQL 10
	RDS High-availability Edition (with local disks)	RDS High-availability Edition (with cloud disks)	RDS Basic Edition (with cloud disks)
	RDS High-availability Edition (with local disks)	RDS High-availability Edition (with cloud disks)	RDS Basic Edition (with cloud disks)
Cloud migration	❌	✔️	✔️
Data migration	✔️	✔️	✔️
Data synchronization	✔️	✔️	✔️
Change tracking	✔️	✔️	✔️
Upgrade of the major engine version	✔️	✔️	✔️
Update of the minor engine version	✔️	✔️	✔️
Instance creation	✔️	✔️	✔️
Specification change	✔️	✔️	✔️
Instance restart	✔️	✔️	✔️
Change of the scaling range of RCUs	❌	❌	❌
Automatic start and stop	❌	❌	❌
Change of the RCU scaling policy	❌	❌	❌
Automatic or manual primary/secondary switchover	✔️	✔️	❌
Maintenance window setting	✔️	✔️	✔️
Automatic storage expansion	❌	✔️	✔️
Migration across zones	✔️	✔️	✔️
Instance release	✔️	✔️	✔️
Release protection	✔️	✔️	✔️
Parameter configuration	✔️	✔️	✔️
Protection level configuration	❌	✔️	❌
Instance recycle bin	✔️	✔️	✔️
Babelfish for RDS PostgreSQL	❌	❌	❌
Read-only RDS instances	✔️	✔️	❌
Database proxy (read/write splitting)	❌	✔️	❌
Account creation	✔️	✔️	✔️
Password reset	✔️	✔️	✔️
Connection to a self-managed domain	❌	✔️	✔️
Account locking or deletion	✔️	✔️	✔️
Connection to an RDS instance	✔️	✔️	✔️
Public endpoint application or release	✔️	✔️	✔️
Viewing and change of the internal and public endpoints and port numbers	✔️	✔️	✔️
Network type change	✔️	❌	❌
vSwitch change	❌	✔️	✔️
Database creation	✔️	✔️	✔️
Database deletion	✔️	✔️	✔️
Time zone change	❌	✔️	✔️
Extensions	✔️	✔️	✔️
Viewing of the enhanced monitoring metrics	✔️	✔️	✔️
Alert management	✔️	✔️	✔️
Change to the enhanced whitelist mode	✔️	❌	❌
IP address whitelist configuration	✔️	✔️	✔️
SSL encryption	❌	✔️	✔️
Cloud disk encryption	❌	✔️	✔️
Always-confidential database	❌	✔️	❌
TDE	❌	✔️	✔️
SQL Audit	✔️	✔️	✔️
Log management	✔️	✔️	✔️
Task Center	✔️	✔️	✔️
Data backup	✔️	✔️	✔️
Cross-region backup	✔️	✔️	✔️
High-frequency snapshot backup	❌	✔️	✔️
Backup download	✔️	✔️	✔️
Backup deletion	✔️	✔️	✔️
Data restoration	✔️	✔️	✔️
Restoration of individual databases and tables	❌	✔️	✔️
Cross-region restoration	✔️	✔️	✔️
DAS	✔️	✔️	❌
Tag creation	✔️	✔️	✔️
Tag deletion	✔️	✔️	✔️

PostgreSQL 9.4

Category	Feature	RDS High-availability Edition with local disks
Instance management	Instance creation	✔️
	Specification change	❌️
	Parameter configuration	✔️
	Query and change of the data replication mode	❌️
	Migration across zones	✔️
	Primary/secondary switchover	✔️
	Instance restart	✔️
	Maintenance window setting	✔️
	Upgrade of the major engine version	✔️
	Instance release	✔️
	Instance recycle bin	✔️
Account management	Account creation	✔️
	Password reset	✔️
	Account locking	✔️
	Account deletion	✔️
Database management	Database creation	✔️
	Database deletion	✔️
	Extensions	✔️
Database connection management	Connection to an RDS instance	✔️
	Endpoint setting	✔️
	Endpoint and port number viewing	✔️
	Public endpoint application or release	✔️
Monitoring and alerting	Check on the resource metrics and engine metrics	✔️
	Monitoring frequency configuration	✔️
	Alert management	✔️
Network setting management	Network type change	✔️
Network setting management	vSwitch change	❌️
Read-only RDS instances	Read-only instance creation	❌️
Security management	IP address whitelist configuration	✔️
	SSL encryption	❌️
	Cloud disk encryption	❌️
	Change to the enhanced whitelist mode	✔️
	Always-confidential database	✔️
Log and event history management	Log management	✔️
Log and event history management	Event history	✔️
Database backup	Data backup	✔️
	Cross-region backup	✔️
	Free quotas	✔️
	Backup download	✔️
Database restoration	Data restoration	❌️
Database restoration	Cross-region restoration	❌️
Logical subscription	Logical subscription	❌️
Tag management	Tag creation	✔️
	Tag deletion	✔️
	Tag-based instance search	✔️