rds: support for local write forwarding for an Aurora PostgreSQL cluster

[go-to-k]

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

[ashishdhingra]

• Confirmed from Local write forwarding in Aurora PostgreSQL that Amazon Aurora PostgreSQL now supports local write forwarding. This support was added recently.
• AWS::RDS::DBCluster supports EnableLocalWriteForwarding property.

@go-to-k Unsure if CloudFormation yet supports this for Aurora PostgreSQL since it takes time for CF to support it. Please check if using escape hatch works for Aurora PostgreSQL and CF doesn't throw any error.

[go-to-k]

@ashishdhingra

I haven't tried escape hatch, but I was able to deploy CFn with the integ test, so I guess it meets the requirements?

[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.

[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.