RDS for PostgreSQL

RDS for PostgreSQL

Launch and scale RDS for PostgreSQL in minutes on the cloud - a fully managed database service powered by Postgres, a leading open-source relational database system with a focus on extensibility and SQL compliance.

Launch and scale 'RDS for PostgreSQL' in minutes on the cloud - a fully managed database service powered by Postgres, a leading open-source relational database system with a focus on extensibility and SQL compliance.

Get high-availability, general-purpose instances in primary/standby failover from US$0.15 USD/hour.

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 repeat queries.

    Enjoy advanced database functions, such as the query optimizer, parallel compute, hash aggregate, and optimization of repeat 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.

Functions

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

Enhanced Features

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.

  • Read/Write Splitting

  • Database proxies automatically distribute read and write requests through a read/write splitting address.

  • Scheduled Tasks

  • Tasks can be run automatically during off-peak hours based on a schedule that you control.

Multilayer Network Security

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

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

  • The TimescaleDB time-series database plugin, partition tables, and BRIN indexes are all supported.

  • Search Indexes

  • Provide a wide range of indexes, including function- and condition-based indexes, for faster full-text search.

Professional Database O&M Platform

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

Application Scenarios

Terms & Conditions

活动对象：华为云电销客户及渠道伙伴客户可参与消费满送活动，其他客户参与前请咨询客户经理

活动时间： 2020年8月12日-2020年9月11日

活动期间，华为云用户通过活动页面购买云服务，或使用上云礼包优惠券在华为云官网新购云服务，累计新购实付付费金额达到一定额度，可兑换相应的实物礼品。活动优惠券可在本活动页面中“上云礼包”等方式获取，在华为云官网直接购买（未使用年中云钜惠活动优惠券）或参与其他活动的订单付费金额不计入统计范围内；

活动对象：华为云电销客户及渠道伙伴客户可参与消费满送活动，其他客户参与前请咨询客户经理

Ok
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.

  • Hide Show
    General-purpose Instance Hide Show

    For developing and testing environments that have flexible requirements for high availability

    Instance type: Single

    Instance class: 2 vCPUs | 4 GB

    Connections: 1500

    TPS: 330

    QPS: 6670

    Storage: 40 GB to 4 TB

    Buy Now
  • Hide Show
    General-purpose HA Instances Hide 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: 2500

    TPS: 550

    QPS: 11030

    Storage: 40 GB to 4 TB

    Buy Now
  • Hide Show
    Dedicated HA Instances Hide 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: 10000

    TPS: 2510

    QPS: 50290

    Storage: 40 GB to 4 TB

    Buy Now

New Features

May 12, 2017
Open beta testing for RDS for PostgreSQL
Jul 14, 2017
RDS for PostgreSQL 9.6.3
Jan 22, 2018
Publicly accessible through EIPs
May 18, 2018
Support for Hong Kong region
Jun 06, 2018
RDS for PostgreSQL 10.0.3
Jun 30, 2018
DB instances upgradable from single to primary/standby
Sep 04, 2018
Offline migration
Oct 30, 2018
Online migration
Dec 30, 2018
RDS for PostgreSQL Enhanced Edition (compatible with Oracle)
Jan 15, 2019
RDS for PostgreSQL 11.0
Feb 02, 2019
Slow log query and download
Mar 30, 2019
Scheduled task management supported by RDS for PostgreSQL Enhanced Edition
Apr 30, 2019
Migration from Oracle to RDS for PostgreSQL Enhanced Edition
May 30, 2019
Virtual columns supported by RDS for PostgreSQL Enhanced Edition
Jun 30, 2019
Connect by supported by RDS for PostgreSQL Enhanced Edition
Jul 30, 2019
Composite partitioning supported by RDS for PostgreSQL Enhance Edition partition tables
Apr 30, 2020
RDS for PostgreSQL 12 release
Jul 20, 2020
KUNPEN Edition supported by RDS for PostgreSQL 9.6, 10, 11, 12, and Enhanced Edition
Aug 19, 2020
postgres_fdw and tds_fdw supported by RDS for PostgreSQL 11, 12 and Enhanced Edition, and pg_cron supported by RDS for PostgreSQL 12
Nov 15, 2020
Online port modifications supported by RDS for PostgreSQL 11 and Enhanced Edition
Nov 30, 2020
Read/Write splitting supported by RDS for PostgreSQL 11 and 12
Jan 15, 2021
Configuring and modifying private domain names
Jun 30, 2021
General-purpose and dedicated DB instances
Aug 30, 2021
Cross-region backup
Coming soon
Beta
RDS for PostgreSQL13

Documentation

Getting Started

Technical Documents

FAQs
查看更多 收起