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 réponse
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
EXPERT
répondu il y a 5 mois
  • 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?

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions