AnalyticDB:Quick start for elastic storage mode

Free trial

Alibaba Cloud offers a free trial for Elastic Storage Mode instances. If you are a new user of AnalyticDB for PostgreSQL, you can apply on the Alibaba Cloud Free Trial page. If you are not eligible for a free trial, create an instance by following the procedure in this topic.

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. Keep default values for other parameters. All parameters are described in Create an instance.

   Parameter	Description	Example
   Logon Instance	Subscription: Prepaid. Best for long-term use and more cost-effective than pay-as-you-go. Longer subscriptions offer higher discounts. Pay-as-you-go: Postpaid and billed hourly. Best for short-term use. Release the instance anytime to stop charges.	Pay-as-you-go
   Region and Zone	The region of the instance. Cannot be changed after purchase. To use internal network communication, create the instance in the same region as your ECS instance.	China (Hangzhou): Zone J
   Product Type	Elastic Storage Mode: Scales storage capacity independently and online. ServerlessPro: Specify only compute resources. No storage pre-allocation required.	Elastic storage mode
   Engine Version	Select 7.0 Standard Edition for more features. 6.0 Standard Edition is also supported.	7.0 Standard Edition
   Instance Edition	High-performance (Basic Edition): Suitable for most business analytics scenarios. High-availability Edition: Recommended for core enterprise services.	High-performance (Basic Edition)
   VPC	Select a VPC. To connect to an ECS instance in the same region over the internal network, select the same VPC. Create a VPC and vSwitch if needed.	vpc-xxxx
   vSwitch	Select a vSwitch in the VPC. If none are listed, choose a different availability zone or create a vSwitch.	vsw-xxxx

4. Click Buy Now, verify the order, and click Create Now.

5. Complete the payment and click Console to return to the instance list.

   Note

   An AnalyticDB for PostgreSQL instance takes time to initialize. Wait until the status changes to Running before proceeding.

(Optional) Configure an IP whitelist

1. In the instance list, click the instance ID to open its details page.

2. In the left-side navigation pane, click Security Controls.

3. Click Create Whitelist and configure the following parameters:

   Parameter	Description
   Whitelist Name	The name of the new whitelist group. The name must meet the following requirements: It must consist of lowercase letters, digits, or underscores (_). It 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 to add to the whitelist. Note the following: Separate multiple IP addresses with commas (,). Duplicate IP addresses are not allowed. You can add a maximum of 999 IP addresses. You can use IP addresses in the 10.23.12.24 format and CIDR blocks in the 10.23.12.24/24 format. CIDR stands for Classless Inter-Domain Routing. In CIDR mode, /24 specifies the length of the address prefix. The prefix length can be an integer from 1 to 32. Setting the prefix length to 0, such as in 0.0.0.0/0 or 127.0.0.1/0, allows access from any IP address. This poses a high security risk. Proceed with caution. 127.0.0.1 denies access from all external IP addresses.

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 and set a password. Then, click OK.

   Parameter	Description
   Account	The initial account name must meet the following requirements: Must contain only lowercase letters, digits, and underscores (_). Must start with a lowercase letter and end with a lowercase letter or digit. Cannot start with gp. Must be 2 to 16 characters long.
   New Password and Confirm Password	The password must meet the following requirements: Must contain characters from at least three of the following categories: uppercase letters, lowercase letters, digits, and special characters. The supported special characters are !@#$%^&*()_+-=. Must be 8 to 32 characters long. Important For data security, change your password regularly and do not reuse previous passwords.

Load a sample dataset

Load a sample dataset for testing. This 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 uses DMS to connect. Other methods are covered in Client connections.

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 then click Log On.

Query data

1. In the DMS left navigation pane, click the target instance (in simple mode, switch to the Database Instance tab first) and verify the adb_sampledata_tpch database exists.

   If not displayed, click the refresh icon next to the instance.

   

2. Double-click the public schema under adb_sampledata_tpch to open a SQL console. Run the following query.

   SELECT count(*) FROM lineitem;

   Expected result:

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