Product Advantages

Scalable

Scale up or scale out on demand. Add up to five read replicas to offload database workloads, or add instance vCPUs, memory, and storage within minutes.

Scale up or scale out on demand. Add up to five read replicas to offload database workloads, or add instance vCPUs, memory, and storage within minutes.
Powerful

Enjoy advanced database functions, such as the query optimizer, parallel compute, hash aggregate, and optimization of repeated queries.

Enjoy advanced database functions, such as the query optimizer, parallel compute, hash aggregate, and optimization of repeated queries.

Secure

RDS for PostgreSQL has 15+ security certifications such as ISO 27001, CSA, and CCSP Level 3.

RDS for PostgreSQL has 15+ security certifications such as ISO 27001, CSA, and CCSP Level 3.
Reliable

Get high availability and failover support for your DB instances with a primary/standby deployment.

Get high availability and failover support for your DB instances with a primary/standby deployment.

Why RDS for PostgreSQL?

Leverage the world's most advanced open source database to power geospatial, financial, or analytics applications securely and reliably.

Enhanced Features

Read Replica
Up to five read replicas can be added to an existing DB instance to offload read-heavy database workloads.
Logical Replication Subscription
All logical slots can be replicated from the primary instance to the standby instance.
Scheduled Tasks
Tasks can be run automatically during off-peak hours based on a schedule that you control.

Multilayer Network Security

Network Isolation and Security Group
Leverage Virtual Private Cloud (VPC) to isolate tenant networks and security group rules to control traffic to and from specific IP addresses and ports, keeping your database safe.
SSL
Use TLS and SSL to encrypt data during transmission, ensuring the security and integrity of your data.
Audit
Use Cloud Trace Service (CTS) to record operations associated with RDS for PostgreSQL for later query, audit, and backtrack operations.
Certifications
RDS for PostgreSQL has 15+ security certifications such as ISO 27001, CSA, Trusted Cloud Service (TRUCS), and CCSP Level 3.

Support for 70+ Plugins

Multiple Types of Geospatial Data
Support PostGIS for 2D and 3D models, with space objects, indexes, operation functions, and operators.
Time Series Data
Support the TimescaleDB time-series database plugin, partition tables, and BRIN indexes.
Search Indexes
Provide a wide range of indexes, including function- and condition-based indexes, for faster full-text search.

Professional Database O&M Platform

Instance Management
Manage your instances with ease using flexible console-based capabilities.
Real-Time Monitoring
View key operational metrics of your instances, including vCPU/storage utilization, I/O activity, and instance connections, and define custom alarm rules as needed.
Backup and Restoration
Restore data from backups to any point in time. Backups can be saved for up to 732 days.
Automated Failover
Maintain the uptime of your workloads with automated failover.

Application Scenarios

Geospatial Data: Apps

Utilize Spatial and Geographic Objects

RDS for PostgreSQL supports the PostGIS extender plugin for location-based applications providing excellent spatial performance. It provides spatial features including space objects, indexes, operation functions, and operators.

Advantages

Extra types

Supports various types of spatial data including points, lines, planes, grids, and three-dimensional data.
Efficient Spatial Analysis

Provides efficient spatial analysis functions and works with OBS for unlimited object storage.
Simple Spatial Operations

Reduces the code complexity for location applications, making spatial operations easier.

Related Services

ECS

VPN

OBS

Complex Data Types: Research

Store Complex and Custom Data Types

RDS for PostgreSQL supports different forms of complex data and custom data types. It stores infrequently used data to OBS to save storage costs and space.

Advantages

Guaranteed Data Accuracy

Stores data accurately and uses a VPN to protect data.
Supported Expression Indexes

Builds indexes on generic expressions rather than values or columns.
Custom Data Types

Quickly and easily processes custom data types.

Related Services

ECS

VPN

OBS

High Concurrency: Finance

Ensure Data Safety for Finance Apps

RDS for PostgreSQL uses Multi-Version Concurrency Control (MVCC) to ensure data consistency. Data is safely synchronized between primary and standby DB instances to ensure data integrity.

Advantages

MVCC

Modifications made to a transaction are not visible to other users, complying with the properties of Atomicity, Consistency, Isolation, Durability (ACID).
Low Synchronization Delay

The primary/standby synchronization latency is a few milliseconds, ensuring data consistency.

Related Services

ECS

VPN

OBS

Reliability: E-Commerce

Maintain Uptime with Reliable Database Hosting

RDS for PostgreSQL is an excellent choice to develop web and mobile applications upon its rich feature set, plugin ecosystem, and native ability to handle high-concurrency scenarios.

Advantages

Excellent Performance

Maintains excellent performance in high concurrency and heavy load scenarios.
Stable Development Environment

As an object-relational database, PostgreSQL offers more complex data types and allows objects to inherit properties. Embedded analysis functions and recursive functions help simplify code and speed up development.

Related Services

ECS

VPN

OBS

Functions

Efficient Spatial Analysis

The PostGIS plugin supports 2D and 3D models, including space objects, indexes, operation functions, and operators.

The PostGIS plugin supports 2D and 3D models, including space objects, indexes, operation functions, and operators.
Two Instance Types

Single and primary/standby DB instances are available for you to choose from.

Single and primary/standby DB instances are available for you to choose from.

Various Spatial Data

Various Spatial Data

A wide range of spatial data types including points, lines, planes, grids, and three-dimensional data are supported.

A wide range of spatial data types including points, lines, planes, grids, and three-dimensional data are supported.
Simple Spatial Operations

Simple Spatial Operations

The code complexity for location-based applications is reduced, making spatial operations easier.

The code complexity for location-based applications is reduced, making spatial operations easier.

Single DB Instance

Single DB Instance

Single DB instances are cost-effective and suitable for development and testing environments.

Single DB instances are cost-effective and suitable for development and testing environments.
Primary/Standby DB Instances

Primary/Standby DB Instances

Primary/standby DB instances provide high availability and automatic failover support if a primary DB instance fails.

Primary/standby DB instances provide high availability and automatic failover support if a primary DB instance fails.

Multi-Layer Protection

RDS for PostgreSQL has obtained 14 international security certifications to make your network more secure.

RDS for PostgreSQL has obtained 14 international security certifications to make your network more secure.
Professional Database O&M

A web-based console makes it easy to manage, monitor, and operate DB instances.

A web-based console makes it easy to manage, monitor, and operate DB instances.

VPC

VPC

VPCs isolate tenants and control access to DB instances.

VPCs isolate tenants and control access to DB instances.
Security Group

Security Group

Security groups allow access from specific IP addresses and ports.

Security groups allow access from specific IP addresses and ports.
SSL

SSL

SSL encrypts connections to DB instances, ensuring data security and integrity.

SSL encrypts connections to DB instances, ensuring data security and integrity.

Instance Management

Instance Management

A web-based console is available for you to manage DB instances, logs, parameters, and backup data.

A web-based console is available for you to manage DB instances, logs, parameters, and backup data.
Visualized Monitoring

Visualized Monitoring

You can view DB instance metrics that are monitored in real time and set alarm rules to stay aware of instance statuses.

You can view DB instance metrics that are monitored in real time and set alarm rules to stay aware of instance statuses.

Example RDS Configurations

Customize instances to get the ideal mix of memory, processing power, storage, and availability.

Show

General-purpose Instance Show

For developing and testing environments that have flexible requirements for high availability
Instance type: Single
Instance class: 2 vCPUs | 4 GB
Connections: 1,500
TPS: 330
QPS: 6,670
Storage: 40 GB to 4 TB

Buy Now
Show

General-purpose HA Instances Show

For enterprise high-availability environments where cost-effectiveness is important, and flexible performance is acceptable
Instance type: Primary/Standby
Instance class: 2 vCPUs | 8 GB
Connections: 2,500
TPS: 550
QPS: 11,030
Storage: 40 GB to 4 TB

Buy Now
Show

Dedicated HA Instances Show

For enterprise high-availability environments where high concurrency is expected, and a guarantee of performance is required
Instance type: Primary/Standby
Instance class: 8 vCPUs | 32 GB
Connections: 10,000
TPS: 2,510
QPS: 50,290
Storage: 40 GB to 4 TB

Buy Now