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.

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.

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

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.

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.

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.

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.

Documentation

Getting Started

Technical Documents

FAQs
查看更多 收起