rds: AuroraPostgresEngineVersion contains invalid versions

[tmokmss]

Describe the bug

As per doc https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Updates.20180305.html, we can get the available Aurora postgres versions with the following command: aws rds describe-db-engine-versions --engine aurora-postgresql --query '*[].[EngineVersion]' --output text --region aws-region

Given the output, at least AuroraPostgresEngineVersion.VER_16_6 is not supported yet.

Regression Issue

• Select this option if this issue appears to be a regression.

Last Known Working CDK Version

No response

Expected Behavior

AuroraPostgresEngineVersion contains already available versions.

Current Behavior

AuroraPostgresEngineVersion contains not-yet-available versions.

Reproduction Steps

Deployment of Aurora cluster with AuroraPostgresEngineVersion.VER_16_6 fails.

Possible Solution

No response

Additional Information/Context

No response

CDK CLI Version

2.170.0

Framework Version

No response

Node.js Version

22

OS

macos

Language

TypeScript

Language Version

No response

Other information

No response

[nmussy]

Version availability varies by region, in this case it's available in us-east-2 but not us-east-1:

$ aws rds describe-db-engine-versions --engine aurora-postgresql --region us-east-1 | jq -r '.DBEngineVersions[] | select(.EngineVersion=="16.6") | .EngineVersion'
$ aws rds describe-db-engine-versions --engine aurora-postgresql --region us-east-2 | jq -r '.DBEngineVersions[] | select(.EngineVersion=="16.6") | .EngineVersion'
16.6

[tmokmss]

@nmussy wow thanks. I thought us-east-1 is one of the most up-to-date region but it seems not. Aurora Postgres 17 also looks only supported in Ohio (ref). Closing the issue 🙏

[github-actions]

Comments on closed issues and PRs are hard for our team to see.
If you need help, please open a new issue that references this one.