Before you manage data in a database, you must connect to the database. This topic describes how to connect to a database by using Data Management (DMS).
Prerequisites
An AnalyticDB for PostgreSQL instance is created, and a privileged account is created for the instance. For more information, see Create a privileged account.
Procedure
- Log on to the AnalyticDB for PostgreSQL console.
- In the upper-left corner of the console, select a region.
- Find the instance that you want to manage and click the instance ID.
Click Log On to Database in the upper-right corner.
Optional:The first time you use DMS, you must authorize DMS to access AnalyticDB for PostgreSQL resources. Click Go to RAM role authorization and grant permissions. For more information, see Authorize DMS to access Alibaba Cloud resources.
In the Log on to Database Instance dialog box, specify Database Account and Database password.
Click Login.
On the SQL Console tab, execute SQL statements to manage data.
References
AnalyticDB for PostgreSQL is fully compatible with the message-based protocol of PostgreSQL. You can connect to an instance by using tools that support the protocol. For more information about how to connect to an instance by using client tools, see Use client tools to connect to an instance.