Community Blog How Does ApsaraDB RDS for PostgreSQL Work

How Does ApsaraDB RDS for PostgreSQL Work

ApsaraDB RDS for PostgreSQL is an on-demand database hosting service for PostgreSQL with automated monitoring, backup, and disaster recovery capabilities.

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:

0 0 0
Share on

Alibaba Clouder

2,605 posts | 739 followers

You may also like

Alibaba Clouder

2,605 posts | 739 followers

Related Products