Querying the Target Version to Which a DB Instance Can Be Upgraded (RDS for PostgreSQL)

Function

This API is used to query the target version to which an RDS for PostgreSQL DB instance can be upgraded.

• Before calling an API, you need to understand the API in Authentication.
• Before calling this API, obtain the required region and endpoint.

Constraints

• This API is available to RDS for PostgreSQL only.
• This operation cannot be performed when the DB instance is in any of the following statuses: creating, changing instance specifications, changing port, frozen, or abnormal.
• Major version upgrades are available to the following versions:
  • RDS for PostgreSQL 12: 12.7 or later
  • RDS for PostgreSQL 13: 13.3 or later
  • RDS for PostgreSQL 14: 14.4 or later
  • Major version upgrades are unavailable to RDS for PostgreSQL 11.
• Before a major version upgrade, perform an upgrade check. If there is no successful upgrade check in the validity period, a major version upgrade is not allowed.

URI

• URI format

  GET /v3/{project_id}/instances/{instance_id}/major-version/available-version

• Parameter description

  Table 1 Parameter description

  Name	Type	Mandatory	Description
  project_id	String	Yes	Project ID of a tenant in a region. To obtain it, refer to Obtaining a Project ID.
  instance_id	String	Yes	Instance ID.

Request

• Request parameters

  None

• Example

  https://{Endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/3aa441c4c98a4b36b100a7e3e87d17cein03/major-version/available-version

Response

• Normal response

  Table 2 Parameter description

  Name	Type	Description
  available_versions	Array of Strings	Available versions.

• Example normal response

  {
           "available_versions": ["13.9", "14.4"] 
  }

• Abnormal response

  For details, see Abnormal Request Results.

Status Code

• Normal

  200

• Abnormal

  For details, see Status Codes.

Error Code

For details, see Error Codes.