0

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
Rishfilet
  • 61
  • 5

0 Answers0