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}'
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 | +-------------------+