Contact Sales

RDS for PostgreSQL

{"_id":"pep-solution-page-navigate-v2_1690800752634","context":{"bg":"white","btnList":[{"btnUrl":"https://www.huaweicloud.com/intl/en-us/contact-sales.html","btnText":"Contact Sales","btnStyle":"por-btn-primary"}],"moreText":"","actionInfo":{"title":"RDS for PostgreSQL","titleUrl":"","actionList":[{"isBlank":false,"actionUrl":"","isChecked":true,"actionName":"Overview","selectMenu":{"selectList":[{"url":"https://www.huaweicloud.com","name":"开发者资源开发者资源开发者资源","isBlank":false},{"url":"https://www.huaweicloud.com","name":"客户案例","isBlank":false},{"url":"https://www.huaweicloud.com","name":"最佳实践","isBlank":false}]},"isShowSelect":false},{"isBlank":true,"actionUrl":"https://support.huaweicloud.com/intl/en-us/usermanual-rds/rds_09_0000.html","isChecked":false,"actionName":"Features","selectMenu":{"selectList":[{"url":"https://www.huaweicloud.com","name":"开发者资源开发者资源开发者资源","isBlank":false},{"url":"https://www.huaweicloud.com","name":"客户案例","isBlank":false},{"url":"https://www.huaweicloud.com","name":"最佳实践","isBlank":false}]},"isShowSelect":false},{"isBlank":true,"actionUrl":"https://support.huaweicloud.com/intl/en-us/price-rds/rds_00_0001.html","isChecked":false,"actionName":"Billing","selectMenu":{"selectList":[{"url":"https://www.huaweicloud.com","name":"开发者资源","isBlank":false},{"url":"https://www.huaweicloud.com","name":"客户案例","isBlank":false},{"url":"https://www.huaweicloud.com","name":"最佳实践","isBlank":false}]},"isShowSelect":false},{"isBlank":true,"actionUrl":"https://support.huaweicloud.com/intl/en-us/productdesc-rds/rds_01_0035.html","isChecked":false,"actionName":"Instances","selectMenu":{"selectList":[{"url":"https://www.huaweicloud.com","name":"开发者资源开发者资源开发者资源","isBlank":false},{"url":"https://www.huaweicloud.com","name":"客户案例","isBlank":false},{"url":"https://www.huaweicloud.com","name":"最佳实践","isBlank":false}]},"isShowSelect":false},{"isBlank":true,"actionUrl":"https://support.huaweicloud.com/intl/en-us/qs-rds/rds_03_0014.html","isChecked":false,"actionName":"Getting Started","selectMenu":{"selectList":[{"url":"https://www.huaweicloud.com","name":"开发者资源开发者资源开发者资源","isBlank":false},{"url":"https://www.huaweicloud.com","name":"客户案例","isBlank":false},{"url":"https://www.huaweicloud.com","name":"最佳实践","isBlank":false}]},"isShowSelect":false}],"mobileSelectText":""},"columnNumberMB":"2"},"advancedInfo":{"isShowBtn":true,"isShowTitle":true}}

RDS for PostgreSQL

A fully-managed, PostgreSQL-compatible, relational database that is easy to set up, run, and scale

High Availability and Reliability

99.95%+ service availability and 99.9999999%+ data reliability

90+ Plugins

More than 90 plugins to support a wide range of application scenarios

15+ Security Certifications

RDS provides extensive security features to meet compliance needs. It encrypts data in transit and has earned 15+ security certifications.

Lower Costs

RDS presents a significant edge over on-premises databases. RDS requires minimal initial investment.

Instance Types

Starter
Basic
Professional

{"price":{"unit":"USD/hour","origin":"0.06","current":"","tooltip":"","accuracy":2,"currency":"Starting from $","priceError":"计算中...","originTemplate":"${currency}${origin}","currentTemplate":""},"button":{"subBtnHref":"","subBtnText":"","mainBtnHref":"https://console-intl.huaweicloud.com/rds/?region=cn-north-4&locale=en-us&flavorId=rds.pg.n1.large.2&vType=CLOUDSSD&vSize=40&payModel=0&buyTime=1&Engine=postgresql&versionType=14&insType=single&buyNum=1#/rds/createIns","mainBtnText":"Buy","mainBtnCheck":false,"initDomainMainBtnText":"请先输入域名"},"coupon":{"title":"优惠明细","coupons":[],"footnote":"* 以上优惠仅为初步预估，不代表最终价格，具体结算金额请以支付页实际抵扣金额为准","subtitle":"活动优惠说明：","hasCoupon":false,"expiration":"有效期至：6月30日24:00","priceTitle":"券后预估到手","description":"商品代金券","promotionId":"","couponDetailTemplate":"满${threshold}减${amount}","couponPriceDescription":"代金券","originPriceDescription":"官网价"},"header":{"tip":"","base":{"tip":"","tags":["云服务器"],"titleMb":"2核2G 3M","titlePc":"2核2G 3M","subtitleMb":"","subtitlePc":"高性价比。广泛适用于建站、开发测试等轻量应用等","productIcon":"https://res-static.hc-cdn.cn/cloudbu-site/china/zh-cn/yunying/new-home/product/ECS.png","rowTabTitle":"2核2G ","contentAlign":"center"},"mark":"","tags":[],"titleMb":"Starter","titlePc":"Starter","tooltip":{"more":"","title":"","detail":"","images":""},"cardType":"product","productImg":"","subtitleMb":"For study and practice, small websites or applications, and developing and testing environments","subtitlePc":"For study and practice, small websites or applications, and developing and testing environments","productIcon":"https://res-static.hc-cdn.cn/cloudbu-site/china/zh-cn/product_rdspg_package_icon1.png","rowTabTitle":"Starter","titleHasTooltip":false},"purchase":{"base":{"unit":"/月","subBtnHref":"https://support.huaweicloud.com/bestpractice-hecs/bp_01_0001.html","subBtnText":"使用教程","mainBtnHref":"https://www.huaweicloud.com/","mainBtnText":"立即购买"},"product":{"tooltip":""}},"flashSale":{"prId":"","hasFlashSale":false,"flashSaleTime":["09:00:00","23:59:59"],"afterFlashSaleMainBtnText":"秒杀已结束","flashSaleProgressTemplate":"已抢购${progress}%","beforeFlashSaleMainBtnText":"秒杀未开始","runoutFlashSaleMainBtnHref":"","runoutFlashSaleMainBtnText":"已售罄","runoutFlashSaleMainBtnIsBlank":false},"promotion":{"packageUrl":"","productSort":false,"selectAtLeast":1,"productConfigs":[],"synchronizedOptions":["数据中心","时长"]},"description":{"free":{"productDesc":"试用规格：2核4G，1Mbps带宽，40GB系统盘；数据中心：北京四/上海一/广州/乌兰察布一/北京一","productSpec":"2核4G | 1个月"},"image":{"url":"","description":""},"links":{"items":[],"title":""},"specs":{"items":[{"title":"Instance Type","detail":"Single"},{"title":"Specifications","detail":"General-purpose, 2 vCPUs | 4 GB; General-purpose, 2 vCPUs | 8 GB"},{"title":"Storage","detail":"40 GB"},{"title":"Region","detail":"CN North-Beijing4"}],"defaultShowLength":4},"product":{"specs":[{"title":"系统盘","detail":"40GB"},{"title":"流量包","detail":"400GB"},{"title":"带宽","detail":"3Mbps"}],"length":3},"advantages":{"list":[]}},"verification":{"retCodeConfigs":[],"userTypeConfig":{"scope":"all","title":"温馨提示","message":"","guidances":[],"messageMb":""}}}

{"price":{"unit":"USD/hour","origin":"0.35","current":"","tooltip":"","accuracy":2,"currency":"Starting from $","priceError":"计算中...","originTemplate":"${currency}${origin}","currentTemplate":""},"button":{"subBtnHref":"","subBtnText":"","mainBtnHref":"https://console-intl.huaweicloud.com/rds/?region=cn-north-4&locale=en-us&flavorId=rds.pg.n1.xlarge.2.ha&vType=CLOUDSSD&vSize=100&payModel=0&buyTime=1&Engine=postgresql&versionType=14&insType=ha&buyNum=1#/rds/createIns","mainBtnText":"Buy","mainBtnCheck":false,"initDomainMainBtnText":""},"coupon":{"title":"优惠明细","coupons":[],"footnote":"* 以上优惠仅为初步预估，不代表最终价格，具体结算金额请以支付页实际抵扣金额为准","subtitle":"活动优惠说明：","hasCoupon":false,"expiration":"有效期至：6月30日24:00","priceTitle":"券后预估到手","description":"商品代金券","promotionId":"","couponDetailTemplate":"满${threshold}减${amount}","couponPriceDescription":"代金券","originPriceDescription":"官网价"},"header":{"tip":"","base":{"tip":"推荐","tags":[],"titleMb":"2核2G 4M","titlePc":"2核2G 4M","subtitleMb":"","subtitlePc":"","productIcon":"https://res-static.hc-cdn.cn/cloudbu-site/china/zh-cn/yunying/new-home/product/ECS.png","rowTabTitle":"4M","contentAlign":"center"},"mark":"","tags":[],"titleMb":"Basic","titlePc":"Basic","tooltip":{"more":"","title":"","detail":"","images":""},"cardType":"product","productImg":"","subtitleMb":"For small and medium enterprises and Internet applications","subtitlePc":"For small and medium enterprises and Internet applications","productIcon":"https://res-static.hc-cdn.cn/cloudbu-site/china/zh-cn/product_rdspg_package_icon2.png","rowTabTitle":"Basic","titleHasTooltip":false},"purchase":{"base":{"unit":"/月","subBtnHref":"https://support.huaweicloud.com/bestpractice-hecs/bp_01_0001.html","subBtnText":"使用教程","mainBtnHref":"https://www.huaweicloud.com/","mainBtnText":"免费试用"},"product":{"tooltip":""}},"flashSale":{"prId":"","hasFlashSale":false,"flashSaleTime":["09:00:00","23:59:59"],"afterFlashSaleMainBtnText":"秒杀已结束","flashSaleProgressTemplate":"已抢购${progress}%","beforeFlashSaleMainBtnText":"秒杀未开始","runoutFlashSaleMainBtnHref":"","runoutFlashSaleMainBtnText":"已售罄","runoutFlashSaleMainBtnIsBlank":false},"promotion":{"packageUrl":"","productSort":false,"selectAtLeast":1,"productConfigs":[],"synchronizedOptions":["数据中心","时长"]},"description":{"free":{"productDesc":"试用规格：2核4G，1Mbps带宽，40GB系统盘；数据中心：北京四/上海一/广州/乌兰察布一/北京一","productSpec":"2核4G | 1个月"},"image":{"url":"","description":""},"links":{"items":[],"title":""},"specs":{"items":[{"title":"Instance Type","detail":"Primary/Standby"},{"title":"Specifications","detail":"General-purpose, 4 vCPUs | 8 GB; General-purpose, 4 vCPUs | 16 GB"},{"title":"Storage","detail":"100 GB"},{"title":"Region","detail":"CN North-Beijing4"}],"defaultShowLength":4},"product":{"specs":[{"title":"系统盘","detail":"50GB"},{"title":"流量包","detail":"600GB"},{"title":"带宽","detail":"4Mbps"}],"length":3},"advantages":{"list":[]}},"verification":{"retCodeConfigs":[],"userTypeConfig":{"scope":"all","title":"温馨提示","message":"","guidances":[],"messageMb":""}}}

{"price":{"unit":"USD/hour","origin":"0.92","current":"","tooltip":"","accuracy":2,"currency":"Starting from $","priceError":"计算中...","originTemplate":"${currency}${origin}","currentTemplate":""},"button":{"subBtnHref":"","subBtnText":"","mainBtnHref":"https://console-intl.huaweicloud.com/rds/?region=cn-north-4&locale=en-us&flavorId=rds.pg.x1.2xlarge.4.ha&vType=CLOUDSSD&vSize=100&payModel=0&buyTime=1&Engine=postgresql&versionType=14&insType=ha&buyNum=1#/rds/createIns","mainBtnText":"Buy","mainBtnCheck":false,"initDomainMainBtnText":""},"coupon":{"title":"优惠明细","coupons":[],"footnote":"* 以上优惠仅为初步预估，不代表最终价格，具体结算金额请以支付页实际抵扣金额为准","subtitle":"活动优惠说明：","hasCoupon":false,"expiration":"有效期至：6月30日24:00","priceTitle":"券后预估到手","description":"商品代金券","promotionId":"","couponDetailTemplate":"满${threshold}减${amount}","couponPriceDescription":"代金券","originPriceDescription":"官网价"},"header":{"tip":"","base":{"tip":"","tags":["云服务器"],"titleMb":"2核2G 3M","titlePc":"2核2G 3M","subtitleMb":"","subtitlePc":"高性价比。广泛适用于建站、开发测试等轻量应用等","productIcon":"https://res-static.hc-cdn.cn/cloudbu-site/china/zh-cn/yunying/new-home/product/ECS.png","rowTabTitle":"2核2G ","contentAlign":"center"},"mark":"","tags":[],"titleMb":"Professional","titlePc":"Professional","tooltip":{"more":"","title":"","detail":"","images":""},"cardType":"product","productImg":"","subtitleMb":"For medium and large enterprises in finance insurance, and e-commerce","subtitlePc":"For medium and large enterprises in finance insurance, and e-commerce","productIcon":"https://res-static.hc-cdn.cn/cloudbu-site/china/zh-cn/product_rdspg_package_icon3.png","rowTabTitle":"Professional","titleHasTooltip":false},"purchase":{"base":{"unit":"/月","subBtnHref":"https://support.huaweicloud.com/bestpractice-hecs/bp_01_0001.html","subBtnText":"使用教程","mainBtnHref":"https://www.huaweicloud.com/","mainBtnText":"立即购买"},"product":{"tooltip":""}},"flashSale":{"prId":"","hasFlashSale":false,"flashSaleTime":["09:00:00","23:59:59"],"afterFlashSaleMainBtnText":"秒杀已结束","flashSaleProgressTemplate":"已抢购${progress}%","beforeFlashSaleMainBtnText":"秒杀未开始","runoutFlashSaleMainBtnHref":"","runoutFlashSaleMainBtnText":"已售罄","runoutFlashSaleMainBtnIsBlank":false},"promotion":{"packageUrl":"","productSort":false,"selectAtLeast":1,"productConfigs":[],"synchronizedOptions":["数据中心","时长"]},"description":{"free":{"productDesc":"试用规格：2核4G，1Mbps带宽，40GB系统盘；数据中心：北京四/上海一/广州/乌兰察布一/北京一","productSpec":"2核4G | 1个月"},"image":{"url":"","description":""},"links":{"items":[],"title":""},"specs":{"items":[{"title":"Instance Type","detail":"Primary/Standby"},{"title":"Specifications","detail":"Dedicated, 8 vCPUs | 32 GB; Dedicated, 8 vCPUs | 64 GB"},{"title":"Storage","detail":"100 GB"},{"title":"Region","detail":"CN North-Beijing4"}],"defaultShowLength":4},"product":{"specs":[{"title":"系统盘","detail":"40GB"},{"title":"流量包","detail":"400GB"},{"title":"带宽","detail":"3Mbps"}],"length":3},"advantages":{"list":[]}},"verification":{"retCodeConfigs":[],"userTypeConfig":{"scope":"all","title":"温馨提示","message":"","guidances":[],"messageMb":""}}}

Why RDS for PostgreSQL?

Custom Deployment and DR Solutions

Use primary/standby deployment to achieve an overall availability of at least 99.95% and an RTO of less than 60 seconds. A switchover takes only a few seconds.
Enable real-time synchronization between primary and standby DB instances to guarantee an RPO of zero.
Use Elastic Volume Service (EVS) disks to achieve data reliability of 99.9999999%.
Create read replicas as needed to reduce the load on your primary DB instance. RDS will route read requests to the read replicas.

Professional Database O&M Platform

Monitor instance statuses and metrics in real time on the RDS console, and receive alerts for events that occur in your instance.
It takes only a few steps to back up and restore data, create accounts and databases, query logs, tune parameters, and more operations on the console.

Support for 90+ Plugins

More than 90 plugins are supported, including the widely used PostGIS and Zhparser.
These plugins enable RDS to handle geographic and spatial data, support data synchronization between heterogeneous databases, and configure scheduled tasks.

15+ Security Certifications

RDS helps you meet core security and compliance requirements.
RDS has earned over 15 security certifications such as ISO 20000, CSA STAR, and CCSP Level 3.

Less Inexpensive Than On-premises Databases

Using on-premises databases, you have to invest heavily in the early stages. For using RDS, there is no hardware or software to buy.
If you host your own database using ECSs, unlike using RDS, you must purchase, install, and upgrade database software separately. Time-consuming administrative tasks are simplified with the RDS DBA Assistant.

Migrate with Ease Using RDS for PostgreSQL

High Concurrency: E-Commerce
Reliability: Finance
Geospatial Data: Location-based Apps
Complex Data Types: Research

High Concurrency: E-Commerce

Scenario

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

It maintains excellent performance in high concurrency and heavy load scenarios.

Stable Development Environment

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

Related Services

Elastic Cloud Server

Virtual Private Network

Object Storage Service

Reliability: Finance

Scenario

RDS for PostgreSQL uses Multi-Version Concurrency Control (MVCC) to ensure data consistency. Data is synchronized between primary and standby DB instances to prevent data loss. Cold data is stored in OBS, a less expensive option than storing historical data in database storage.

Advantages

MVCC

Modifications you made to a transaction are invisible to other users, complying with the properties of Atomicity, Consistency, Isolation, Durability (ACID).

Low Synchronization Delay

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

Related Services

Elastic Cloud Server

Virtual Private Network

Object Storage Service

Geospatial Data: Location-based Apps

Scenario

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

Advantages

Spatial Data Types

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

Efficient Spatial Analysis

RDS provides efficient spatial analysis functions and works with OBS for unlimited object storage.

Simple Spatial Operations

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

Related Services

Elastic Cloud Server

Virtual Private Network

Object Storage Service

Complex Data Types: Research

Scenario

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

RDS stores data accurately and uses a VPN to protect it.

Expression Indexes

You can build indexes for generic expressions rather than values or columns.

Custom Data Types

With RDS, you can quickly and easily process custom data types.

Related Services

Elastic Cloud Server

Virtual Private Network

Object Storage Service

Continuous Service Innovation with Millions of Customers

First Automobile Works (FAW) INCA

FAW Speeds Up Intelligent Transformation with Huawei Cloud RDS

FAW uses Huawei Cloud RDS for MySQL and RDS for PostgreSQL to store their user data, vehicle data, configuration data, and analytic data. RDS ensures almost zero delay of primary/standby replication, and no data is lost even when FAW systems are heavily loaded.

INCA Designs a SaaS Pharmaceutical System Using Huawei Cloud RDS and DRS

INCA migrated its pharmaceutical system to RDS for PostgreSQL using Data Replication Service (DRS), with no impact on services and zero data loss. After the migration, the disk I/O performance doubled and the database administration efficiency improved by 70%.

Documentation

Getting Started

Getting Started

Buying an RDS Instance

Connecting to an RDS Instance

Basic Concepts

Instance Statuses

More
FAQs

FAQs

Resource Freezing, Release, Stopping, Deletion, and Unsubscription

Database Migration

Database Connection

Backup and Restoration

More
Best Practices

Best Practices

Creating Databases

Basic Operations Using pgAdmin

Using Client Drivers to Enable Failover and Read/Write Splitting

Security Best Practices

More

Start Your

Cloud Journey

Buy

More Services

Data Replication Service (DRS)

Migrate your databases with minimal downtime

GaussDB

An enterprise-grade, distributed relational database

Database and Application Migration UGO

A professional service for heterogeneous database schema migration

RDS for PostgreSQL