I'm trying to create a RDS DB Proxy for a Postgres 12.3 RDS instance (not Aurora) via CloudFormation. Stack creation fails with the following message:
Database engine POSTGRES 12.3 for DB Instance db-name is not supported. Register the DB cluster instead of DB instance, or use another DB instance that is supported. (Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterValue; Request ID: ...)
I cannot find any documentation on which DB instances are supported, i.e. will Postgres 12.2 be OK? Will configuring a cluster make any difference? From the documentation I've seen it appears only Aurora databases support clusters so that may not be an option.
According to this Amazon blog post RDS proxies for Postgres are now 'generally available'.
EDIT: 11.2 also fails Database engine POSTGRES 11.2 for DB Instance db-name is not supported.
I finally managed to find some information in another blog post - not the first place I'd look for RDS documentation but apparently this is all I'm going to get.
According to https://aws.amazon.com/blogs/aws/amazon-rds-proxy-now-generally-available/
Currently, RDS Proxy is available for the MySQL and PostgreSQL engine family. This engine family includes RDS for MySQL 5.6 and 5.7, PostgreSQL 10.11 and 11.5.
Supported versions are listed in the Amazon Aurora documentation located in the following path:
Configuring Your Aurora DB Cluster => Connecting to a DB Cluster => Managing Connections with RDS Proxy
Here's a link directly to that section. You will find supported versions of DBs under the header "Limitations for RDS Proxy"
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html#rds-proxy-setup