All Products
Search
Document Center

ApsaraDB RDS:What is Apsaradb RDS for PostgreSQL

Last Updated:Sep 19, 2023

This topic provides an overview of ApsaraDB RDS for PostgreSQL and describes the related terms.

Disclaimer

Some features or functions that are described in this document may be unavailable. The specific terms and conditions in your commercial contract shall prevail. This document serves as a user guide that is for reference only. Content in this document is provided without warranty of any kind, expressed or implied.

RDS PostgreSQL

ApsaraDB RDS supports the PostgreSQL database engine. ApsaraDB RDS for PostgreSQL is fully compatible with SQL and supports a diverse range of data formats such as JSON, IP, and geometric data. In addition to support for features such as transactions, subqueries, multi-version concurrency control (MVCC), and data integrity check, ApsaraDB RDS for PostgreSQL provides a series of features, such as high availability, backup, and restoration, to ease O&M loads. ApsaraDB RDS for PostgreSQL also provides the following advanced features:

  • Fully encrypted database: This feature is used to encrypt data on the user side before the data is transmitted to RDS instances. This feature helps defend against security threats inside and outside the cloud to protect user data at all times and allow only authorized users to access the data. For more information, see Overview.

  • Read-only RDS instances: If the primary RDS instance is overwhelmed by a large number of read requests, your workloads may be interrupted. In this case, you can create one or more read-only RDS instances to offload read requests from the primary RDS instance. For more information, see Create a read-only ApsaraDB RDS for PostgreSQL instance. Read-only RDS instances help increase the read capability of your database system and the throughput of your application.

  • Database proxy (read/write splitting): A database proxy is used as the network proxy between a database and an application. The database proxy forwards all requests from the application to the RDS instances in your database system. The database proxy feature supports automatic read/write splitting. The database proxy is easy to use and maintain, and delivers high availability and high performance. For more information, see What are database proxies?

  • Babelfish for ApsaraDB RDS for PostgreSQL: This feature is developed based on the Babelfish for PostgreSQL open source project. You can enable Babelfish when you create an RDS instance. After you enable Babelfish, your RDS instance can query and process data from Microsoft SQL Server databases and PostgreSQL databases. This way, your RDS instance can parse and execute Transact-SQL (T-SQL) statements. For more information, see Introduction to Babelfish. You do not need to switch your database driver or rewrite SQL statements. You need to only migrate the database of your application from SQL Server to an RDS instance for which Babelfish is enabled by changing a small amount of code.

  • Terraform: Terraform is an open source tool that allows you to preview, configure, and manage RDS instances in a secure and efficient manner. For more information, see Overview.

  • Extension: A wide range of extensions are available in different scenarios, such as geographic information, search and recommendation, artificial intelligence (AI), financial security, Internet of Things (IoT), and gaming. The extensions provide strong support to improve the efficiency of O&M and application development. For more information, see Supported extensions.

  • Ganos: Ganos is a spatio-temporal engine. Ganos provides a series of data types, functions, and stored procedures for ApsaraDB RDS for PostgreSQL to store, index, query, analyze, and compute spatial or spatio-temporal data in an efficient manner. For more information, see Overview of Ganos.

For more information about the features that are supported by ApsaraDB RDS for PostgreSQL, see Features of ApsaraDB RDS for PostgreSQL.

Note
  • To manage complex business, you can purchase a support plan to request support from enterprise instant messaging (IM) groups, technical account managers (TAMs), and service managers.

  • For more information about ApsaraDB RDS for PostgreSQL, visit the ApsaraDB RDS for PostgreSQL product page.

Terms

  • instance: An RDS instance is a database process that consumes independent physical memory resources. You can specify a specific memory size, storage capacity, and database type for an RDS instance. The performance of an RDS instance varies based on the specified memory size. After an RDS instance is created, you can change its specifications or delete the instance.

  • database: A database is a logical unit that is created on an RDS instance. One RDS instance can have multiple databases. Each database must have a unique name on the RDS instance on which the database is created.

  • region and zone: Each region is a physical data center. Each region has multiple isolated locations known as zones. Each zone has its own independent power supply and networks. For more information, see Global infrastructure of Alibaba Cloud.

General terms

Term

Description

on-premises database

A database that is deployed in a data center or a database that is not deployed on an ApsaraDB RDS instance.

ApsaraDB RDS for XX (XX represents one of the following database engines: MySQL, SQL Server, PostgreSQL, and MariaDB.)

ApsaraDB RDS with a specific database engine. For example, ApsaraDB RDS for MySQL indicates an ApsaraDB RDS instance that runs MySQL.