Create an RDS for PostgreSQL instance

Prerequisites

You have registered an Alibaba Cloud account.

For more information, see Sign up with Alibaba Cloud.

Precautions

• Subscription instances cannot be converted to pay-as-you-go instances.
• Pay-as-you-go instances can be converted to subscription instances. For more information, see Switch from pay-as-you-go billing to subscription billing.
• By default, each Alibaba Cloud account can create up to 30 pay-as-you-go RDS instances. You can open a ticket to apply for an increase to the limit.

Procedure

1. Log on to the RDS console.
2. On the Instances page, click Create Instance.
3. Select a billing method:
   • Pay-As-You-Go: indicates post payment (billed by hour). For short-term requirements, create pay-as-you-go instances because they can be released at any time to save costs.
   • Subscription: indicates prepayment. You must pay when creating an instance. For long-term requirements, create subscription instances because they are more cost-effective. Furthermore, the longer the subscription, the higher the discount.
4. Set the following parameters.

   Parameter	Description
   Region	Select the region in which the RDS instance to be purchased will be located. The region cannot be changed after the instance is created. We recommend that you: Select the same region as the corresponding ECS instance to avoid incurring charges for Internet traffic usage and guarantee fast access. Check whether the selected region supports your required MySQL version and whether multi-zone support is available.
   Database Engine	Select a DB engine. In this example, select MySQL. Note The available DB engines vary depending on the region you select.
   Version	Select a version of MySQL. You can select MySQL 5.5, 5.6, 5.7, or 8.0. Note The available versions vary depending on the region you select.
   Edition	Select an RDS edition. Valid values: Basic: The DB system has only one instance. In this edition, computation is separated from storage, which is cost-effective. However, we recommend that you do not use this edition in production environments. High-availability: The DB system has two instances: one master instance and one slave instance. The two instances work in a classic high-availability architecture. Enterprise Edition: The DB system has three instances: one master instance and two slave instances. The three instances are located in three different zones in the same region to guarantee service availability. This edition is available to the China (Hangzhou), China (Shanghai), China (Shenzhen), and China (Beijing) regions. Note The available editions vary depending on the DB engine version you select. For information about the RDS editions, see RDS editions overview.
   Storage Type	Select a storage type. Valid values: Local SSD: An SSD that is located on the same node as the DB engine. Storing data to local SSDs reduces I/O latency. Standard SSD: An elastic block storage device that is designed based on a distributed storage architecture. Storing data to cloud SSDs makes separation between computation and storage possible. Enhanced SSD: An SSD that is designed based on the new-generation distributed block storage architecture and the 25 GB and RDMA technologies to reduce single-link latency. Each enhanced SSD can process up to 1,000,000 random read and write requests. For more information, see Storage types.
   Zone	Select a zone. A zone is a physical area within a region. Different zones in the same region are basically the same. You can deploy the master and slave instances in the same zone or in different zones. Multi-zone deployment is more secure because it provides zone-level disaster tolerance.
   Network Type	Select a network type. Valid values: Classic Network: indicates a traditional network. VPC (recommended): short for Virtual Private Cloud. A VPC is an isolated network environment and therefore provides higher security and performance than a classic network. Note Make sure the network type of the RDS instance is the same as that of your ECS instance so that the ECS instance can access the RDS instance through the intranet.
   Type	Select an RDS instance type. The RDS instance type specifies the specifications of the RDS instance. Each type supports a specific number of CPU cores, memory size, maximum number of connections, and maximum IOPS. For more information, see Instance types. Valid values: General-purpose instance: provides dedicated memory and I/O resources, but shares the CPU and storage resources with the other general-purpose instances on the same server. Dedicated instance: provides dedicated CPU, memory, storage, and I/O resources. Dedicated host: provides all the CPU, memory, storage, and I/O resources on the server where it is located. For example, 8 Cores 32 GB (Basic) indicates a general-purpose instance, and 8 Cores 32 GB (Dedicated) indicates a dedicated instance.
   Capacity	The capacity is used for storing data, system files, binlog files, and transaction files.

5. Optional. Set the duration of the billing method for a subscription instance and specify the number of instances to be created. Then, click Buy Now.
   Note For a subscription instance, you can:

   • Select Auto Renew in the Duration section. Then the system can automatically deduct fees to extend the validity period of the instance. For example, if you purchase a three-month subscription instance with Auto Renew selected, the system automatically deducts frees of three months when the instance is about to expire.
   • Click Add to Cart and then click the cart to place the order.
6. On the Order Confirmation page, read and confirm you agree to Terms of Service, Service Level Agreement, and Terms of Use by selecting the checkbox, confirm the order details, and click Pay Now.

What to do next

Log on to the RDS console, select the target region, and view the instance details.

After the RDS instance is created, you must configure whitelists and create accounts for it. If you want to connect to the RDS instance through the Internet, you must also apply for a public endpoint for it. After all is done, you can connect to the RDS instance.

APIs