All Products
Search
Document Center

ApsaraDB RDS:Overview of ApsaraDB RDS for PostgreSQL features

Last Updated:Aug 13, 2024

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

Subscription/Pay-as-you-go

Serverless

Subscription/Pay-as-you-go

Serverless

Subscription/Pay-as-you-go

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

N/A

N/A

N/A

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

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Database creation

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Database deletion

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Time zone change

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

Extensions

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

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)

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

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

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

✔️

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)

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

✔️

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

✔️

Event history

✔️

Database backup

Data backup

✔️

Cross-region backup

✔️

Free quotas

✔️

Backup download

✔️

Database restoration

Data restoration

❌️

Cross-region restoration

❌️

Logical subscription

Logical subscription

❌️

Tag management

Tag creation

✔️

Tag deletion

✔️

Tag-based instance search

✔️