This topic describes how to update the minor engine version of an ApsaraDB RDS for PostgreSQL instance. You can update the minor engine version of your RDS instance to improve database performance, use new features, and fix bugs.

For more information about the features that are supported by different minor engine versions, see Release notes of minor AliPG versions.

Precautions

  • When you update the minor engine version of your RDS instance, the instance may encounter a transient connection of about 30 seconds. We recommend that you update the minor engine version during off-peak hours. Otherwise, make sure that your application is configured to automatically reconnect to your RDS instance.
  • After you update the minor engine version of your RDS instance, you cannot downgrade the instance to the previously used version.
  • When you perform operations such as upgrading your RDS instance, ApsaraDB RDS updates the instance to the latest minor engine version.

Update the minor engine version of an RDS instance equipped with local SSDs

If your RDS instance is equipped with local SSDs, you cannot manually update the minor engine version of the instance. In this case, you can restart your RDS instance. During the restart process, ApsaraDB RDS updates the minor engine version of your RDS instance to the latest version. For more information, see Restart an ApsaraDB RDS for PostgreSQL instance.

Note If your RDS instance is a primary RDS instance and is attached with read-only RDS instances, you must restart all the read-only RDS instances one by one before you restart the primary RDS instance. If you restart only the primary RDS instance, ApsaraDB RDS does not update the minor engine versions of the read-only RDS instances.

Update the minor engine version of an RDS instance equipped with standard SSDs or enhanced SSDs (ESSDs)

Note

If your RDS instance is a primary RDS instance and is attached with read-only RDS instances, you can use one of the following two methods to update the minor engine versions of these instances:

  • Update the minor engine version of the primary RDS instance. ApsaraDB RDS immediately updates the minor engine versions of the read-only instances all at once.
  • Update the minor engine versions of the read-only RDS instances one by one. Then, update the minor engine version of the primary RDS instance. This method is suitable if you do not want to update the minor engine versions of the read-only instances all at once.
  1. Visit the RDS instance list, select a region above, and click the target instance ID.
  2. In the Configuration Information section of the page, click Upgrade Minor Engine Version.
    Update the minor engine version of an ApsaraDB RDS for PostgreSQL instance
  3. In the dialog box that appears, select Upgrade Time and click OK.
    Select Upgrade Time

View the minor engine version of an RDS instance

You can use one of the following two methods to view the minor engine version of your RDS instance:
  • Log on to the ApsaraDB RDS console and go to the Basic Information page of the RDS instance.
    Note This method is supported only for RDS instances that are equipped with standard SSDs or ESSDs.
  • Connect to the RDS instance and run the show rds_release_date; command. For more information, see Connect to an ApsaraDB RDS for PostgreSQL instance.
    Note This method is supported for RDS instances that are equipped with local SSDs, standard SSDs, or ESSDs.

Related operations

Operation Description
Update minor engine version Updates the minor engine version of an ApsaraDB RDS instance.