Help Center/ Relational Database Service/ API Reference/ API v3 (Recommended)/ Upgrading a Major Version (RDS for PostgreSQL)/ Querying the Target Version to Which a DB Instance Can Be Upgraded (RDS for PostgreSQL)
Updated on 2025-12-09 GMT+08:00
View PDF
Share

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.

Authorization Information

Each account has all the permissions required to call all APIs, but IAM users must be assigned the required permissions.
  • If you are using role/policy-based authorization, see Permissions and Supported Actions for details on the required permissions.
  • If you are using identity policy-based authorization, the following identity policy-based permissions are required.

Action

Access Level

Resource Type (*: required)

Condition Key

Alias

Dependencies

rds:instance:listAll

read

-

-

rds:instance:list

-

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.

URI

  • URI format

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

  • Parameter description
    Table 1 Parameters

    Parameter

    Type

    Mandatory

    Description

    project_id

    String

    Yes

    Project ID of a tenant in a region.

    To obtain the value, see Obtaining a Project ID.

    instance_id

    String

    Yes

    Instance ID.

Request

  • Request parameters

    None

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

Response

  • Normal response
    Table 2 Parameters

    Parameter

    Type

    Description

    available_versions

    Array of Strings

    Available versions.
  • Example normal response 
    {
         "available_versions": ["13.9", "14.4"] 
}

Status Code

Error Code

For details, see Error Codes.