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 Resposta
0
aws rds describe-db-instances --db-instance-identifier "database1" --query "DBInstances[*].[EngineVersion]"
[
    [
        "5.7.39"
    ]
]
AWS
MODERADOR
philaws
respondido há 2 anos
  • 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 | +-------------------+

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas