How to check minor version upgrade targets

Finding automatic minor version upgrade targets

aws rds describe-db-engine-versions \
   --engine <Engine> \
   --engine-version "<Version>" \
   --query "DBEngineVersions[*].ValidUpgradeTarget[*].{AutoUpgrade:AutoUpgrade,EngineVersion:EngineVersion}" \
   --output table 
$ aws rds describe-db-engine-versions \
>   --engine oracle-se2 \
>   --engine-version "19.0.0.0.ru-2019-07.rur-2019-07.r1" \
>   --query "DBEngineVersions[*].ValidUpgradeTarget[*].{AutoUpgrade:AutoUpgrade,EngineVersion:EngineVersion}" \
>   --output table 
-------------------------------------------------------
|              DescribeDBEngineVersions               |
+--------------+--------------------------------------+
|  AutoUpgrade |            EngineVersion             |
+--------------+--------------------------------------+
|  False       |  19.0.0.0.ru-2019-10.rur-2019-10.r1  |
|  False       |  19.0.0.0.ru-2020-01.rur-2020-01.r1  |
|  False       |  19.0.0.0.ru-2020-04.rur-2020-04.r1  |
|  False       |  19.0.0.0.ru-2020-07.rur-2020-07.r1  |
|  False       |  19.0.0.0.ru-2020-10.rur-2020-10.r1  |
|  False       |  19.0.0.0.ru-2021-01.rur-2021-01.r2  |
|  False       |  19.0.0.0.ru-2021-04.rur-2021-04.r1  |
|  False       |  19.0.0.0.ru-2021-07.rur-2021-07.r1  |
|  False       |  19.0.0.0.ru-2021-10.rur-2021-10.r1  |
|  False       |  19.0.0.0.ru-2022-01.rur-2022-01.r1  |
|  False       |  19.0.0.0.ru-2022-04.rur-2022-04.r1  |
|  False       |  19.0.0.0.ru-2022-07.rur-2022-07.r1  |
|  False       |  19.0.0.0.ru-2022-10.rur-2022-10.r1  |
|  False       |  19.0.0.0.ru-2023-01.rur-2023-01.r1  |
|  False       |  19.0.0.0.ru-2023-01.rur-2023-01.r2  |
|  False       |  19.0.0.0.ru-2023-04.rur-2023-04.r1  |
|  False       |  19.0.0.0.ru-2023-07.rur-2023-07.r1  |
|  False       |  19.0.0.0.ru-2023-10.rur-2023-10.r1  |
|  False       |  19.0.0.0.ru-2024-01.rur-2024-01.r1  |
|  False       |  19.0.0.0.ru-2024-04.rur-2024-04.r1  |
|  False       |  19.0.0.0.ru-2024-07.rur-2024-07.r1  |
|  False       |  19.0.0.0.ru-2024-10.rur-2024-10.r1  |
|  False       |  19.0.0.0.ru-2025-01.rur-2025-01.r1  |
|  False       |  19.0.0.0.ru-2025-01.spb-1.r1        |
|  False       |  19.0.0.0.ru-2025-01.rur-2025-01.r2  |
|  True        |  19.0.0.0.ru-2025-04.rur-2025-04.r1  |
|  False       |  19.0.0.0.ru-2025-04.spb-1.r1        |
+--------------+--------------------------------------+

コメント

タイトルとURLをコピーしました