RDS DB Engine Version Numbering Reporting via CLI

0

Hello RDS SME's,

Below is an output of RDS Postgres versions available on AWS. Since Postgres v10.x, the version numbering has changed from major.minor.patch to major.minor.

Engine | EngineVersion

postgres | 13.7

postgres | 14.1

postgres | 14.2

postgres | 14.3

postgres | 14.4

The patch level was dropped and the only way I can get the patch version is by accessing the DB and running :

postgres=> select version();

However, logging into each DB to get the patch version is not a scalable approach, nor is it secure.

My question is - Is there a way to obtain the patch version from the RDS control plane without requiring access to each individual DB?

For example, MySQL reports major.minor.patch , as does every other DB available in AWS:

Engine | EngineVersion

mysql | 5.7.33

mysql | 5.7.34

mysql | 5.7.37

mysql | 5.7.38

mysql | 5.7.39

mysql | 8.0.23

mysql | 8.0.25

mysql | 8.0.26

mysql | 8.0.27

mysql | 8.0.28

mysql | 8.0.30

FYI, heres the command for getting EngineVersions:

aws rds describe-db-engine-versions --region us-east-2 --output table --query 'DBEngineVersions[*].{Engine:Engine,EngineVersion:EngineVersion}'
1回答
0
aws rds describe-db-instances --db-instance-identifier "database1" --query "DBInstances[*].[EngineVersion]"
[
    [
        "5.7.39"
    ]
]
AWS
モデレーター
philaws
回答済み 2年前
  • Thanks for this. However, this does not work for Postgres DB's. When I run this command on a PG databases, this is the output:


    |DescribeDBInstances| +-------------------+ | 13.7 | +-------------------+

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ