RDS for PostgreSQL

PostgreSQL is a powerful, open-source, object relational database with a great reputation for data reliability and integrity. It is used for websites, location-based applications, and complex data object processing.

Starting from ¥0.26/hour. 17% off with a 1-year subscription.

Learn more
Product Advantages
  • Multi-Plugin Support

    Supports multiple plugins and data types for fast, flexible data processing.

  • High Reliability

    Uses high availability architecture to deploy primary/standby DB instances in different AZs for failover support.

  • High Security

    Certified by TRUCS, CSA STAR, ISO 27001, and has been granted Class 3 certification in Information Security Protection by China's Ministry of Public Security.

  • Real-Time Monitoring

    Monitors metrics to inform you of DB instance running statuses in real time; supports custom alarm rules.

Application Scenarios
  • Location Applications

  • Research Projects

  • Financial Insurance

  • E-Commerce

Location Applications

Location Applications

RDS for PostgreSQL supports PostGIS and is the preferred choice for location-based applications. It provides spatial features including space objects, indexes, operation functions, and operators.

Advantages

Various Spatial Data

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 to expand the space.

Simple Spatial Operations

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

Related Services

ecs

vpn

obs

Research Projects

Research Projects

RDS for PostgreSQL supports different forms of complex data and can customize 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 privacy.

Supported Expression Indexes

Builds indexes on generic expressions rather than values or columns.

Custom Data Types

Processes data of custom data types flexibly.

Related Services

ecs

vpn

obs

Financial Insurance

Financial Insurance

RDS for PostgreSQL uses Multi-Version Concurrency Control (MVCC) to ensure data consistency and synchronizes data 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 delay is mere milliseconds, ensuring data consistency.

Related Services

ecs

vpn

obs

E-Commerce

E-Commerce

RDS for PostgreSQL is an excellent choice for its stability in SQL programming for Internet applications in high-concurrency scenarios.

Advantages

Excellent Performance

Maintains excellent performance in high concurrency and heavy load scenarios.

Simple Operating Environment

Analysis functions and recursive functions are embedded, greatly simplifying complexity of Internet application codes.

Related Services

ecs

vpn

obs

Functions

  • Precise Processing

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

  • Two Instance Types

    Provides single and primary/standby DB instances for you to choose from.

Precise Processing

  • Various Spatial Data

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

  • Simple Spatial Operations

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

  • Efficient Spatial Analysis

    Provides efficient spatial analysis functions.

Two Instance Types

  • Single DB Instance

    Supports PostgreSQL 9.5, 9.6, and 10.0.3. It is cost-effective and ensures the proper running of your services.

  • Primary/Standby DB Instances

    Supports concurrent requests, high availability, and primary/standby switchover in case of a primary DB instance failure.

  • Multi-Layer Protection

    Has obtained 14 international security compliance certifications to effectively defend against network attacks.

  • Professional Database O&M

    Provides a management console, making it easy to manage, monitor, operate, and maintain DB instances.

Multi-Layer Protection

  • VPC

    Uses VPC to isolate tenants and control access to DB instances.

  • Security Group

    Uses security groups to allow access from specific IP addresses and ports.

  • SSL

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

Professional Database O&M

  • Instance Management

    Provides a management console to for you to manage DB instances, logs, parameters, and backup data.

  • Visualized Monitoring

    Comprehensively monitors metrics to inform you of DB instance running statuses in real time; supports custom alarm rules.

Recommended Configurations

Basic

For the development and testing of small websites and small- and medium-sized enterprises

Basic

For the development and testing of small websites and small- and medium-sized enterprises

Specifications

  • Instance class 2 vCPUs | 4 GB
  • Max. QPS 9,400
  • Max. TPS 600
  • Max. connections 500
  • Max. capacity 4 TB

Scenarios

  • Testing
  • Research
  • Enterprise websites
  • Location applications
Starting from ¥0.48/hour

Intermediate

For production databases of large- and medium-sized enterprises. Primary/standby DB instances are recommended.

Intermediate

For production databases of large- and medium-sized enterprises. Primary/standby DB instances are recommended.

Specifications

  • Instance class 8 vCPUs | 32 GB
  • Max. QPS 19,000
  • Max. TPS 1,300
  • Max. connections 2,000
  • Max. capacity 4 TB

Scenarios

  • Logistics
  • Monitoring
  • E-commerce gaming
  • Enterprise applications
Starting from ¥2.56/hour

Advanced

For large- and medium-sized e-commerce and gaming enterprises. Primary/standby DB instances and read replicas are recommended.

Advanced

For large- and medium-sized e-commerce and gaming enterprises. Primary/standby DB instances and read replicas are recommended.

Specifications

  • Instance class 32 vCPUs | 128 GB
  • Max. QPS 26,000
  • Max. TPS 2,000
  • Max. connections 20,000
  • Max. capacity 4 TB

Scenarios

  • IoV
  • Internet
  • Finance
  • Research
Starting from ¥10.13/hour
Usage Guides

Create an Account and Experience HUAWEI CLOUD for Free

Register Now