This topic describes how to reset the password of an account for an RDS for PostgreSQL instance in case that the password is lost.

Note For ApsaraDB RDS for PostgreSQL 10 Cluster Edition (Local SSD), PostgreSQL 10 Basic Edition, and PostgreSQL 9.4 instances, you can only reset the password for the premier accounts.

For PostgreSQL 11 Cluster Edition (Standard SSD) and 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 Accounts.
  5. Find the account that you want to reset the password, and click Reset Password.

  6. In the dialog box that appears, enter a new password, and click OK.
    Note The password must meet the following requirements:
    • The password must be 8 to 32 characters in length.
    • It must contain three of the following character types: uppercase letters, lowercase letters, digits, and special characters.
    • Special characters include ! @ # $ % ^ & * ( ) _ + - =

For PostgreSQL 10 Cluster Edition (Local SSD), PostgreSQL 10 Basic Edition, and 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. In the left-side navigation pane, click Databases.
  5. Find the account that you want to reset the password, and click Reset Password.

  6. In the dialog box that appears, enter a new password, and click OK.
    Note The password must meet the following requirements:
    • The password must be 8 to 32 characters in length.
    • It must contain three of the following character types: uppercase letters, lowercase letters, digits, and special characters.
    • Special characters include ! @ # $ % ^ & * ( ) _ + - =

API reference

Operation Description
ResetAccountPassword You can call this operation to reset the password of an account.