AnalyticDB:Quick Start for instances in elastic storage mode

Create an instance

1. Log on to the AnalyticDB for PostgreSQL console.

2. In the upper-right corner of the page, click Create Instance to go to the purchase page.

3. On the purchase page, configure the core parameters to quickly launch an instance. You can leave the other parameters at their default settings. For more information about all parameters, see Create an instance.

   Parameter	Description	Example for This Tutorial
   Product Type	Subscription:A prepaid method, ideal for long-term use, that more cost-effective than pay-as-you-go and offers larger discounts for longer subscription periods. Pay-as-you-go: A postpaid method with hourly billing, ideal for short-term needs. Release the instance at any time to save costs.	Pay-as-you-go
   Region and Zone	The geographical location of the instance. This cannot be changed after purchase. We recommend that you create the instance in the same region as your ECS instances to enable internal network communication.	China (Hangzhou): Zone J
   Instance Resource Type	Elastic Storage Mode: Supports independent disk expansion and smooth online scaling. Serverless Pro: You need to specify only the required compute resources without pre-allocating storage resources.	Elastic Storage Mode
   Engine Version	We recommend that you select 7.0 Standard Edition for its expanded feature set. 6.0 Standard Edition is also supported.	7.0 Standard Edition
   Edition	High-performance (Basic Edition): Suitable for most business analysis scenarios. High-availability Edition: Recommended for core business applications.	High-performance Edition (Basic Edition)
   VPC	The ID of the Virtual Private Cloud (VPC). To connect to an ECS instance in the same region over an internal network, select the same VPC as the ECS instance. You can select an existing VPC or create a VPC and vSwitch as prompted.	vpc-xxxx
   vSwitch	The vSwitch within the VPC. If no vSwitches are available, no VSwitch resources are available in the current zone. You can switch to another availability zone or create a vSwitch in the current zone as prompted.	vsw-xxxx

4. Click Buy Now, confirm the order information, and click Activate Now.

5. After you complete the payment, click Management Console to return to the instance list and view the new instance.

   Note

   The initialization of an AnalyticDB for PostgreSQL instance takes some time. Proceed with the next steps only after the instance status changes to Running.

(Optional) Configure an IP whitelist

1. In the instance list, find the instance that you just created and click the instance ID to go to the details page.

2. In the navigation pane on the left, click Security Controls.

3. Click Create Whitelist and configure the following parameters:

   Parameter	Description
   Whitelist Name	The name of the whitelist. The name can contain lowercase letters, digits, and underscores (_). The name must start with a lowercase letter and end with a lowercase letter or a digit. The name must be 2 to 32 characters in length.
   IP Addresses	The IP addresses or CIDR blocks that are allowed to access the instance. Separate multiple IP addresses with commas (,). A maximum of 999 unique IP addresses can be specified. You can enter specific IP addresses such as 10.23.12.24 and CIDR blocks such as 10.23.12.24/24. /24 indicates the length of the IP address prefix. An IP address prefix can be 1 to 32 bits in length. If you set the prefix length to 0, for example, 0.0.0.0/0 or 127.0.0.1/0, all IP addresses are allowed to access the instance. This poses a high security risk. Proceed with caution. The IP address 127.0.0.1 indicates that no external IP addresses are allowed to access the instance.

4. Click OK.

Create an initial account

1. In the left-side navigation pane, click Account Management.

2. Click Create Account. In the Create Account window, enter an account name, set a password, and then click OK.

   Parameter	Description
   Account	The name of the initial account. The name can contain lowercase letters, digits, and underscores (_). The name must start with a lowercase letter and end with a lowercase letter or a digit. The name cannot start with gp. The name must be 2 to 16 characters in length.
   New Password and Confirm Password	The password of the initial account. The password must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters. Special characters include ! @ # $ % ^ & * ( ) _ + - =. The password must be 8 to 32 characters in length. Important To ensure data security, we recommend that you change your password on a regular basis and do not use passwords that you used before.

Load a sample dataset

You can load a sample dataset for testing. It takes about 6 to 8 minutes.

1. In the upper-right corner of the instance details page, choose Sample Dataset > Load Dataset.

   

2. In the Load Sample Dataset dialog box, click OK.

Connect to the database

This section demonstrates how to connect to the database by using DMS. For other clients, see Client connection.

1. In the upper-right corner of the instance details page, click Log On To Database.

2. On the Log On To Instance page, enter the Database Account and Database Password, and click Logon.

Query data

1. In the left-side navigation pane of the DMS console, click the target instance (if you are in simple mode, switch to the Database Instances tab first) and verify that the adb_sampledata_tpch database exists.

   If the database is not displayed, click the refresh button next to the target instance.

   

2. Double-click the public schema under the adb_sampledata_tpch database to open a SQL Console window. Execute the following SQL statement to query data.

   SELECT count(*) FROM lineitem;

   The following result is returned:

   +-----------+
   | count(*)  |
   +-----------+
   |59986052   |
   +-----------+