All Products
Document Center

AnalyticDB for PostgreSQL:Connect to a database

Last Updated:Jul 21, 2023

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).


An AnalyticDB for PostgreSQL instance is created, and a privileged account is created for the instance. For more information, see Create a privileged account.


  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select a region.
  3. Find the instance that you want to manage and click the instance ID.
  4. Click Log On to Database in the upper-right corner.

  5. 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.

  6. In the Log on to Database Instance dialog box, specify Database Account and Database password.

  7. Click Login.

  8. On the SQL Console tab, execute SQL statements to manage data.


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.

What to do next

Query data