How Does ApsaraDB RDS for PostgreSQL Work
Overview of ApsaraDB RDS for PostgreSQL
The ApsaraDB RDS for PostgreSQL is an advanced open-source database that is compatible with SQL and supports various data types, such as JSON data, IP data, and geometry data. PostgreSQL supports basic features, such as transactions, subqueries, multi-version concurrency control (MVCC), and data integrity check. In addition to the basic features, PostgreSQL supports the high availability architecture and provides the backup and restoration feature to facilitate database operation and maintenance (O&M). PostgreSQL also provides the following advanced features and functions:
- ApsaraDB for MyBase dedicated clusters: An ApsaraDB for MyBase dedicated cluster consists of multiple hosts, such as ECS instances of the ECS.i2.xlarge instance type and ECS Bare Metal instances. You can run instances on these hosts.
- Fully encrypted databases: You can create a fully encrypted database on your RDS instance to store data that is uploaded from the user end. Data is encrypted before it is uploaded to the fully encrypted database. The fully encrypted database protects data from internal and external security threats and allows only authorized users to access the data.
- Read-only RDS instances: If the primary RDS instance is overwhelmed by a large number of reading requests, your workloads may be interrupted. In this situation, you can create one or more read-only RDS instances to offload read requests from the primary RDS instance.
The Limits of ApsaraDB RDS PostgreSQL
To guarantee stability and security, you must understand the limits of ApsaraDB RDS PostgreSQL as below:
- RDS does not offer the superuser permission.
- PostgreSQL provides a dual-node cluster based on the master/slave replication architecture(except for the basic edition). The slave instance in the architecture is invisible to you, and your application cannot access the slave instance directly.
- The instance must be restarted through the RDS console or OpenAPI.
How ApsaraDB RDS PostgreSQL Works?
General workflow to use RDS PostgreSQL
The following figure shows the operations that you need to perform from purchasing an instance to using the instance.

Standard enterprise-level PostgreSQL solution
Based on Alibaba Cloud's multi-zone architecture, the service supports local disaster recovery and ensures the security and stability of enterprise databases. Compared with other open source databases, PostgreSQL is a better choice for online transaction processing and shows better performance at JOIN queries involving multiple tables.

Unlimited storage expansion
To expand your storage, you can store frequently used hot data in SSDs and use OSS to store cold data. You can also compress OSS data based on the standard GZIP algorithm to further reduce the storage cost. With AnalyticDB for PostgreSQL, you can expand your OLAP applications horizontally to provide better performance and more storage space.
Boosts IoT development with GIS and JSON
JSON and GIS data types are essential for processing IoT transactions. In traditional solutions, developers and database administrators frequently use hardcoding when interacting with NoSQL databases and professional GIS analytical tools. With PostgreSQL, you can use SQL to perform operations on JSON and GIS data directly. This saves the trouble of data imports and significantly increases the development efficiency.
Related Products:
ApsaraDB RDS for PostgreSQL
Known as "The world’s most advanced open source database", PostgreSQL enables OLTP databases that handle enterprise-level SQL statements, supports NoSQL data types such as JSON, XML and hstore, and supports GIS data processing.
Related Blog:
Migrating from a Relational PostgreSQL to ApsaraDB RDS for PostgreSQL
This tutorial introduces the ApsaraDB Stack, part of Alibaba Cloud's wider suite of database services products, that will free you from the administrative tasks often associated with managing your corporate data.
Related Learning Path:
Alibaba Cloud ApsaraDB for RDS (Relational Database Service) is a stable and reliable online database service that scales elastically.
Check for more information:
https://www.alibabacloud.com/getting-started/learningpath/rds
Read previous post:
Read next post:
-
-
Alibaba Clouder
2,593 posts | 797 followers
Follow
-
-
Alibaba Clouder
2,593 posts | 797 followers
Follow
Related Products
-
ApsaraDB RDS for PostgreSQL
An on-demand database hosting service for PostgreSQL with automated monitoring, backup and disaster recovery capabilities
Learn More -
AnalyticDB for PostgreSQL
An online MPP warehousing service based on the Greenplum Database open source program
Learn More -
PolarDB for PostgreSQL
Alibaba Cloud PolarDB for PostgreSQL is an in-house relational database service 100% compatible with PostgreSQL and highly compatible with the Oracle syntax.
Learn More -
ApsaraDB RDS for MySQL
An on-demand database hosting service for MySQL with automated monitoring, backup and disaster recovery capabilities
Learn More
More Posts by Alibaba Clouder
- MyBatis with a More Fluent Experience
- Alibaba Cloud Sustainability Report 2021
- Comparing CNI Models in Container Service for Kubernetes — Alibaba Cloud Series Part 1
- [Infographic] 5 Steps to Accelerate Your Digitalization in Asia
- Attackers Use the Vulnerability of ShowDoc to Spread Botnets
- Powerful: MyBatis and Three Streaming Query Methods
- What is the Difference between Spring Boot and Spring?
- What are the Differences and Functions of the Redo Log, Undo Log, and Binlog in MySQL?
- On the In-Depth Cluster Scheduling and Management
- Alibaba Technological Practices: Experiences in Cloud Resource Scheduling