I have a cloudformation stack where i have deployed an RDS serverless v2 cluster and i am trying to connect an RDS proxy to it. The engine is postgres and version is 14.4.
When i deploy the proxy target group i get this error:
"Unsupported Database engine or engine mode for DB Cluster"
I have tried deploying from the console and the dropdown menu under the target configuration is also blank.
Here is an example of my SAM configuration:
RDSDBProxy:
Type: AWS::RDS::DBProxy
Properties:
DebugLogging: true
DBProxyName: MetenDBRdsProxy
EngineFamily: POSTGRESQL
IdleClientTimeout: 120
RequireTLS: true
RoleArn:
Fn::GetAtt: RDSDBProxyRole.Arn
Auth:
- {AuthScheme: SECRETS, SecretArn: !Ref MetenDBMasterUserPWSecret, IAMAuth: DISABLED}
VpcSubnetIds:
- !GetAtt MetenSubnet1.SubnetId
- !GetAtt MetenSubnet2.SubnetId
- !GetAtt MetenSubnet3.SubnetId
ProxyTargetGroup:
Type: AWS::RDS::DBProxyTargetGroup
Properties:
DBProxyName: !Ref RDSDBProxy
DBClusterIdentifiers: [!Ref MetenDBCluster]
TargetGroupName: default
ConnectionPoolConfigurationInfo:
MaxConnectionsPercent: 100
MaxIdleConnectionsPercent: 50
ConnectionBorrowTimeout: 120
And here is my DB cluster for reference:
MetenDBCluster:
Type: AWS::RDS::DBCluster
DeletionPolicy: Delete
Properties:
Engine: aurora-postgresql
EngineVersion: 14.4
DatabaseName: !Sub "${Environment}${DBName}"
BackupRetentionPeriod: 15
EnableCloudwatchLogsExports:
- postgresql
DBClusterIdentifier: !Sub "${Environment}-meten-db-serverlessv2"
DBSubnetGroupName : !Ref MetenDBSubnetGroups
EnableHttpEndpoint: True
# TODO: Add the master user name and password later on for security
PreferredBackupWindow: 03:00-04:00
MasterUsername: !Sub '{{resolve:secretsmanager:${MetenDBMasterUserPWSecret}::username}}'
MasterUserPassword: !Sub '{{resolve:secretsmanager:${MetenDBMasterUserPWSecret}::password}}'
ServerlessV2ScalingConfiguration:
MinCapacity: 0.5
MaxCapacity: 2