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}'
AWS
kav9
posta 2 anni fa250 visualizzazioni
1 Risposta
0
aws rds describe-db-instances --db-instance-identifier "database1" --query "DBInstances[*].[EngineVersion]"
[
    [
        "5.7.39"
    ]
]
AWS
MODERATORE
philaws
con risposta 2 anni fa
  • 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 | +-------------------+

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande