• For instances of ApsaraDB RDS for PostgreSQL 10 Cluster Edition (Local SSD), PostgreSQL 10 Basic Edition, and PostgreSQL 9.4, you can delete a database through the Data Management Service (DMS) console or universal clients.
  • For instances of ApsaraDB RDS for PostgreSQL 11 Cluster Edition (Standard SSD) and PostgreSQL 10 Cluster Edition (Standard SSD), you can directly create and manage databases in the ApsaraDB for RDS console.

For PostgreSQL 11 Cluster Edition (Standard SSD) or PostgreSQL 10 Cluster Edition (Standard SSD)

  1. Log on to the ApsaraDB RDS for PostgreSQL console.
  2. In the upper-left corner of the page, select the region where the instance is located.

  3. Find the instance and click the instance ID.
  4. In the left-side navigation pane, click Databases.
  5. Find the database to be deleted, and click Delete in the Actions column.
  6. In the dialog box that appears, click OK.

For PostgreSQL 10 Cluster Edition (Local SSD), PostgreSQL 10 Basic Edition, or PostgreSQL 9.4

  1. Log on to the ApsaraDB for RDS console.
  2. In the upper-left corner of the page, select the region where the instance is located.

  3. Find the instance and click the instance ID.
  4. Click Log On to DB in the upper-right corner of the page to enter the Quick Logon page of the DMS console.
  5. On the Quick Logon page, check the endpoint and port information displayed on the RDS Database Logon page. If the information is correct, enter the username and password of the database, as shown in the following figure.

    Parameter Description
    Endpoint: port The endpoint and port information of the instance.
    Database username The name of the account to access the database.
    Password The password of the account to access the database.
  6. If the system prompts you to add the IP CIDR block of the DMS server to the RDS whitelist, click Configure Whitelist. For more information about how to manually configure the whitelist, see Configure a whitelist.
  7. Click Log On.
  8. In the top navigation bar, choose SQL Operations > SQL Window.
  9. Run the following statement to delete the database:
    drop database <database name>;
  10. Click Execute to delete the database.