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 Answer
0
aws rds describe-db-instances --db-instance-identifier "database1" --query "DBInstances[*].[EngineVersion]"
[
    [
        "5.7.39"
    ]
]
AWS
MODERATOR
philaws
answered a year ago
  • 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 | +-------------------+

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions