Buying an RDS for PostgreSQL Instance and Connecting to It Through DAS

Data Admin Service (DAS) enables you to manage instances on a web-based console, simplifying database management and improving working efficiency. You can connect to and manage your instances through DAS. The permission required for connecting to DB instances through DAS has been enabled for you by default. Using DAS to connect to your DB instance is recommended, which is more secure and convenient.

This section describes how to purchase an RDS for PostgreSQL instance and how to connect to it using DAS.

Operation Process

Process	Description
Step 1: Buy an RDS for PostgreSQL DB Instance	Select required basic settings and additional options and buy an RDS for PostgreSQL DB instance.
Step 2: Connect to the RDS for PostgreSQL Instance	Connect to the RDS for PostgreSQL instance through DAS.

Step 1: Buy an RDS for PostgreSQL DB Instance

Select required basic settings and additional options and buy an RDS for PostgreSQL DB instance. For details, see section "Buying an RDS for PostgreSQL DB Instance" in Relational Database Service User Guide.

Step 2: Connect to the RDS for PostgreSQL Instance

Since no password is configured in Step 1: Buy an RDS for PostgreSQL DB Instance, you need to reset the password before connecting to the instance. In the instance list, choose More > Reset Password.
Enter a new password, confirm the password, and click OK.
Click Log In in the Operation column.
Enter the required information and click Log In.
- Login Username: Enter root.
- Database Name: Enter postgres.
- Password: Enter the password you specified in 2.
Choose SQL Operations > SQL Window.
Create a database, for example, test1.
CREATE DATABASE test1;
Switch to test1 and create a schema (for example, schema1) in the database.
CREATE SCHEMA schema1;
Switch to schema1 and create a table named mytable with only one column. Specify the column name as firstcol and the column type as integer.
CREATE TABLE schema1.mytable (firstcol int);
Insert data to the table.
INSERT INTO schema1.mytable values (100);

Query data in the table.

SELECT * FROM "schema1"."mytable"
In the upper part of the page, choose Account Management > Role Management.
Click Create Role and complete basic settings. user1 is used as an example.
Click the Permissions tab and grant user1 the permissions to perform operations on databases, schemas, and tables.
On the Development Tool page, click Add Login and log in to the database as user1.
Create schema2 in test1 to verify that user1 has the CREATE permission.
CREATE SCHEMA schema2;