Not able to connect to my rds cluster using PG admin

0

I have created my RDS cluster using CFT.

This is the CFT which I used

{
    "AWSTemplateFormatVersion": "2010-09-09",
    "Description": "The template for aurora rds cluster.",
    "Parameters": {
      "tagName": {
        "Type": "String"
      },
      "subnetIds": {
        "Type": "CommaDelimitedList"
      }
    },
    "Resources": {
      "dbSubnetgroup": {
        "Type" : "AWS::RDS::DBSubnetGroup",
        "Properties" : {
            "DBSubnetGroupDescription": "DB subnet group of aurora",
            "SubnetIds" : {
              "Ref": "subnetIds"
            },
            "DBSubnetGroupName" : {
              "Fn::Sub": "${tagName}-subnetGroup"
            },
            "Tags" : [ {
              "Key" : "service",
              "Value" : {
                "Ref": "tagName"
              }
            } ]
          }
      },
      "rdsCluster": {
        "Type": "AWS::RDS::DBCluster",
        "Properties": {
          "MasterUsername": { "Ref": "dbUsername" },
          "MasterUserPassword": { "Ref": "dbPassword" },
          "DBClusterIdentifier": {
            "Fn::Sub": "${tagName}"
          },
          "Engine": "aurora-postgresql",
          "DBSubnetGroupName": {
            "Fn::Sub": "${tagName}-subnetGroup"
          },
          "EnableCloudwatchLogsExports": ["postgresql"],
          "EnableHttpEndpoint": true,
          "Port": 5432,
          "Tags" : [ {
            "Key" : "service",
            "Value" : {
              "Ref": "tagName"
            }
          } ]
        },
        "DependsOn": [
          "dbSubnetgroup"
        ]
      }
    },
    "Outputs": {
      "clusterEndpoint": {
        "Description": "The RDS Cluster endpoint",
        "Value": {
          "Fn::GetAtt": [
            "rdsCluster",
            "Endpoint.Address"
          ]
        }
      }
    }
  }

I am not able to connect with the PG admin, its giving timeout

is there any specific permission requirements?? Thank you in advance

1개 답변
0

Hello.

Is the PG admin running from outside the VPC and trying to connect?
In that case, you need to enable public access and set the subnet in the subnet group as a public subnet.
By the way, you cannot set public access with Aurora Serverless V1, so if you want to use public access, please select V2.

profile picture
전문가
답변함 5달 전
  • Yes, I am trying to connect from outside. Its already been set to publicly accessible and I have sed two private and two public subnet in the subnet group.

    I guess I need to add the (CIDR/IP - Inbound) rule, I tried adding in the security group but its not reflecting in the rds instance security console.

    Any idea?

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠