AnalyticDB:DBeaver

Prerequisites

Before you begin, make sure you have:

• An endpoint and port. Use the internal endpoint if your client runs on an Elastic Compute Service (ECS) instance in the same region and network type as the AnalyticDB for PostgreSQL instance. Apply for a public endpoint if your client is in a different region, uses a different network type, or is outside Alibaba Cloud. For details, see Manage public endpoints.

• Your client IP added to the instance whitelist. See Configure an IP address whitelist.

To find the endpoint and port, go to the AnalyticDB for PostgreSQL console, click the instance ID, and check the Database Connection Information section on the Basic Information page.

Connect to AnalyticDB for PostgreSQL

1. Download and install DBeaver Community Edition.

2. Start DBeaver, then choose Database > New Database Connection.

3. In the Connect to a database dialog, select Greenplum and click Next.

   Note

   The first time you connect to an instance, you must download the corresponding database driver file.

4. On the Main tab of the Connection Settings page, fill in the following parameters:

   Parameter	Description	Example
   Host	The endpoint of the instance. In the Database Connection Information section of the Basic Information page, use Internal Endpoint for private connections or Public endpoint for public connections.	gp-bp1g*************-master.gpdbmaster.rds.aliyuncs.com
   Port	The port of the instance. Find it alongside the endpoint in the console.	5432
   Database	The name of the database.	postgres
   Username	The database account. See Create a database account.	testuser
   Password	The password for the database account.	PassW0rd

5. Click Test Connection. A Connected message confirms the connection is working. If you see an org.postgresql.Driver error, update the driver manually:

   1. On the Main tab, click Edit Driver Settings.

   2. On the Libraries tab, click Download/Update.

6. Click Finish.