Describe the feature

Amazon Aurora PostgreSQL now supports local write forwarding:

Whats new: https://aws.amazon.com/about-aws/whats-new/2024/10/amazon-aurora-postgresql-local-write-forwarding/

Reference: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-postgresql-write-forwarding.html

Use Case

The current CDK L2 construct only supports the feature for MySQL, but PostgreSQL needs to be supported as well.

Proposed Solution

No response

Other Information

No response

Acknowledgements

• I may be able to implement this feature request
• This feature might incur a breaking change

CDK version used

2.162.1

Environment details (OS name and version, etc.)

Mac